Foundation

How to do mathematical calculations based on the received value. Example : «${d.cost.price}» * «${f.quantity}» how to product of these two values and what is format to use to get the final result of this product. even for addition. Please suggest .Thanks in advance.

a!fileUploadField( label: "File Upload", labelPosition: "ABOVE", target: cons!TI_SAVEDFOLDER_CONSTANT, fileNames: "Test1", maxSelections: 1, saveInto: local!file ) use above code to upload file in folder inside Appian using constant.

I am using Record type to show the selectable Grid and I need to take action after selecting multi records. I can do it by capturing selected values and pass it to start process via button but want to know if it is possible to do it via Record configurations like record action?

Hi Everyone ,  I need to convert Appian document to base64 . How can i achieve this .  thanks in Advance

Hello Everyone, I am trying to pass the data into the word document but facing an error.I have followed the required annotations for the girds even though couldnt able to run sucessfully. Please suggest if anyone also faced the same problem or how to resolve. Thanks in advance.

Hi All, One of the user from our organization has left he has some 300 active task's assigned to his name, how we can close this task's.  Thanks in Advance

Hello, I'm in Japan and my  time zone is  : Osaka, Sapporo, Tokyo (UTC+09:00). I'm planning to take the Appian Associate Developer Exam. When I try to schedule the exam, I need to select the time as shown below. I'd like to know does it refer to my local time or standard UTC time. Thanks

Hi, I have an interface with editable grid (a!gridLayout) where I am trying to add a new row with required elements when user clicks on "Add Dcoument". I have to achieve the below requirements. Not 100% sure whether it can be done or not. 1. If any one of the field / element filled with data, other fields/elements should be filled with.  2. Also, there should not be any row with empty empty fields/elements. When I try to write a validation in the Document Title field, then it is applying to all the rows of that field when I click on the "Add Document". Not sure how to handle for row by row.  required: if(a!isNotNullOrEmpty(ri!Documents.documenttype),true(),false())

In a form, Suppose I have 3 values in my dropdown- A,B,C.  I have chosen A and filled the remaining text boxes accordingly, but I want to change the dropdown value to B. On changing i want the remaining values of the boxes to be empty so I can fill them again. How can I achieve this?

Hi team, I been pondering and I would like to disable only the "direct approve" option upon conditions met. Is that possible? a!localVariables( local!choiceLabels: { approve, reject, direct approve, direct reject }, a!radioButtonField( label: "This application is recommended for", labelPosition: "ABOVE", choiceLabels: local!choiceLabels, choiceValues: local!choiceValues, value: ri!recommendedFor, saveInto: {}, disabled: since it allowed only true()/false()? )

a!cardLayout( contents: { a!columnsLayout( spacing: "DENSE", columns: { a!columnLayout( contents: { a!sideBySideLayout( items: { a!sideBySideItem( width: "2X", item: a!richTextDisplayField( value: a!richTextItem( text: " Validate Lead Viable", style: "STRONG", size: "MEDIUM_PLUS" ) ) ), } ) } ) } ), a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "Does this lead have INN Facility Privileges?", helpTooltip: "Privileges not applicable if its a PT/OT/PCP", labelPosition: "ABOVE",

Hi, Can we change the color of the card template tile from accent to some color of our choice ? 

Hi everyone Here's my scenario: I need to use a Group Browser object for the user to be able to select a group from a list . I can set the initial group as All Users, but that includes groups that may not be selected, such as Administrators. It would seem my easiest method would be to create another group which lists only the desired groups, but I've been told that nesting groups within groups is bad practice. Any thoughts? Blessings Stephen 

Hello, I'm new to Appian, and I'm trying to build main page report which is quite similar to this "Form steps". However, each step has to show specific interface by using rule!tInterface1. My question is how can I check the validation for all of these steps at the end of the report and show a summary for all of the errors, e.g. "Step1 has an error". P.S. an error sign appears by "default" in the section that contains an error, Can I check if the section has this sign or not? Thank you in advance!

By clicking on relation action button present on summary page, user should redirect to summary dashboard of newly created record . Is there any possibility like this? Can anyone pls suggest me a solution for this?

Good day, I'd like to implement a search function in an interface, but I'm struggling to make it work. Once the user types in a search term and presses the search button, the appropriate results should return. The code :  a!localVariables( local!search: false, local!searchTerm, local!searchTitles: { "Amadori", "Telpark", "Microsystem", "Kone" }, local!searchData: a!dataSubset( data: rule!JT_CONS_CASE_STUDIES(), batchSize: - 1, startIndex: 2, sort: a!sortInfo(field: "title", ascending: true) ), local!searchField: index( local!searchTerm, wherecontains(local!searchTitles, local!searchData) ), { a!sectionLayout( label: "", contents: { rule!JT_uiCaseStudyDashboard(numberOfColumns: 3) }, showWhen: local!search, isCollapsible: true ), a!sideBySideLayout( items: { a!sideBySideItem( item: a!textField( labelPosition: "COLLAPSED", placeholder: "Search Use Cases", value: local!searchTerm, saveInto:

Hi, I have a requirement to send certain email based on few business rules. Also based on some logic ,we need to send email by passing priority High or Low dynamically. But with the send email smart service which we have , its a dropdown and we can't pass this value via expression editor. Any way to achieve ?

On file upload I want to change [Document:1234] to fileName.png.Here is what I have currently I've tried various expression inBut whatever I do, I don't get the filename saved in a variable.Things tried include (but I may have done them wrong): using a a!map using the document(documentId,"name") however [Document:1234] is not a number using a!replace(pv!file,"Document:",""), and that did not work I simply need to get the Document Id value so that I can use the document() function.I feel that I'm running out of things to try.Here is my input

Any idea on how to cast cdt to record type

Hi, Can someone guide me on the requirement. I would like to know what type controls I can use to achieve this. 1. Display the data in a grid format with a link under Sno column data. 2. "ADD" button on top right. When the user clicks on that I need to show a separate screen with F. Name, L.Name, Address text fields and allow to click on "SAVE". Once user clicks on "SAVE", data should save to the database and come back to the below screen. 3. If user clicks on the data link under the Sno, then I need to open show a page with F.Name, L.Name, Address with text fields and need to load respective data, once if they modify and click on "SAVE", I need to save the updated data and come back and load the below page. ADD Page EDIT Page

Hi, what we need to do if process model is consuming a lot of memory and due to  this appian environment getting very slow.I have already set archive (3) day from data management tab. Is Manually delete processes that have already been completed or cancelled is a another good option?

Hi All, We encountered a challenge with the Radio Button Component. Under certain condition it is loosing or 'forgetting' the selected radio button. We are using it to display the status in a workflow. Based on the users role and the status the entity is in, only certain options can be selected, so we are adjusting the choices. Below is a code example what we are doing. As you might see, if you select option 3, it stays only a split second on the UI and then the selection disappears. And yes - we alreadyhave submitted a support ticket to Appian, but it looks like the component will not be changed.  Any suggestions how to overcome this? We have our own ideas, but would like to see first what the community will contribute.(We will publish our version tomorrow). Thanks a!localVariables( local!selection:1, local!choices:a!refreshVariable( refreshAlways: true, value: if( local!selection = 3, {1,3}, {1,2,3} ) ), { a!radioButtonField(

Hi , My process was getting errored out at Parse XLSX file node saying  Error: An error occurred while evaluating expression: Output:rule!s_CRDoc(pv!changeRequestFile_doc) (Expression evaluation error in rule 'c_doc' at function 'readexcelsheetpaging' [line 8]: com.github.pjfanning.xlsx.exceptions.OpenException: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Invalid byte 1 of 1-byte UTF-8 sequence.) (Data Outputs)

So I have an interface that is saving two array of CDTs the idea I was having is that it would store each iteration of the array into its own respective row for the array example: {[uuid:1, fkuuid: ab32, date: today], [uuid:2, fkuuid: cd43, date: tomorrow]}. In the database there would be a row for UUID 1 and a row for UUID 2 but when I execute the write to data store entry I only get uuid 1. To push this even further I am doing this two times for separate tables and its only putting 1 entry into 1 table.  If there is any more information that is needed let me know! Any Ideas on how to get it to save all the information in the array of cdt to each of its separate rows?

When should we re-deploy an application vs. using a patch?