Foundation

Hi! I have an editable grid made of existing data (stored in my local variable, in which y query another record), and I don´t want this data to be touched (like read-only).  Now, I would like to add to my local variable another extra-column with no value, and make this column able for the user to put values Is this possible? How can I manage to do this? I leave my code here (It is not finished yet, but I would like to know in which part of the code should I act and the considerations) a!localVariables( /*mirar para incluir columna extra en variable local*/ local!DatosLineas: a!queryRecordType( recordType: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido', fields: { 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{fcfa4b36-4398-4430-8055-ecfa59daf13a}idLineaPedido', 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{71427dbb-12db-4f83-bd99-f625bf9af271}idPedido', 'recordType!

Hi  So basically, i have a record type for " Requests" and i have another record type for "Documents ", In the "Add or Create Request" Interface, which was generated by record action, I should include a section for "Adding Documents", except that adding a document should be done by an editable grid and not record action.  I have the following code for the document editable grid, but when i link it to the document error I keep getting the error shown in the image below.  what is the right way to link the editable grid to the document record type?  ,  a!gridLayout( totalCount: count(local!document), headerCells: { a!gridLayoutHeaderCell(label: "Document" ), a!gridLayoutHeaderCell(label: "Name" ), a!gridLayoutHeaderCell(label: "Classification" ), a!gridLayoutHeaderCell(label: "Uploaded By" ), a!gridLayoutHeaderCell(label: "Uploaded On" )

Hi! I have a doubt with the approach of my application and I would like to know your thoughts! In my case, I have a summary view of PO in which I have a read-only grid with the PO lines. I created a related record action to "recepit" the PO Lines ("Recepcionar Pedido", which will link to a process model), and now I want to create an interface with the following conditions: 1) I must show the same information/table with the PO Lines (I just need some of the fields). Not need to add new rows 2) I must be able to create an extra-column to introduce manually  In order to do this, I thought several options: 1) Create an editable grid based on the data of a record (like a read-only grid, same values, but with the posibility to manipulate it) 2) Convert the read-only grid in an editable grid (i dont know if its possible or complex, I know the configuration are totally different) How can I manage to do it? If it´s not a good approach, I would like to h

i have a requirement  where i'll be selecting the checkbox and once i select the checkbox need to show the show data link, when i click that ink some data to be displayed at right side for the same selected checkbox now what is happening is when i select next check box the show data link is not coming.  can anyone help me to work on this - when i select single check box the show data should come and one i click on that right side some data to be shown. when i select multiple checkbox only latest selected checkbox has to be have show data linka!localVariables( local!limitSelection_cdt: rule!CR_SF_QE_getLimitSelectionData( cif_int: ri!cif_int, requestId_int: ri!requestId_int ), local!limitsList: index( local!limitSelection_cdt, "limitId_txt", {} ), local!showLimitData: false(), { rule!CR_SC_SF_customerDetails( cif_int: ri!cif_int, requestId_int: ri!requestId_int ), a!columnsLayout( columns: { a!colum

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

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

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.

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

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

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! 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;

Actually I am having editable grid which is shown below .. contains components  dropdown and  file upload field and Text Field  I want to preload the required values of dropdown , when user opens the page he should see the grid with selected dropdown values. as shown below  all other functionality of grid will work as it is .. like removing adding new row .. please find the code-snipet attached (in the snipet Local!required Documents .. is just an id label we are storing in lookupref Table  so we can get from there) local!selectedDocuments: if( a!isNullOrEmpty(local!data), { 'recordType!{e5935b72-2349-43df-bd15-908d316468be}PRO Lead Documents'() }, local!data ), local!requiredDocuments:{198,199,191,193}, a!gridLayout( label: "", headerCells: { a!gridLayoutHeaderCell(label: "Document Type"), a!gridLayoutHeaderCell(label: "Document"), a!gridLayoutHeaderC

Hi all, I'm trying to see what is the best way to assign a minimum character number for a text component in a interface?

Hi  I want to create an interface in which a user can click on a button which will open the editable child interface and the edited values can later will be saved into the parent interface. how can i achieve this.

Hello! I am trying to figure out the best way to manage the Breadcrumbs Pattern, but I can't seem to grasp the way it is intended to be used. { a!localVariables( local!currentNodeId: 4, /* This variable would normally be retrieved with a rule like rule!getBreadcrumbsForIdentifier(identifier: local!currentNodeId). */ local!nodes: a!forEach( items: enumerate(local!currentNodeId) + 1, expression: choose( fv!item, a!map(name: "Home", identifier: 1), a!map(name: "My Documents", identifier: 2), a!map(name: "Strategy", identifier: 3), a!map(name: "2018 Road Map", identifier: 4) ) ), { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!forEach( items: local!nodes, expression: if( fv!isLast, a!richTextItem(text: fv!item.name, style: "STRONG"), { a!richTextItem( text: fv!

Hii ,  I want to add value but getting erroe like - Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = PBWBF] : An error occurred while executing a save: Expression evaluation error at function 'todecimal' [line 285]: Could not cast from Record Field to Number (Decimal). Details: CastInvalid how can i resolve ? here is my code - a!localVariables( local!application: rule!GAI_getApplication(applicationId: ri!appId).data, local!grantorProjectActivityEval: ri!grantorProjectActivityEval, local!yaProgTypeId: cast( typeof(5), ( index( rule!GAI_getRefProgramType(programTypeAlias: "YA").data, 'recordType!{9d188bef-069b-4767-9d00-29432411f0cc}GAI Ref Program Type.fields.{4c3d4dd0-1f33-4086-9aee-27a44d619e83}programTypeId', null ) ) ), local!refGrantorProjActivities: rule!GAI_getRefGrantorProjectActivity(fkProgramTypeId: local!yaProgTypeId, ).data, local!metricTotal:rule!GAI_Add