Foundation

I'm facing an issue that the column name is not showing in the placeholders outside the graph. The image is attached. The value of the columns are not showing.

Do we have any process model/plugins to capture basic fields for field level audit - property that changed , old Value, new Value, last updated by, last updated on

I need the document classification service to send the document to a gate and it sends the document through the correct path to extract the document, but I don't know how to configure the outputs of the classification service so that the result is not the threshold if not the document and thus configure the XOR gate

i have a problem when add the new record using the record action , when i want to add the new record the record does not added to data base and the grid please help { a!sectionLayout( label: "", contents: { a!billboardLayout( backgroundMedia: a!webImage( source: "https://static.pointcheckout.com/16cd7c7425e54498/original" ), backgroundColor: "#f0f0f0", height: "MEDIUM_PLUS", marginBelow: "NONE" ), a!gridField( label: "", labelPosition: "ABOVE", data: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit', columns: { a!gridColumn( label: "Deposit Id", sortField: 'recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{c27cd643-e617-46e3-a4dd-c16df94bbed2}idDeposit', value: fv!row['recordType!{df6fbb1a-9532-49a0-a8bd-61c6440eb962}RDA Deposit.fields.{c27cd643-e617-46e3-a4dd-c16df94bbed2}idDeposit'],

Hi! I have created an editable grid with previous data (stored in my local variable) To create an editable grid from scratch, I used to put "fv!item..." in the value and saveInto parameters (so that when the user interacts, the value was saved).  But in this case, I just want the grid to show the data of my local variable and save it in another record/ruleInput/localVariable How can I configure my code in order to manage this? Should I use the a!save function? Should I "point" to each field/column of my local variable without using the "fv!item"? How? I leave my code here. I think that I could omit the operations between columns in "Cantidad", "Precio Unitario" and Importe, because I´m querying the values directly with my local variables (my local variable is created by quering a previous editable grid). But for me the most important thing is being able to point to my local variable and save correctly the values wi

hi  can someone provide me with example codes about Editable grid with record types ? all of the examples use dummy data and not record types and i am struggling and don't know how to replace the data with record types without getting errors.  for example, here is a code , i need to link it with a record type and then get the appian id doc. and the document name , then save them in their fields.   but when replace [Record Field for Document Name], with my actual record type it does not work  and keep getting invalid indexing types errors.  a!localVariables( local!document: Data of Record Query, { a!gridLayout( totalCount: count(local!document), headerCells: { a!gridLayoutHeaderCell(label: "Document" ), a!gridLayoutHeaderCell(label: "Name" ), a!gridLayoutHeaderCell(label: "Classification" ), a!gridLayoutHeaderCell(label: "Updated By" ), a!gridLayoutHeaderCell(label: "Updated On" ), }, columnC

Hi Everyone, The requirement is - There will be a keyword and we have to search for that predefined keyword within a PDF file uploaded by the end user. If the keyword is not there within the file then prompt the user. Please let me know if it is doable. Do I need any plugin?. Thank you

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