Discussion Categories

hey! i am working with a selectable grid , when i select a row , i want to show one of the fields (currency) in in an intFeild, but the currency value is taken from another table(Currency Table), and then called using the relationship between the (Account) and the (SKJCurrency) tables, how do perform that using the index function, I tried using index twice but that didn't work.  If using two index is not possible , how should i do that ? and what's the right synatx , i cant find any exampls and i need to fix this issue asap. /*The Grid field where i called the currency table*/ a!gridColumn( label: "Currency", value: fv!row['recordType!{e54cd4e6-9c62-49a2-82d6-965f3a86b2e7}SKJ Account.relationships.{a0795917-dbcb-4e87-8928-253944204ea6}skjCurrency.fields.{de6af13f-a763-462f-9369-8cd8bbbf1075}descAr'] ), /*The int Fiel

hi i am trying to save the value of "Account Balance" to calculate the dollar equivalent field.  i wrote the code below and tried to save the value of "dollar equivalent" in a local variable but the value stays NULL, i also tried to replace with rule input but that did not work.  any suggestions?  local!USD:ri!record['recordType!{e54cd4e6-9c62-49a2-82d6-965f3a86b2e7}SKJ Account.fields.{48c2c2cc-59fa-42cc-a496-c512f51c25bf}dollarEqu'], local!USDBALANCE: ri!record['recordType!{e54cd4e6-9c62-49a2-82d6-965f3a86b2e7}SKJ Account.fields.{a26624aa-6c8b-4ad4-b696-f52169531873}accountBalance'], local!dollar:ri!record['recordType!{e54cd4e6-9c62-49a2-82d6-965f3a86b2e7}SKJ Account.fields.{48c2c2cc-59fa-42cc-a496-c512f51c25bf}dollarEqu'], a!floatingPointField( label: "Dollar Equ", labelPosition: "ABOVE", value: a!match( value:local!Curre

HI,  I have struck at a point... I am working grid field, I have provided links for two columns in the grid field, By default column 1 link was enabled when I clicked and submitted data column 1 link had to be disabled. and the column 2  link has to be enabled After submission of column 2 data, the column 2 link also has to be disabled... Help me with a sample code  

I'm using view to get different columns from two tables and using that view to generate the report in excel.  So my question is : After the 5-6 years the data will be large inside the view which I'm using currently, so is there any alternate way to get the data faster as compared to view in Appian. Thank you.

Hey there!  I am working with a selectable grid,  the user is supposed to select a row and then the account number of that row should appear in the text as shown in the image.  the thing is that i tried to used "index" with the variable "selectedEmployee- where i save the selection" but the value still does not show in the text.  What am i doing wrong? how can i fix it?  a!sectionLayout( label: "", contents: { a!gridField( label: "", labelPosition: "ABOVE", data: local!info3, columns: { a!gridColumn( label: "Account Number", value: fv!row['recordType!{e54cd4e6-9c62-49a2-82d6-965f3a86b2e7}SKJ Account.fields.{afb4d4c6-e193-4650-8165-83cfacf7b5df}accountId'] ), a!gridColumn( label: "Account Balance",

I am new Appian.  I am working the "RPA Tutorial: Parse Excel Files" version (23.2) to read data through RPA robot task, which works fine, but cannot figure out error at the step to Add Excel data to database in PM.. Your help is very appreciated!    In Appian Community questions, there was similar question about working on the same training document, and the answer was written: missing one step in the tutorial : In the Appian RPA interface, for the Upload Excel File activity, you must enter "excelDocumentID" as the Target, in the Outputs section.  I don't understand this answer because the excelDocumentID column is set as primary key, auto-generate?  if this step is the missed step, how to do this step?  The errors message I have had:  An error occurred while evaluating expression: =pv!roboticTaskVariables.dataValues (Expression evaluation error: Cannot index null List of Map) (Data Inputs)&n

Hi Appian community , i want to help me to make a editable grid that have on it multi field like a document field the name of this field and the classification field , ok this editable must connect with record (document) in name document i must put the name of the documnet that i uploaded it  please help me give me a code for that 

Hello Appian Community, I'm looking for information regarding the storage location and retention period of archived processes in Appian. Specifically: Where are the archived processes stored within the Appian platform? Are they stored within the Appian database or in a separate location/file system? How long are archived processes retained within the Appian system before they are automatically purged? Is there a configuration setting for this, and if so, where can it be adjusted? I'm interested in understanding the best practices for managing archived processes, and any insights or guidance from your experience would be greatly appreciated. Thank you in advance for your assistance! Best regards, Rahul

Hi All, Today we encountered a weird issue, where a process node errored out but the alert was sent to a bunch of people who are not even the system administrator. Can someone please help us to figure out what might be the reason behind this glitch? Any help here is appreciated.

Hello, In a interface using process model I'm generating the Report in Excel using Export Data Store Entity To Excel Smart Service on Monthly and daily basis, and in smart service inside filter field I'm providing filters to filter the data. Now the requirement is that I need to take inputs from user like the From Time and To Time, and based on this I need to filter the data from the database and generate report in excel which is present between the time period provided by the user in interface.  Thank you.

Hi, I am using a record type for creating the readonly grid, I am trying to change the language of the filter label once the user interacts in the parent interface. As per current design, we cannot pass rule inputs to the record type. I tried refreshing the child interface using a!refreshvariable(), however the problem still persists and label value doesnt change.

Hi! I have created a node with the SyncRecords Smart Service My record to update is called: "CPF_Lineas_Pedido" My primary key is a concat() from another two fields of the record: "CONCAT_PEDIDO_MATERIAL" (f.example, "Pedido1-Rueda"). This primary key is saved in the first interface of the process The process variable which I use to "Collect" the primary keys is correctly saved:  And as you can see, all the values are the same as the records primary key By now, all the field (in which I have created/updates via Query Database Smart Service) changes are correctly saved in my DB, but not sync (I have to do it manually to see the results in my Site) Do you think the problem is because I´m using a complex primary key (Text and concat value)? What can I do to fix and automatize my sync?

Error : Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = PLZG0] : An error occurred while executing a save: Expression evaluation error: Cannot update List of Dep_Record; length of assign value list (0) does not match length of the list to update (1). Desc: Have attached a file and when trying to detach the same file I am facing the above error.Please check and suggest. Code : a!localVariables( local!minimumRecord:1, local!bulkUpload: a!refreshVariable( value: a!forEach( items: enumerate(local!minimumRecord), expression: 'recordType!{f0769d64-67a8-4b44-897d-1f9e28718b03}EMP_RECORD'( 'recordType!{f0769d64-67a8-4b44-897d-1f9e28718b03}EMP_RECORD.fields.{c4a92bde-e02b-4695-a292-2ff46a89c88e}createdBy': loggedInUser(), 'recordType!{f0769d64-67a8-4b44-897d-1f9e28718b03}EMP_RECORD.fields.{de5c9d80-f57b-4035-a8f0-98af6439584e}createdDate': today() ) ) ), { a!forEach( items: loc

While saving the process variable data in script task getting following error: Error writing to process variables (rank, for variable 'pv!sectionfieldmapping'., type, for variable 'pv!sectionfieldmapping'.) (Data Outputs)

How can I make my RPA in Appian accurately select the gender dropdown option based on input data in a user input form? The robot is currently unable to click the dropdown correctly, and I'm looking for alternative methods to ensure accurate selection based on input.

i have added a link in a selectable grid, when we select that row then the link should be enabled how to configure that

I have starting quarter, ending quarter ,startyear and end year. Need to get the quarter names dynamically in x axsis. For example, 01-10-2020 (4th quarter) to 08-09-2023(third quarter) Xaxsis categoreis should be Qtr4,Qtr1 2021, Qtr2,Qtr3,Qtr4,Qtr1 2022,Qtr2,....Qtr3 2023 Please any suggestions.

Hi I need to find out if a particular date which is stored in record type is from the previous month.  For example today in September I'm finding that 7th of August 2023 date (Already present in record type) is from August month.  How can I achieve this?  Please give me the suggestions. Thanks.

Hello! I need to know if it's posible to use a dynamicLink with the space bar or only can be used with the enter key? Thanks

Hi everyone, On a process instance, I'm trying to Write on Data Store Entity a string value with the following characters: Ω μs. But instead, I have the following error: "javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement: org.hibernate.exception.SQLGrammarException: could not execute statement: java.sql.SQLSyntaxErrorException: (conn=364712) Incorrect string value: '\xF0\x9D\x9B\xBA\x0A ...' " The field where I'm trying to store the value is varchar(4000), in Appian's database cloud mariadb.

Hi! I have created an editable grid with data of a record. To store the data, I created a local variable whose value is obtained by querying the record (local!DatosLineas)  Now, I would like to configure two things: 1) By now, the values of the grid are saved in the SAME RECORD (to which I executed the query). I want to show the values of the previous Record (CPF_Lineas_Pedido) but I would like to save the values in another record (f.e. CPF_Lineas_Recepciones). How can I do this? 2) I would like to add a new column, which must show no info (empty) and be filled in manually by the user. I want this values to be saved in the same new record as the point 1) (CPF_Lineas_Recepciones) ¿How can I add a new empty column to my local variable or to the grid? I have doubts because it is something "apart" from the query, independent. And I want the values to be saved in another record.  My code is below: a!localVariables( /*mirar para incluir colum

Hi All, How to validate an email address for users which are in same organization. If I am working in a abc organization and I want to validate that if users is not a part of an abc organization should show me invalid email address in textfield object in appian and if it is a valid user of that organization doesn't show me an error. Example: 1. hdhdh@abc.com 2. xyz@abc.com 3. adrfer@abc.com From above examples that users who is a part of abc organization then in textfield show me invalid email address. So my point is in one organization I need to validate users if it is valid no error should show in interface if it is not valid user then show me an error. Please guide me how to achieve these in a!textfield() function under appian 22.2 version?

Hello, I have an issue with the card choice layout. Consider the following code: a!cardChoiceField( label: "What's the number of possible answers?", labelPosition: "ABOVE", data: { a!map( id: 2, icon: "dice-two", primaryText: "2", secondaryText: "Two" ), a!map( id: 4, icon: "dice-four", primaryText: "4", secondaryText: "Four" ) }, cardTemplate: if( rule!UNI_FN_getPageWidth() = 1, a!cardTemplateBarTextJustified( id: fv!data.id, primaryText: fv!data.primaryText, secondaryText: fv!data.secondaryText, icon: fv!data.icon

Please find the below screenshot of dropdown, in this dropdown we have few values (ex: "a","b","c","Other"). Whenever I select "Other" option in the initial time it is allowing me to Save. but after Save, whenever I'm trying to Select second time in different dropdown as "Other" option then it is throwing below error. Can anyone please help me with this?   Error: Interface Definition: Expression evaluation error at function a!forEach [line 521]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!dropdownField [line 622]: A dropdown component [label=""] has an invalid value for "choiceValues". Duplicate items are not allowed in the choiceValues array, but choiceValues was [id=, name=Casing & Cementing, point=1, fluidPoints=1; 1; 1; 1]; [id=, name=HSE & Environmental, point=1, fluidPoints=1; 1; 1; 1]; [id=, name=Logistics, point=1, fluidPoints=1; 1;

How I make link for any page of my project . These are below  interfaces . I am in MyRequest page. How i visit to  last "Task " interface page from MyRequest page Work.....My new work.....My  task.....Task . "Work interface" is parent interface then "My new Work" is inside  the Work interface.Then "My task" interface is inside the "My new work" then Last "Task interface " inside "My Task" interface Ther are not in Records....