Foundation

Hi all,I am trying to show data in an editable grid where they can edit data and save it to back to database. While trying to display, I am getting the following error This is how the data is present in database I tried using split function but it didnt resolve the issue. Can someone tell what I am missing here . I have attached the codea!localVariables( local!data: /*Query*/, local!dropdown: { "A", "B", "C", "D"}, a!gridLayout( label: "Editable Grid", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "Platform") }, columnConfigs: {}, rows: { a!forEach( items: local!data, expression: a!gridRowLayout( contents: a!multipleDropdownField( label: "Platform", choiceLabels: local!dropdown, choiceValues: local!dropdown, value: fv!item['recordType!{a3bb3bf8-8475-4d37-8cdd-f8db72114a55}record.fields.{a4be7f3b-9f4c-4101-8518-99a99631768e}platform'],

I need some information regarding row-level auditing and field-level auditing in the cloud database. mainly i need more info on field- level auditing, i have been searching for that from the past one day, i didn't get any syntactically correct SQL code using triggers. you can suggest me a video / blog / website. Thanks in Advance.

I have process model which contains interfaces one after other and some of the system task , the process has actvity chaining  now my requirement is after submission of 1st form we need to send mail and we kept that send email smart service in between , now if the email got failied flow shouls not stop ie the flow should be continued.

Instead of using And gate to run parallel flows is it ok to use dummy script task and branch it parallel flows ? like this

Need a solution for medium risk alert. Please share inputs. Description: # of unattended process loops Details: 9 process flows contain unattended loops with 2 or more nodes. Looping is typically an indication of using processes to perform extract-transform-load (ETL) type operations. It is recommended to use specific ETL tools (such as a database) to implement complex and bulk background operations. Process Model Name -> is check? (3 nodes in loop) is Check - > is an XOR gate

Hello, I'm getting really confused here. This error pops whenever I click on "Cancel project" but I don't think there's anything wrong with the dropdownfield component below. I've done this dropdown a 100 times before but for some reason, this error is persisting  can you guys see what I might have missed?

Hello, I am looking to find useful courses on Appian. I want to add them to my list of courses on this topic so that other Cloud Engineers can quickly understand how to use this software.

Hi Champ, I have a form where I have different milestone and submit button is there in the last milestone. So user can go to any of the milestone at any given point of time during initiation but when they press the submit button, we need to show the validation for all the mandatory fields that we have in the interface. So for validation we are calling a rule which is checking for all mandatory fields that we have in one of the constants and that give us the fileds which are missing and accordingly we are showing the message to user. Now that is working filne ;but getting a strange issue here. When user submitting with giving all details in all milestone and clicking submit button the page is not getting submitted . when we click for the second time it is getting submitted. What I suspect is that for the first time it is only checking the validation and for the second click as there is no validation issue, it is getting submitted. But What I expect is fir the first time itself it will c

Hello, I have editable grid in which I have 3 dropdowns, I'm picking up the values and choices from constants and have rule decisions based on that now for the first row it's working perfectly fine I select "Region" then "Country" and then "Language", but once I add new row I loose all the values from second and 3rd dropdowns and they become blank and I'm not able to select anything. Here is the full code for the a!foreach is it something within the add row function? rows: a!forEach( items: ri!AOS_Documents_Required, expression: a!gridRowLayout( id: fv!index, contents: { a!dropdownField( choiceLabels: cons!AOS_Regions, choiceValues: cons!AOS_Regions, label: "Dropdown", labelPositio

Hi Team, In Prod particular process getting error and seeing 400+ instances failed in process monitoring with process with errors. I want to create process report and get the error message those instances in the part of the report field and I will segregate the issue based on this. Do we have any function or predefined to get this?? Kindly help on this. Thanks

As asked above, it is fine when I use the field for a record list action (the same exact action, just configured in a record list action instead of a related action), it is fine when I go into my records and use the related action there, but it is not fine when I use the field for the related action in an interface. The error just states:  The record data does not exist, has been deleted, or you do not have sufficient privileges to access it. (APNX-1-4205-006) But I know it exists and there are adequet privileges because I can access it through other means, just not through an interface. Maybe this is to be released in a future update but the way Appian currently has the record action field configured suggests that you should be able to use a related action there. Thanks!

Hello Appian Community, I am exploring Appian’s capabilities to implement a Demand Management solution tailored to a Federal agency’s specific requirements. Given Appian's extensive customization options, I am interested in understanding if there is a pre-built Demand Management functionality within the platform, or if such functionality typically requires custom development. Or if such fucntionality is expected in future releases. Background: Our objective is to establish a system that: Centralizes all new business requirements for visibility, tracking, planning, and budgeting across the enterprise. Ensures alignment of IT requirements with business strategies and integration with existing project management frameworks. Includes robust API support for potential future integration with ServiceNow (SNOW), particularly for data synchronization. Question: Does Appian offer out-of-the-box Demand Management capabilities that can support these requirements, or would this ne

Hi Team,  I have a requirement where the email needs to be triggered on specific date and time. For ex. User is raising a request initially. While raising the request he can set the remainder date. This date I am storing in DB. Email needs to be triggered for the remainder dates. What is the best practice to do this?Thanks!!

I have an existing Record UWM-Case that had 2 sub-objects UWM-UnderwritingCase and UWM-Policy.   A Related Action on on UWM Case for Add Decision looks like this: I can see that hardcoded value show up in the variables in the process model, but the interface is still behaving as if the value is null.  I have added it to the Process Model VariablesI cannot figure out what else to try to get the value to the interface.  Any suggestions will be greatly appreciated!

Hi, Am unable to display the column name in the column chart below is the screen shot for the same. Am able to click on the column bar but unable to get the column name as i have around 150 columns in the chart . expecting the column name in orange line. Can anyone suggest me pls. Thanks in advance

[ld_id=1188, ll_id=904, fl_id=, fm_id=, rsed_id=, appian_document_id=5357264, klt_id=, legacy_id=, description=, name=, createdby=testc, createdon=10/3/2022 7:14 PM, modifiedby=tects, modifiedon=10/3/2022 7:44 PM, inuse=1],[ld_id=, ll_id=904, fl_id=, fm_id=, rsed_id=, appian_document_id=6057969, klt_id=, legacy_lease_id=, description=The Parties, by mutual agreement, due to the Partial Surrender of the Demised Premises, agree to amend items 1 ("Base Rent"), 3 ("Demised Premises") and 10 ("Shared Property Expenses") of the Summary of Terms and Definitions of the Agreement., name=, createdby=testc, createdon=10/3/2022 7:44 PM, modifiedby=, modifiedon=, inuse=1],[ld_id=, ll_id=, fl_id=, fm_id=, rsed_id=, appian_document_id=6057968, klt_id=, legacy_id=, description=, name=, createdby=, createdon=, modifiedby=lecst, modifiedon=10/3/2022 7:44 PM, inuse=0] This was the pv variable cdt data in that for second id (second occurence) means where document id =6057969 i want to update "descri

Hi all,  We need a rule expression to be used only in one process model. How can we prevent that rule expression from being used in another process model or interface? The only way I can think of is to manually check the dependencies of that rule. Could this review of dependencies be automated in some way? Thanks in advance. 

How to list all the members of a group and store them to a local variable to show them in a grid also select multiple members to delete and add the members, using groupmember function?

Hi  I need advice. Read CSV file and want to find duplicate value. if there are duplicate values .I want to display error msg.. I was able to load the CSV and remap it to the map list, but I was unable to check for duplicates values and unable to add error msg. Image like the attached image

Hello, I have editable grid where I'm trying to save all the selections in rule input after that I will use the rule input to push the data to database. The problem is that I'm not able to save the multi drop down as an array when I select more then one option it save only one and not all in the rule input. Full code below: rows: a!forEach( items: ri!AOS_Documents_Required, expression: a!gridRowLayout( id: fv!index, contents: { a!dropdownField( choiceLabels: {"Option 1", "Option 2", "Option 3", "Option 4", "Option 5", "Option 6", "Option 7", "Option 8", "Option 9", "Option 10", "Option 11", "Option 12"}, choiceValues: {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12},

I want to implement single sign on in appian using saml authentication so in implementaing , we have to provide webaddress identifier and service provider meta ,what kind of data that we have to provide service provider metadata?  we are refering this url : SAML for Single Sign-On - Appian 24.1

I am getting this error "type (Data Inputs) " in send E-mail smart service, How can i solve this one? i am getting this error when i use record type process variable in this smart service, otherwise it is working fine.

Hello everyone, I'm looking to archive process instances that are currently active, paused, or paused due to an exception. We've already configured process instance archival after 5 days with deletion after 3 days, but we now have over 10,000 process instances in these states that we want to archive instead of deleting, as we may need them in the future. Is there a script or another method we can use to archive these instances? Thanks, Manish

Code: a!forEach(pv!addedResearchItems_cdt, if(and(rule!APN_isBlank(index(fv!item,"id",{})),rule!APN_isBlank(fv!item.url)),cast('type!{urn:com:appian:types:gngp}GNGP_RESEARCH_ITEM',updatecdt(fv!item,{file_name:if(not(isnull(fv!item.file_name)),fv!item.file_name,if(not(isnull(fv!item.document_id)),document(todocument(fv!item.document_id), "name") & "." & document(todocument(fv!item.document_id), "extension"),{})   )})),   fv!item)) Getting below error: (Expression evaluation error at function a!forEach: Error in a!forEach() expression during iteration 1: Expression evaluation error at function 'updatecdt' [line 5]: Length of input arrays must equal length of CDT/Dictionary array) (Data Outputs) Please help to rectify the above error as what code changes needs to be done

i got this error where i used remove() but i tried remove(null, index) will return null instead of error, so what could cause this error?