General

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.

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.

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

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, 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

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. 

We have tried implementing google reCaptcha in our portal,The google recaptcha connection is successful,We have used verifyRecaptcha and tested , it doesn't tally with the scores which we provide in the conditions on success or error,   We tried to find the score value by creating a table and writing the fv!score to the db through start process on success of verifyRecaptcha.   Is there any way to find the score values, Could anyone help to get the recaptcha working in appian portal

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

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?

User not able to see write up in ipad  as shown below  But able to see write up in laptop as shown below Can someone please help on what needs to be done here or how to resolve

The "user" parameter has a value that does not exist, has been deleted, or you do not have sufficient privileges to access its data .  I am using record events and tracked the changes in the history table which are auto created in the events   ,  As an admin i can able to view the data , whereas normal users are getting this week , i have check all the records type user records they are having viewer permission  Please let me know what could be the problem 

Hi, I have a requirement to download the grid data along with the documents in to excel. I have seen there is a plugin  Embed Image into Excel  but, i dont see any success stories on it and it is not updated recently. Can someone suggest the way on this. THanks Soujanya

So when the user selects a particular interface, a document is generated and if the user selects the 'cancel' button then the document is deleted. There are cases where the document might get deleted through another form so if you try to select the cancel button, then an error message appears. Right now this is the idea for the process model but its not fixing the issue so please let me know if you see anything that might fix the issue. the 3PI exchange node generates the document, then the XOR node checks to see if the pv!download_doc is null or not and if it is, then move to the end event, if not then to delete the document and end the event. I tried a few other options for the XOR node but this is basically as far as I know what to do?

Hello,  I'm using excel plugin tools and i can read excel databut i don't need null of row so i want to delete null row.I tried to loop list of text string but cannot get it.How can i convert list of text string to list. here is my test rest of screen shot here is my excel data image

Hi Team, I have a Text Box and Button beside that text box, when I enter anything in the text box and hit on "ENTER" button on keyboard I want the Button to submit the data. Is it possible in Appian ? Thanks  Bihitak

Let me explain  I want to get to see the summary view of a user but with all the related action bar that appears up top  of the summary view  interface I'm being  able to redirect to the interface of the summary  but i can't see the things that  i see  when Im  on the record type with all the the actions . i hope any of  you guys could help me  or tell me if this is possible or not thanks  

Use case is that we have to remove the selected multiple users from multiple groups. The issue is when I select one user then the entire row is selected of groups listed users. I want to select the users in multiple from the selected group. a!localVariables( local!selectionValue: {}, local!selectedGroup: ri!initialGroup, local!actionTaken: if( isnull(ri!btnAction), false, or(ri!btnAction = "ADD", ri!btnAction = "MOVE") ), local!distinctUsers: if( a!isNullOrEmpty(local!selectedGroup), "Please select a group", a!flatten( a!forEach( items: local!selectedGroup, expression: a!localVariables( local!group: fv!item, a!forEach( items: getdistinctusers({ fv!item }), expression: a!map( id: fv!index, Group: local!group, Members: fv!item ) ) ) ) ) ), local!pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 10),

Hi. I was setting up some save functionality for the one spot in my code that saves to a particular variable. I had a rule that outputs null under certain conditions, but kept watching it show up as {null} instead. I have tried to simplify the issue and have found saving into the localvariable something like {"Apple", "Banana"} results in straight null instead.  What is happening in my interface? If i save the same value to a random debug variable it works fine.

Hi Folks! I have a scenario here which seems impossible to solve. We have an excel template where column A has formula that increments row number if we add data in column B. This excel is used as template in Appian where we are querying a view and dumping the data in this excel. When we tried doing this, the formula is overridden by the values from the view. So the formula doesn't work anymore if we add more rows in the excel. If we keep column A blank while generating template from Appian, we need to update something explicitly in column B for the values in column A to auto-populate. We don't want to use VBA code as well since macros are disabled by default. Is there any way that the formula could work even if we dump data in column A from Appian, any plugin or configurations we could do in Appian or anything on excel side? We want to avoid the situation where we are keeping column A blank just for the formula to work or manually enter values in column A on every row

I have one requiremnt where i need to just convert the raw data into respective CDT. Is it possible to convert into the CDT without expression data. I have used cast but it is not worthy to be work. If same case is used for this using expression then it is working [RecordID=4, CatalogID=, ScopeID=6, VendorID=, InHouseTechnicianID=, WORemediationID=, BidID=, Category=, Description=, GLCode=, GLSeg=, IsExterior=false, LineItemApproval=, MatCost=, Pass=, Price=0, Quantity=1, UnitOfMeasure=, ResidentResponsible=1, Room=, SubCategory=, Summary=, TechCost=, TechTime=, OriginalPrice=, VendorPrice=, Modified=, Deleted=false, CreateUser=henryfok, CreateDate=2/15/2018 12:00 AM UTC, UpdateUser=henryfok, UpdateDate=2/15/2018 12:00 AM UTC]

Recently my Appian cloud environment got upgraded to 24.1 and have advanced level Appian support. But I am still not seeing Case Management Studio, do I need to submit additional request or how can I access it?

Using | Open User Profile | and | Open Settings Menu | as they appear in the Cheat Sheet  results in an error: Input Must Be Set.  Are there examples of how to use these correctly?