Foundation

{a!localVariables(local!item:0,a!forEach( items: enumerate(2), expression: a!columnsLayout( columns: a!localVariables( local!outerIndex: fv!item, local!item:1, a!forEach( items: 1+enumerate(3), expression: a!columnLayout( contents: a!cardLayout( style: "INFO", contents: { a!textField( value:local!item, saveInto:a!save(local!item,tointeger(local!item)+1), ), a!richTextDisplayField( labelPosition: "COLLAPSED", align: "CENTER", value: a!richTextItem( text:local!item, color: "#1a1a00", size: "MEDIUM", ), ), }, height: "MEDIUM", shape: "ROUNDED", ), ) ) ) )),)} The above code will have 2 columns and 3 rows. it is giving the below output. but i want to display 1 2 3                                   4 5 6. If i apply some logic , i will get 1 2 3                          

Reading through the Query Database Smart Service documentation, it appears that an explicit transaction wraps every execution: https://docs.appian.com/suite/help/22.2/Query_Database_Smart_Service.html#:~:text=Activity%20execution,by%20the%20node Is there a way to shut this behavior off?  We have created a logging framework with all of our procedures, and can even get the error messages we're producing out of the process flows via the Outputs tab, but when all is said and done our logging messages are missing.  If I'm interpreting the above correctly, it's because the overall transaction is rolling back our logging inserts too. I'd really prefer to let errors be errors and just stop this behavior, but if that's not possible my catches will have to swallow the error and return my messaging through OUTPUT variables instead (an idea if anyone else is facing this same issue). Thanks! -Eric Rubeck

I have a local variable which gets it data from an expression rule which in turn fetches data from a record. I am using this local variable within an editable grid in foreach to populate data for each rows in the grid. When a particular value of the local variable is edited, I am enabling a Save button in the interface (The interface being displayed to user is an user input task present within a process model) and when clicked on this save button, the process gets navigated to appropriate write to data store entity smart services and then routes back to the same interface. Now when the process stops at the same user input task again, the changed value is not reflecting and I have to do a hard refresh by pressing F5 in order for the change to reflect or I have to exit the process model and enter again. I tried using refresh variable but it is not working as expected. Am I missing something?

how to print fv!index in reverse order in foreach loop. E.g 5,4,3,2,1

Hi. I am attempting to make a reusable grid using a passed ri! of type Any with a cdt type being passed into it. Optionally I am thinking about passing in a list of column names so I can specify the order the grid displays columns in. From there I wanted to do a foreach generating the N grid columns using field names and types grabbed from the passed cdt.. 1.I don't know if there is a way to get a list of all the fields a cdt type has. 2. I am unsure if there is a way to get their types. Any tips?  

Hi Team, My page on site is auto taking the space on left and right and moving my interface at center in the 24 inch desktops , It works fine in laptops , Can we have any suggestion on this  The red lines are the empty space users are facing , if this can be adjusted then , Users no need to scroll the below grid from left to right always  Attached the screenshot

Hi, In welcome to query data after following the below steps: Sign in to Community, and head to the My Learning Journey page. Click Get My Site in the My Community Edition Site card I Am not getting this option: Select your Cloud Region dialog, select a region for the instance and agree to the terms and conditions. Click Get My Site. can anyone help me with this?

Is there any solution or idea how to populate a rich text editor with some text? 

Is there a limit for the number of objects in an appian application ? will there be performance decrement if the number of object is increased from 100 to 500 ?

Hey Community can u plzz suggest me the solution of this type of error in process model

Hi Team, I want to calculate time in hours between two date time like on  18th 8am to 18th 10am :- 2 hours 18th 12pm to 18th 8pm :- 8 hours  total :- 10 hours Can anyone please help calworkhours is not working properly.

Hello,  how can I access to my expression editor? I already got my appian community, but couldn't access to the expression editor 

Hi,  I am getting the error --> A multiple dropdown component [label="Multiple Dropdown"] has an invalid value for "value". All selected values must be present in the choiceValues array, but value was 1; 2 and choiceValues was 1; 2. a!multipleDropdownField( label: "Multiple Dropdown", labelPosition: "ABOVE", choiceLabels: {1,2}, choiceValues: touniformstring(1,2), value: tostring(ri!nocareas), saveInto: ri!nocareas, searchDisplay: "AUTO", validations: {} ) Applied the suggestion as given here (by Stefan) - https://community.appian.com/discussions/f/user-interface/25021/all-selected-values-must-be-present-in-the-choicevalues-array/96892#96892 but not working.. When I do the same with simple dropdown (of course - single selection) - I do not get any error. ri!nocareas is of type: text what am I doing wrong ? your help will be appreciated.. thanks jaideep

I have the below sample json variable. i want to get the number of values under tags.  local!Json:{ tags:{ "description": " ", "displayName": "" }, { "description": "", "displayName": "" }, { "description": "", "displayName": "" }, }, To achieve this, i have tried using  count(local!Json.tags.displayName). it is throwing the below error. "Cannot index property 'displayName' of type String into type List of Variant". How to resolve this?

Hi everyone, Hope everyone is doing well and safe. Can any one help me with Leveraging activity-chaining with example.? How can we pass data from one process to other process by using start process smart service? Thank you all in advance! Regards, Kiran Sajjan

Hi, I'm trying to export the Read-only Grid I have this issue due the "ID" is the child of "Q". I know the limitation of selection and Column. Export Data Store Entity to Excel Either selection or filters are invalid: Cannot query [Q.ID] because [ID] is a child of a multiple data type. I was wondering if you have any solution to work round this? Thanks

Hi, I want to save this below to a cell like this "123456, 78900, 4567" in the user interface Thanks,

I'm trying to insert one  image to my word document i have seen a lot of post about this topic but any of them work for me most of them tell how to add an array  of images  but i  just have  one image that i want to be shown in my word y  updated the field in the word document i also edited the fields i have the image as a bookmark i sent the  image as dinamic cdt  with and without the index added i made sure this constant has a value also this constant is referring to a image  i tried to pass in xmlformat  converting my pv variable and converting it into a document to make sure and nothing i also tried to  add the image as xml . i also tried everything  with this template an nothing

I have a related action accessible to a number of users. The action will be hidden upon execution. If two users open the summary page at the same time, the first one to click it will be able to execute the action. Although the action is still visible on the second user, he/she will now get  "An error Has Occurred. The specified <RECORD> related action does not exist or you do not have permission to view it". Is there a way to handle this error to provide a better message? Thanks.

in DB we use tinyint (type), afterwards we create a interface from builders use table 1(where radio button contains like gender either male or female) but it is different from db to interface data type then how to do?

Hi all, As per my understanding these objects Query Rule and Expression rule are same, then Why it's given in filter panel for Query Rule? Is it any other way to create QR? We can filter by Expression Rule on filter panel. It doesn't show any objects if I filter with Query Rule. What is the purpose of this filter Query Rule? Please clarify on this... thank you in advance!

Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = 285dc:bfbb1] : Cannot compare incompatible operands of type List of Variant and type Number (Integer). error coming please explain

I'm trying to use the file upload functionality in Appian Interface and is there any way I can restrict from uploading the file with the same name which already exists in the db or even if it allows the upload is there a way to over write the existing file with the latest file?

Hi Everyone, I am getting a variable of type Map from Appian RPA Integration in Execute Robotic Process smart service, the values are coming like below as a single Map variable: { varABCIndex=26, varSiteNameIndex=16, varCurrentMonthTotal=64, varProjectIdIndex=24, varExcelModifySourceFilePath=, varOutputDocId=164646} Suppose I want to fetch value of varOutputDocId from this map variable, so how I can fetch this value. Please suggest.