New to Appian

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

Lesson 4 Exercise: academy.appian.com/instructs me to "Log into your Appian Community Edition environment, and select the Acme Exercise application."I cannot locate "Acme Exercise" where I could work with an Expression Editor."Acme Solution Site" takes me to https://swmi.appian.community/suite/sites/acme-exercise-sitebut  I am not able to locate an Expression EditorWhere is "the Acme Exercise application"?

Hi All, "Request Re-Opened Details are updated" should change to "Request reopened details are updated" can anyone please help on it Regards, Supriya

Hii All, I want to know how to maintaine audit log like if I have an any request form then I fill all the fields and submit the form. Then the form is submitted and then user wants to edit some fields in the form & submit it. 1)How to show those changes in grid for every Action(create request, update, cancel)? 2) How to show all the activity for that request?

Hi All, How to get the tasks which are requestedOn/created today, Need to return only today's date & time requests thanks in advance

How to index department from one of the index where empId is same as loggedin user Id. here allUsers stores Record data.

For example, I have process variables arrays         name : {"a","b","c","d"},         age : {1,2,3,4},         email : {"@e","@r","@t","@w"}and I have a CDT which has {name,age,email} How can I save those array values in my CDT  in process model? bcz when I try to use script task to save the array values in CDT and write in the db using cdt  then only first row is getting written in db.

Hello I am using Appian 22.4 version & Using Appian, I need to create Login Page which I did (Using Interface) but what configurations are needed to Validate it with the database and check if the Username and Password are correct or not, if correct and then only redirect it to DASHBOARD page Till now I have made the pages using Interface, but I am confused because END Users will be using Tempo/Site and not Interface Can someone please guide me on these issues

a!localVariables( local!chooser:1,{ a!columnsLayout( What I did here is I created 4 different interfaces (Create New Exam", "Manage Exam","Attempt Exam","Exam Analysis) and now I want all these different interface inside one interface i.e The one I am working on which is facing this error. What I want is to use Radio button and when I click on 1st option I want the 1st interface(Create New Exam) to display and for option 2 the 2nd interface and so on. How can I resolve this error or maybe other way to bring the interfaces in one single one? Below is the code for the 5 the interface I am working on columns: { a!columnLayout( contents: { a!radioButtonField( label: "Exam Module", labelPosition: "ABOVE", choiceLabels: {"Create New Exam", "Manage Exam","Attempt Exam","Exam Analysis"}, choiceValues: {1,2,3,4}, value: local!chooser, saveInto:local!chooser, choiceLayout: "STACKED", validations:

I'm passing multiple values in fields above except id (Id field is emoty as i have cofigured in cdt as autogenerate),Like paasing a code in userId which returns {2,2,2,2}code in product id returns {1,2,3,4}code in userProduct quantity returns {100,55,68,75}code in total price returns {100,230,45,67} isactive is trueCan you help me what is the issue here?

What's the difference between thingworx composer and Appian?

Hello! I have a problem of following type: a!localVariables( local!emptyArray: {}, ... { ... a!forEach( ... a!localVariables( local!variableWhichChangesWithEveryIteration:{...}, { /* Here I want to append the local variable's value to my empty array. Something like this: */ a!save(local!emptyArray, append(local!emptyArray, local!variableWhichChangesWithEveryIteration)) } ) ) /* my array will be used here */ } ) The problem is that value of the array won't refresh by itself (if I use saveInto in a textField, for example) and I don't know how to do it automatically...

Hi All,         I have used date field components.In that   I have two buttons with it like submit and cancel. When ever I enter invalid date and cancelled it and I again edit it it showing the invalid date as a default even though it is not storing in any of the localvariables. Any leads can be really helpful .. Thanks & Regards Divya

After creating 11 Step I got error like this when I entered AX Vehicle Record type beside the icon The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = :] at function a!recordList: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 49]: The image at index 1 in an image gallery component [label=""] has an invalid value for "document". "document" must not be null. (APNX-1-4198-000) can any one help me how to solve where I get this error what to chage

Hi ,I have created a interface in which when I selected a product in "Add product in Cart", It should be populated in Picked products and will show quantity input field. But I don't know  how to store the quantity input  values for different quantity fields, for example If I give quantity value 12 for Soaps it is showing 12 for all product's quantity.Thanks in advance.Code for the same below:a!formLayout( label: "Buy Products", contents: { a!sectionLayout( contents: { a!richTextDisplayField( label: "User", labelPosition: "JUSTIFIED", value: user(loggedInUser(), "firstName") ) } ), a!sectionLayout( label: "Add Products in Cart", contents: { a!sectionLayout( label: "", contents: { a!pickerFieldRecords( label: "Pick Products", labelPosition: "ABOVE", maxSelections: 20, recordType: 'recordType!{886fbcf9-c44b-4cc9-bb6e-76529b93d6e5}TS_RecordType_Product', value: ri!productsSel

How can i change date picker default format to DD-MMM_YY format default format is mm/dd/yy.

Hi team, Is there any way by which I can authorize the endpoints if the token expires without manual intervention? I can see we can use authorizationLink but that requires manual intervention. Thanks,

Hi, I have a decimal field on my interface that I want to colour based on its value..something like if =8: then green if <>8: then blue How do I do that??  I know how to colour a text field. Please help thanks jaideep

Hi, Is there a way I can see on Appian logs as to who has made changes to the data.. for eg.. who created a certain record, who updated it, who deleted it and so on.. i tried looking for this info in tomcat-stdOut.log but cudn't get.. or do I need to create/code my own history table where I should track these user actions? thanks in advance jaideep