New to Appian

On my Appian application website, I have used two record views using a single database table. Now I am using a radio button with the choice value Yes & No. If I select Yes the row should go to another record view if I select No it should be on the same record view on the website. Please suggest to me how to write the conditional statement to achieve the expected result.  a!radioButtonField( label: "Move to NOC Standard Handover", labelPosition: "ABOVE", choiceLabels: {"Yes","No"}, choiceValues: {"Yes","No"}, value:ri!record['recordType!{2eff113d-30b2-4e57-8fa0-e59fe7e0115e}NH Handover.fields.{d6c838a0-cfff-4d11-bff4-e6a26c63564f}standardHandoveritems'], saveInto: ri!record['recordType!{2eff113d-30b2-4e57-8fa0-e59fe7e0115e}NH Handover.fields.{d6c838a0-cfff-4d11-bff4-e6a26c63564f}standardHandoveritems'], required: true, choiceLayout: "COMPACT", validations:{}

I am trying to use record type's export to excel feature for that I need to convert my data which is in list of maps (image below) to record type. Please hep me with it.

Hi, I need to compare two Hebrew names if they are equal. Tried using exact function, regex but it doesn't work as expected. Thanks, Preethi

Hi All, I have two interfaces in which one is embedded to another. Is that possible to pass value from one to another without submitting the form or by just selecting the dropdown value in one interface? Thanks in advance.

Hi, I have an array like this wherecontains(2,{1,25,32,4}) I want to get 25 and 32 out from this. I will just pass 2 to this array as search parameter.

Hi, I have a requirement to upload the documents from knowledge center to external system using webAPI.  For this requirement should I be using get web API or put Web API? Also do we need to use integration object to use webAPI for this requirement? Thanks

 I want to upload the file and save it into the database in integer form. How can I do it?

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