Discussion Categories

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!

Hello everyone, We are currently facing challenges when it comes to identifying users who are part of Constants of Type "User" or "User or Group". This poses a problem when we need to deactivate someone's account and remove or replace them from all associated groups and constants. We have successfully obtained the list of group names that a user (e.g., the logged-in user) belongs to using the following code snippet: a!richTextDisplayField( value: { a!richTextBulletedList( items: { a!forEach( items: getgroupsformemberuser(loggedInUser()), expression: group(fv!item, "groupName") ) } ) } ) However, we still encounter difficulties in identifying users who are part of Constants of Type "User" or "User or Group". We are considering the use of constant descriptions to improve the search process for these constants. If you have any

HI Team I have a scenario , where I have to read User login logs daily and save into database. Solution: > I have created a process model to run in a scheduled manner i.e, daily once , In that I have used readcsvlog( "login-audit.csv." ) It is working fine when i debug process model. Issue: when the process model triggers in scheduled manner, it is unable to read csv file. Getting empty data Please feel free to advice any solutions

Hi All, I moved an object from Application A to Application B. When I deploy the object from Application B to higher environment it adds the object successfully to Application B. But I notice that the object is not removed from Application A in the higher environment. What do I need to do for the object removal? Do I deploy the whole Application A? Does anybody have an insight on this? Appreciate your help on this! Regards, Sakshee

Hi All,I have used Plug in "PDF from HTML" to generate PDF from the html doc.HTML has the expected data with 34 rows but PDF generated has only 28 rows. can anyone guide as to how the last 8 lines are getting truncated in the PDF. Please let me know how to have all rows in PDF generated from HTML doc.red  highlighted part in HTML is not getting generated in PDF.

What is the difference between a!queryRecordType()  and a!queryRecord(). In which scenario  I will use these  two...

Hi all, Is it possible to add cusomField1 to 10 into record type user ? My first approach was adding a custom record field but user function cannot be used inside. Any idea ? Regards  Jean-Alain