New to Appian

I am trying to  follow the course and under configure the record list. I have created my Interface and when U drag over the read only grid I keep getting the system has encountered an error & the code is HTTP Code 503. Anyone know a work around for this.

Once the user submits the portal form, we have to show the case Id with the message " FORM SUBMITTED "  which the user submits Appian portal form.

Hi there! I am trying to have createdBy updatedBy and updatedOn section reflect current changes in the record list when updated for an internal tool. So for instance when a user creates a new question or updates a question, I would like the record list to display that users info in it's own respected column. As of right now I am using loggedInUser() and now() but it is only showing my information all throughout the questions. So really what I'm asking is what do I need to change in the display tab of the records list to have this action work properly. Any help is appreciated!

Hi Experts, Kindly help me to impletment the Audit Log Functionality, Requrirement is as if any fields get updated to a new value, I have to show the Field name shich got updated along with its Previous Value and New VALUE along with Who has done the update and WHEN i.e if Original value is a!map( id:1, fName:"ABC", lName:"XYZ", DOB:11-05-1995, phone:"1234567890", ) and updated value is a!map( id:1, fName:"CDF", lName:"XXX", DOB:11-05-1995, phone:"1234567890", ) Serial number Field previous value New Value Updated By Updated On 1 fNamelName ABCXYZ CDFXXX (Username) (12-10-2022) 2 Thanks

I am on the Exercise where I have to change the image to a document image I was initially getting an error as it was like the documents was missing there but managed to add the images to my app. I have keyed the code under the expression editor. a!imageField( images: a!documentImage( document: fv!row['recordType!{c20ff609-5f40-4fea-8800-074abc464c7c}AX Vehicle.fields.{f1cb1cdc-1134-40e8-b30b-0b90d32da455}vehicleimage'], caption: fv!row['recordType!{c20ff609-5f40-4fea-8800-074abc464c7c}AX Vehicle.fields.{f1cb1cdc-1134-40e8-b30b-0b90d32da455}vehicleimage'] ), size: "SMALL") I now get this error below.

Hi, when I am creating the record type using an entity that contains transient value it's throwing an error. ERROR: "Preview currently unavailable due to an error on the source" I have checked the data source multiple times by doing save and publish and the data source not showing any error, it is successfully publishing. can anyone please help me with this error ...

Where can I find the Appian Foundations Learning Path or Course? When I go to Appian Academy, I see courses for Seller, Planner, Administrator, Builder, but none of them contain a course or Learning Path entitled Appian Foundations, which is mentioned on Appian Customer Case Studies page Lesson 6 of 6?  Thank you!

Hello, Please could someone help me on what I need to write in the Related Action configuration of the Delete button for it to work and delete the record from site as well as DB.

Hello, I want to Edit the EXAM Table  The edit button is working but instead of updating the record it's creating new record. What exactly am I doing wrong? Also, I want a delete button which will delete the record from the SITE as well as DB. What do I need to do for that button to work? Could anyone please help me.

Hello, I stumbled upon a little problem with IDP. When I extract data from Appians built in IDP, the document is processed nicely, I can see the document clearly. But when I created a process from tutorial:  https://docs.appian.com/suite/help/22.4/create-doc-extraction-process.html  I can see something like this in Reconcile form: It looks like Appian does not recognize language, except 2 words, and whats stranger for me, extracted data is fine, both from auto mapping and from manual extract. What may be causing this situation and whats more important, what can be the solution?  I'm trying to skip reconcile part, but I would like to show to my supervisor some results and I want to get rid off the view like in screenshot above. Also one more question about IDP and its "learning".  Does IDP learn only when it writes data to database? In the built in IDP, when i uploaded few files, there is a progress with how well he captures d

I have been using the 'Send Email' node recently, and after a while (and some trial and error) I realized the node was sending the emails to my spam folder. Is there a way to specifically tell the node to send it to a specific folder/inbox (such as my main inbox)?

Hi,I had a requirement, has to provide a link for the box layout header, 

can anyone please give suggestion how to resolve this error ?

An error occurred while trying to write to the entity "StudentEducationDetails" [id=d95007c3-ee01-472a-b90c-0dbf8570a6e0@5696, type=StudentEducationDetails (id=4074)] (data store: StudentBasicInformation). Details: javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: could not execute statement: org.hibernate.exception.JDBCConnectionException: could not execute statement: java.sql.SQLTransientConnectionException: (conn=468975) Data truncated for column 'StartYear' at row 1: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Data truncated for column 'StartYear' at row 1: java.sql.SQLException: Data truncated for column 'StartYear' at row 1 Data: TypedValue[it=4074,v={<null>,<null>,Jabar,B.tech,2017-11-01,2021-12-07,90,1,2022-11-28 04:30:00.0,NRT}]

error is : ???An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.???  I have an excel with 4 columns  Column names are same. I don't understand the error. File name I am passing as process variable. Number of columns to be read is 4 as i have 4 columns in file. Table name is my datatype name and data source is jdbc/mydatabase. What am I missing? 

Please help me check if the given number is between 1 & 20 digits and doesn't contain any alphabet in it. Like we have like(fv!item,"[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]") to check the given number should be exactly 10 digits and no alphabets in it.

Hi, I am facing a strange issue.. pls let me know if you can see where the problem is or if you need more data to answer this feature is - when an user deletes a record in a table (noc_area) - I am trying to capture the details of noc_area to another table noc_area_audit + 3 more fields. I am triggering this inside the delete function at saveInto rule inputs are areaaudit and record areaaudit is CDT  record is CDT so when the user is deleting a record.. I am capturing the  1) areas (text) from record and passing it to areas (text) of areaaudit 2) areavalue (integer) from record and passing it to areavalue (integer) of areaaudit 3) areacomment (text) from record and passing it to areacomment (text) of areaaudit ------->>>>>>> not happening and some hardcoded and system generated values to the remaining fields of areaaudit.  When I delete a specific record all values are getting successfully populated except for areacomment. It is space

How to auto refresh a page that is being called in a site. for example, when I click on Change Department and fill the form and submit. the changes must be reflected on the User screen without refreshing manually

Hi, i am looking how to achieve multi transaction using Appian. Is there any bottleneck  to achieve this? e.g parent and child transaction should commit at the same time. Thanks in advance Chetanshi

I started the process with an interface (Create Exam) and then I want to store it in the database, but I guess there is some problem with the database or Record type, Can anyone please help me understand what I am doing wrong?  

Hello Everyone,This is AEW live build challenge demo. I want to write the value to WINNER_COUNTRY_ID OF the database table WC_COUNTRY.I want to select the country name from WC_COUNTRY.Can you give me some ideas how to work on this process.

How to call a record view in an interface.

Hi All,I was trying to show tasks related to the order  in that order details interface, I was trying to write code but most of the time it comes half baked.I would like your help in this case. I understand I need to use looping, indexing and if condition to get this done , But I was not able to get the correct form of logic.  If any sample code is available for this scenario is very helpful for me to understand.Thanks in Advancefor example(The desired outcome), below for an order it is showing approval task related to that order:

Dear All,I am very new to Appian, kindly guide me how to get MyAppian page in Appian Community Cloud Platform. Guess, it's available on paid version only, in this case, I am trying to upgrade from community to paid version, but I am unable to do, please guide me, I have gone through the documentation. But couldn't solve my problems.Mainly I want to connect my existing Cloud Databases (Azure SQL Database & Aurora MySql database) to Appian Cloud platform. Your early response is highly appreciated. With best regards

Hi In my task report there are 3 active tasks, but when I tried to query that report in Interface it is only showing 2 active tasks.Can you please help me to know what is the issue?Code for the same:a!localVariables( local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ), local!report: a!queryProcessAnalytics( report: cons!TS_Constant_Process_Approval, query: a!query(pagingInfo: local!pagingInfo) ), a!gridField( label: "My Tasks", instructions: local!report.description, data: local!report.data, columns: a!forEach( items: local!report.columnConfigs, expression: a!gridColumn( label: fv!item.label, sortField: fv!item.field, value: if( fv!item.configuredFormatting = "TASK_STATUS", index( { "Assigned", "Accepted", "Completed", "Not Started", "Cancelled", "Paused", "Unattende