Discussion Categories

I need to make a gridLayout with several fields per row, in which the row number is what I indicate with a local variable, so that when saving in a rule input I can update what is already in it with what I add to the call the interface for the second time initialized again so that it does not show what is already there.I thought I could use the id of the GridRowLayout to identify each row, but it doesn't take it, and starts the rows at id = 1.Has something similar happened to anyone?

I have a process variable of map type and i am getting data like below array.How can i cast this to map.{id=1, Name=,class=12, sub=, }

What are the features that can be obtained to use Appian in the cloud and "on premise"? My company is partner. Thank you.

An email is send by the client to appian mailbox, Appian needs to autodetect and pickup the attachement from the mailbox automatically. with the attachements as a input we have to triggered  the process where input is the attcahements of mailbox. is it possible to autodetect an new email with the attachment from the mailbox? in case if it auto detected, how to trigger an appian process with the attachment as the input?

We have requirement where we need to pull data from one of the table(Not Relational Database and it is Big Data environment)  to our schema or application. Data will be off appx 90 columns and 15+ column may have defined length of 4000 Char. And At a time it will provide 250+ rows.  We need to pull this data via Appian without doing Databasse to database integration though We just need to dump this data into our schema and landing table. I am thinking it may have impact on performance of the enviroment or Time out with API call but want to understand if any solution can be done via web API or any other way.

Hi! I have created the following editable grid: Appart from the fields shown in the editable grid, I would like to create for each row a CONCAT() from two fields (idPedido, Material), BUT NOT SHOW IT IN THE EDITABLE GRID, only saving it into my local variable  I´ve tried with the following code but when I try to add a new row an error appears: fv!item not detected (line 189). Is my approach of trying to save it in the append correct? In case it is correct, how can I fix the code and the fv!item? If not, which is the best way to save it in the local variable or another way? Thanks a lot! a!localVariables( local!LineasPedido: {}, { a!sectionLayout( label: "LÃ%ADneas Pedido", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de pedido correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Linea Pedido"), a!

Hello, I need to configure a schedular which should run Monthly on first Monday. I'm not getting what to configure in month field. Please can anyone help me. Thank you.

Hi! I have an editable grid in which the user can add new rows. I have a problem with the field "Clave Única". Its value is the concat() function of other two fields of each row 1) It appears correctly written in the editable grid  2) It seems not to be flowing correctly to my local variable What can I do to fix this? Is my code wrong? My code is below (line 60 is where I configure the value and saveInto for the field): a!localVariables( local!LineasPedido: {}, { a!sectionLayout( label: "LÃ%ADneas Pedido", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de pedido correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Linea Pedido"), a!gridLayoutHeaderCell(label: "Pedido"), a!gridLayoutHeaderCell(label: "Proveedor"), a!gridLayoutHeaderCell(label: "Material"),

How to append time constant to today's date so that I can compare it with now() which is of datetime type?

We have created a Webapi , that will be invoked by external system every 10mins to get data from our application. is there any way to check how much resources it is consuming and see whether it is impacting any performance.

Hi All, I created a process report and one of the column definition is a record field(pv!record.orderNumber)  and am not able to see it in report. When i check in documentation, I could see as below But when i try to query using a!queryProcessAnalystics, the field is still showing blank for me. Am i missing anything? Thanks in advance!

Hello, I want to implement schedular in start node which will run Monthly on 1st Monday. How to implement it and want value should be passed to month field. Thank you.

I have a rule rule expression which returns a datasubset in which the data has repeating rows. Since the data is coming from a view in mysql backend, I want to handle this in appian by getting only unique rows and remove all duplicate rows while still maintaining the paging. The data should be unique for 'stateroomRequestId'. I have tried using union but it does not work with datasubsets and only data a!queryEntity( entity: cons!BUS_ENTITY_REQUEST_VIEW_DETAILS, fetchtotalcount: ri!fetchtotalcount, query: a!query( selection: if( rule!APN_isEmpty(ri!selection), null, a!querySelection( columns: a!forEach( items: ri!selection, expression: a!queryColumn( field: fv!item ) ) ) ), aggregation: ri!aggregation, logicalexpression: a!queryLogicalExpression( operator: "AND", logicalexpressions: ri!logicalexpressions, filters: { ri!filters }, ignorefi

Hello team, I tried to set up user input task reassignment via escalation following this logic: 1. I have a User Input task which is assigned to a group called "Processors". 2. The escalation is set up as recurring every 1 hour     2.1 If the user input task was not accepted by anyone from processors group members nothing will happen     2.2 If the user input task was accepted (owner is not null) then the timer will fire and in 5 minutes it will reassign the task back to processors queue I have set it up following way, but when the timer conditions are not met, the task is paused by exception and nobody is able to access it. Any advice there please? Thanks Timer conditions, where if the owner is not null it will return true(), if it is null (so not accepted) it will return false(). c10 represents the Owner column pv!contract.contracId is the identificator for the specific task not( rule!GBL_isBlankOrEmpty( index( a!queryProcessAnalytics(

Hi! I´m trying to plan an approach for my application and I would like to hear your recommendations In my case, I have a record of Purchase Orders (PO) and Purchase Order Lines (POL) In my summary view for each PO, I can see the header data (PO) and the lines (POL) as it is shown in the image below: Now, I would like to use a button to "receipt" the PO lines. A pop-up should appear, with the same purchase order lines (the table from the record POL), and I want an extra column for the user to write the quantity and do different checks. I was thinking about using a related record action, connected to a process model with an user input task as the start form. The user input task should use an interface with an editable grid which has THE SAME VALUES of the PO lines (like, by default), and then I can add the new column in the interface I don´t know if my approach is correct or if is there a better way to re-use the same read-only grid and transform it into a table wi

Hi all - I'm trying to create multiple rows in my record, using data that is stored as an array process variable.  But i'm getting all the data in a single row.  Could use some guidance. Here's what I've got: 1. My process calls a business rule which gives me the following output: List of Text String - 3 items "Asset Transfer"(Text) "Disclosure"(Text) "Identification"(Text) 2. I've tried storing both in a record input as well as a process variable, those fields look like this: 3. I'm using Write Record and would like to create one row for each of these, but instead I get one row with that exact list of strings. How do I get one row reach each item? Thanks in advance.

The pagination element in Appian in HTML code is composed of two <span> tags. One of those <span> elements contains the aria-describedby attribute, and I need to remove it as there are duplications in the tag's content. How could I address this issue?

Hello, I've encountered an issue with an Appian form where a text field disappears when I try to fill another one. I've checked for visibility rules, read-only settings, and browser compatibility, but the problem persists. Has anyone else faced a similar issue, and if so, how did you resolve it? Any insights or troubleshooting tips would be greatly appreciated. Thank you!"

We are having embedded interface experience where in the interface we are trying to use the startprocesslink() on the hit of a button. We are facing issue of passing parameters when calling the interface in the startprocesslink() due to embedded interface experience.  Hope any one has faced similar issue and how you were able to resolve this issue

I am very new to appian , I am trying to calculate the value of " To Date field "  and show the date in the calendar , I want to add the number of days that i saved in the local varibale (local!days) to the current date to find the new date , how can i do that?  Here is what i wrote for the " days" field  a!integerField( label: "Deposit Days", labelPosition: "ABOVE", value: a!match( value:local!periodtype, equals: 1, then:{local!days}, equals: 2, then:{if(not(isnull(local!weeks)),(local!weeks*7))}, equals: 3, then:{ri!numberofmonths*30}, equals: 4, then:{ri!numberofyears*365}, equals:null, then:{false()}, default: then:{false()} ), saveInto:{local!days,a!save(local!despositdays,local!days)}, required: false, disabled: a!match( value:local!periodtype, equals:1, then:{false()}, equals:2, then:{true()}, equals:3, then:{true()}, equals:4, then:{true()}, equals:null, then:{false()}, default: then:{false()} /*DAYSSSSSS CODE */

Hi All,           I am trying to create a zip file using create zip file smart service. After configuring the parameters (documents,folder,file name) i tried to execute the smart service but getting this error. Exceptionnet.lingala.zip4j.exception.ZipException: java.io.FileNotFoundException: /usr/local/appian/ae/_admin/accdocs2/1001691/TestZip Attachments9/5/2023.zip (No such file or directory) Any suggestions on how to fix this error. Thanks in advance Pradeep

Hi All, I currently have 3 tables, managers, employees, and a third table for foreign keys managers_employees where I have a primary key, a foreign key to the managers table and a foreign key to the employees table. When I'm trying to write to the DB I'm having an issue with the employees foreign keys since they can be multiple employees but they all belong to the same manager. So for example my tables should look like this: managers table:  ID name 6  Alan, Nus Employees Table: ID Name 10  Kim, Perez 11 Luz, Asos managers_employees table ID  Manager_key   Employees_key 1        6                       10 2         6                       11 When I'm doing this in my process model in a script task after writing to the employees table, I'm not able to retrieve the employee

Hi, I'm having difficulty finding the best approach to updating a list of checkbox options on a parent record using related record associations. Essentially, I am exploring the ability to save multiple selections (child rows) on the "create" of a new record and ability to "update" those persisted selections through an update process. I have a simple example expressed below through the use of local variables for clarity but hoping a few insights will help me understand how to apply at a recordType level with related record data. The content related to post# 22489 was very helpful but not fully understanding how we can add new items and also remove (inactivate the unselected items). The end result would be the use of a checkbox or multipledropdown field where a user can add new rows (isActive: true()) by selecting and unselect saved rows (set isActive: false()) to write back to the record table. Sample code:a!localVariables( local!s

Hello, I have an Interface. Within this interface user uploads excel file containing some emails. Next user submits excel and process model is started.  Interface is published on a website.  When user uploads excel and clicks submit interface looks exactly the same, no message if the process was successful or anything. I would like to create new popup window or some message when user submits and run process with uploaded excel.  I tried using onSuccess but it didn't work. Do you have any tips?  My code looks like this:  a!localVariables( local!cancel, local!WczytanePlik, local!NazwaPliku, local!Pracownicy: if( a!isNullOrEmpty(local!WczytanePlik), {}, rule!EA_TEST(local!WczytanePlik) ), a!formLayout( label: "Wczytaj plik", contents: { a!sectionLayout( contents: { a!textField( label: "Nazwa pliku", labelPosition: "ABOVE", instructions: "Wprowadź nazwÄ™ pliku",

Hello, I'm working with a dynamik k¡link element who adds a row to a table and I was wondering why this text shows and if it possible to get rid of it: "A new grid row will be added to the grid behind you" Thanks!