Foundation

a!dropdownField( label: "Deposit Amount", labelPosition: "ABOVE", placeholder: "--- Select ---", choiceLabels: a!forEach( items: rule!CD_QE_Get_Amounts().data, expression: fv!item.amountFrom & " - " & fv!item.amountTo ), choiceValues:a!forEach( items: rule!CD_QE_Get_Amounts().data, expression: fv!item.amountFrom & " - " & fv!item.amountTo ), value: {local!DBben.Amount}, saveInto: {local!DBben.Amount}, searchDisplay: "AUTO", required: true, validations: {} ) Hello All,  I am facing this error "has an invalid value for "value". All selected values must be present in the choiceValues array, but value was -∞ and choiceValues was 100000 - 500000; 500001 - 1000000; 1000001 - 2000000;" any advice ?

Hello, The categories of column char showing one 1st at its index. The column chart is as follows: series: local!columnSeries:a!forEach( items:local!months, expression: a!localVariables( a!chartSeries( label: fv!item, data: a!localVariables( local!count_usage:where(local!months=cast(typeof(local!months), fv!item), 0), if( length(local!count_usage)=0, 0, index(index(local!localCbProcessess.data, "id_count", {}), local!count_usage, 0) ) ) ) ) ) Column Chart field: a!columnChartField( categories: local!months, series: local!columnSeries, xAxisTitle: "Months", yAxisTitle: "Usage", stacking: "NONE", colorScheme: "CLASSIC" ) categories data sanp: the chart is not sho

How to populate a dropdown list of years between 1990 to 2023 using enumerate function

I have a process model that has multiple sub processes for a project. Each sub-process references the project name that was created at the beginning of the process. The project name is retrieved by calling a rule that then saves to a process variable. At a sub-process further down the life-cycle, there is a user task (a) and the process is waiting for the user to complete the task. Outside of this process model, anyone can go and update the project name. The name is then updated in the database. My issue is that at this point (a) while waiting for the user task, the project name is not being updated even though the database has a new name and  the process variable being reference is calling a rule to get the project name. All further sub-processes after (a) gets the updated project name. Only at (a) where the task was waiting to be completed when the name change occured, is not updated.  Does anyone have any idea of how to resolve this?

We are experiencing an intermittent problem with Send Email node in a process. On the front end, the error is 'Failed to send email'.  On the stdout log, it is stated that the error is caused by: 'jakarta.mail.AuthenticationFailedException: 535 Incorrect authentication data - https://community.mimecast.com/docs/DOC-1369#535'.  According to the given Mimecast web-page, error 535 is due to 'Incorrect authentication data'.   The sender and receiver in this instance was the same as multiple other instances in the same day, which worked as expected, with email going out and being received successfully. Any ideas? Thanks for taking the time to consider this.

Hi All, What is the best way to create multiple appian users from a list of usernames from the database (Each record has the necessary information for the user, name, last name, email etc) ? I'm just confused of how to set up the create user node for multiple users in this case. thanks in advance

The Health Check for my application, for process sizing, has 3 process models that are all taking up about 16GB and 32,000 # of instances.If I reduce the archiving from 3 days to 1 days on each process, it should cut out 10GB and about 22,000 instances.  Would doing this have any positive impact on the applications performance as a whole? Would it free up resources or processing engines in any way where I could see improvements on process models?Right now, I'm seeing sometimes my write to data stores taking .90 ms in some cases and then in other cases, taking up to .300ms (which is too long)  For context, my prod environment has about 853,000 process a day (585,557 completed, 183,000 active)

Hi Team, I have requirement to run on scheduler to create case based on configuration and export some transactional data in the excel file, send an email. In the excel there is one column with datetime type is one of the columns and in the excel always it is exporting as the usertimezone. Example: This scheduler PM always run around 01:00 AM CST and last published designer time zone is GMT.As this user is administrator across platform level, so don't want to change user time zone to CST. Please find below items for reference. 1. I have run the PM in the CST timezone,Stil in the exported excel file taking the last published Administrator account time zone (GMT). 2. I can do it in data base, but i don't see any dynamic function to convert automatically handle daylight savings (Without hardcoding +06:00 hours..etc). Can you please help me out to export excel the column data datetime as CST timzone. Thanks and Regards Venkatesh Suram

Hello Guys there is a problem with my Process Model, Below is the Image of error in PM, 

Can anyone help me, Is there any option to delete document from SharePoint by using Appian.

I am displaying a menu of links for viewing various Record Lists from an interface.  How can I display a Record List for specific record type? a!headerContentLayout(  header: {    a!cardLayout(      contents: {        a!richTextDisplayField(          labelPosition: "COLLAPSED",          value: {            a!richTextHeader(text: "Reports")          }        )      },      height: "AUTO",      style: "#666666",      marginBelow: "NONE",      showBorder: false    )  },  contents: { 

Hello, I have a multiple dropdown where sometimes so many values are selected that it is hard to find them in the list. Is it possible to have a multiple dropdown sort by the values that are selected? For example, in the below screen shot you can see all of the selected values highlighted in blue. Is it possible to have the dropdown sort by showing the highlighted/selected values at the top of the dropdown list? This would make it easier to remove values that we need to when editing/updating. Thanks in advance!

Hello, Please let me know if we can generate the password protected excel using Appian? or make the generated document password protected? Thank You!!

I am working in a planning poker App, and I'm trying to refresh the values for all users at the same time automatically after some record action is executed. I just don't want to complete the action via dialog window, is there any way for doing that or am I doomed?

Hi All, Its very urgent. I am facing an issue with removing <style>......</style> from the HTML text. I want to remove all the text/special character/all the property between style tag. <html><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style> <!-- @font-face {font-family:"Cambria Math"} @font-face {font-family:Calibri} p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; font-size:11.0pt; font-family:"Calibri",sans-serif} span.EmailStyle17 {font-family:"Calibri",sans-serif; color:windowtext} .MsoChpDefault {font-family:"Calibri",sans-serif} @page WordSection1 {margin:72.0pt 72.0pt 72.0pt 72.0pt} div.WordSection1 {} --> </style></head><body  style="word-wrap:break-word"><div class="WordSection1"><p class="

Hi Everyone, Is there any way to include radio button instead of check box in read only grid for selection?

Hi there, I have created a button to generate CSV file but after clicking on button- page redirects to home page. I want to create document link when clicking on button so that file get downloaded. How can I do this in interface? Thanks

Hi All, Is it possible at all to edit the reassign task screen? I want the user to be able to only select a certain number of groups not all the ones available in the application itself. thanks in advance

Hi All, Currently we are able to configure custom DL email ID (eg: testmail.com) in tomcat server for Appian process alerts (Appian process alerts which we will receive when process got failed or error).But how to configure Subject (eg: PROD) in tomcat server, so that if any Appian process fails or error we will receive process alert with Subject displaying PROD. This will helpful to identify the Production environment process alerts. Please let us know if more details needed. Regards,Sandeep

Hii, I am getting this error while clicking on record Action: An error occurred while applying the context for the GAI Grant related action [identifier=253]. Details: The record data does not exist, has been deleted, or you do not have sufficient privileges to access it. How can i resolve this ? ), a!gridColumn( value: a!recordActionField( actions: a!recordActionItem( action: 'recordType!{8b4ab8ba-4c5b-4a6e-bf36-23ee7bb475b3}GAI Grant.actions.{4e3745c4-618f-44fe-a3de-3c29fd228894}editProjectObjective', identifier: { appId: ri!appId, projectObjectivesId: fv!row['recordType!{0b254c54-d92c-4674-a733-f9a9e4e2b147}GAI Application Project Objective.fields.{bd9fc329-44b3-4179-bd65-a400aee6091c}projectObjectivesId'] }

I have an interface created, It is an employee onboarding form, it is there on the website , so once an employee fills the form, the details gets stored to database table, now my database table is populated with the new employee detail. I have another tab, Update information if an employee needs to update information , so when an employee clicks on Update information it should automatically fetch my older details but is now, how can I make it hapen?

Hii, I am unable to select NA option , for YES or NO Its  working fine , how can i resolve this,  i have to save a!radioButtonField( label: "", choiceLabels: { "Yes", "No", "N/A" }, choiceValues: { 1, 0, "NA" }, value: fv!item['recordType!{f42d5bd8-9c50-4910-b251-13ec6bf9fdb6}GAI App Review.fields.{899275d5-d9e3-4030-9291-883eaf45d2c6}reviewerAnswerBool'], saveInto: { local!a, a!save( fv!item['recordType!{f42d5bd8-9c50-4910-b251-13ec6bf9fdb6}GAI App Review.fields.{899275d5-d9e3-4030-9291-883eaf45d2c6}reviewerAnswerBool'], if(local!a = "NA", {}, local!a) ) }, this value in to boolean type column

Hi Champs, In one of the use case, we do need Case management and I see Appian comes up with it's Case Management framework ; but I am not sure how to use the same. Can anyone have use the same or any idea how to use it? Regards, Ghanashyam

Team, Do we have any cloud approved function which can provide constant using constant name ? Regards, Gaurav

Good day everyone,  I am new to Appian and working on a project. I have a database with the following tables: Employees (1:M) Document Status (M:1) Training Document. I am trying to make a form that allows managers to assign each employee to multiple training documents at the same time. So, I have a form like below with a checklist of all training documents (fetched through an expression rule)  When the form submits, I need the process model to write to the database multiple times to the document status CDT. For example, based on the picture above, there would need to be three entries to DB tracking status for each training document and employee. How should I set up the interface and/or process models. Any advice/suggestion would be greatly helpful!  Best,  Harsha Gurram