Foundation

Hi! I´m trying to do the following query with the "query database" smart service: UPDATE CPF_LINEAS_PEDIDOSET FACTURADA = true where ID_PEDIDO = ac!pedido and MATERIAL = ac!Material The variable ac!Material can be multiple (f.example Material 1, Material 2). This is because in a previous step in the process model, the user can enter several rows. Because of using a list of string in the clause "WHERE" (I´m using it as a filter), I think I´m returning the following error: How can I fix this? Thanks a lot!

Hi! I have created a process model in which the user can add new rows.  I´m saving the value of the different materials (pv!Record....material) in a process Variable ("MaterialesDefi") In this pick, you can see the value adquired and saved in the process variable. In this case: zz;vv The fact is that I want to use this materials in a WHERE clause (SQL syntax),and it is not working. Even though I tried to use a function like SUBSTITUTE() when assigning the value, trying to substitute the ; for the ",", the result of the pv is always the same I know that to use it in a where clause, I must use the operator "in" and also the string should be (string1,string2). But I haven´t managed to do so, the value of the pv! remains like untouchable What can I do?

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?

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

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?

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.

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

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

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

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

I have a csv template which is expecting few fields(could be 100 columns). First i created a dummy template to see if this even works and i am facing some challenges here, need some help in understanding what i did wrong. Below CSV has the data returned however not in expected format. These are supposed to print in 3 different rows but not in same row. Did a!foreach for each column to return its value and saved in respective variables... my actual template: a!localVariables( local!data: a!queryEntity( entity: cons!TST_DSE_TEST, query: a!query( filter: { a!queryFilter( field: "createdOn", operator: ">=", value: fn!datetime(2023, 7, 1, 7, 2, 5, 0) ), a!queryFilter( field: "createdOn", operator: "

Is there a way to find out what appian object is being pointed at from a Opaque url? URI: /suite/design/(opaque ID) One way is just going to the URL to get the object name. But for some reason, when I go to that URL, my environment is crashing. I am suspecting the UI is doing large number of calls that is causing the heap space to run out.

here i have data like right side.... once i select the data from dropdown the value but i have to show the in the below remaining data.. how can i achieve this ?

Hi! I´m trying to use the smart service "Query Database" to change the value of a concrete field. I have managed to use the an "Update" and "Set" SQL statement to update a database used in the process model which works correctly The fact is that now I would like to do a similar query, but to update a record which is NOT BEING USED in this process model ("CPF Lineas Pedido") Even though I created the query and the process model runs OK, the value of the field "facturada" does not change properly. Also, I brought the new Record as a process variable, but its value does not change (I´m not using it in the process model because I only need to update one value, the one with the query) What can I do?

Hello everyone, I have one question : I need to generate 7-8 different types of reports and when the user clicks on the particular report it show get downloaded in Excel.  So, how to implement it and what to use? Thanks.

Hi, I am trying to upload an email attachment (size: 1.5MB) via the a!fileUploadField component on an interface, but it throws an error indicating that the file "could not be uploaded. Please try uploading it again." On trying with different files (email attachments), this seems to be working fine. I could not find any specific issues with the file which results in the error, but I'm interested to know what is causing this. Can you help me out with what may cause this error? I am also interested to know where I can find the logs for this - I did check the system logs (Appian Cloud), but I am unable to find a file that will contain the log for this issue.

I'm trying to populate conditional dynamic data in my docX. I have regular data populating fine, but I can't seem to find the correct syntax for conditional statements. Here's what I have so far that keeps evaluating to false:{if "<<${doc.center.subjectType}>>" = "Individual" "Is Individual" "Not Individual"} Anyone know what's going wrong here? or where I can find documentation on this? Thank you

Hi Team, I'm using a single process model for creating employee and updating employee(related action). While creating employee simply i create a new folder and move employee documents there. But incase of updating i need to add documents to the same folder. I don't know how to achieve this. I tried with tofolder("emp 1") function with a or gate to check whether it's updation or creation but getting error. Then i removed or gate and checked with the create folder then move documents methods again for updation process it creating a new folder with same name. Need support on this.. Thanks in advance