Foundation

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 

I know we can check the resolution of the tablet if 'TABLET_PORTRAIT' or 'TABLET_LANDSCAPE' by using `a!isPageWidth({ "TABLET_LANDSCAPE" })`. But You know there is no 'PHONE_LANDSCAPE' in Appian, how to do the same thing with the Phone?  Or can we get page width and determine what it is? Is there a way to do this? Thanks in advance!

Hello,We have a start form with a simple file upload on a cloud installation, Version 21.4; Some users experience for some files the error from attached print screen (had to hide file name); Files have .tx extension.I can't receive the files as they contain business sensitive data so we cannot reproduce error on lower environments.Checked in logs and couldn't find any clue. In admin console, under file upload we don't have any extension blocked just the check for "Enable Real-Time Virus Scanning", is it safe to disable this and ask user to re-upload same file? in order to figure if it's from this one?Older similar post doesn't offer any solution, it's not the case for VPN now, /logs/audit/blocked_files.csv is empty in my case as well.https://community.appian.com/discussions/f/new-to-appian/18528/certain-pdf-documents-are-uploaded-but-not-others-message-file-pdf-could-not-be-uploaded-please-try-uploading-it-again/73058#73058If you have experie

I am saving multiple dropdown values like 3;4;5 and if I am passing the same value into an expression rule and doing for each it isn't taking individual value instead consider as 345. How to convert 3;4;5 into {3,4,5}

I'm trying to solve a problem where we should allow only the values between 1-10 as inputs for a specific record. Can anyone suggest me a method to solve this?

Hi! I´m trying to update a value in my process model by using an script task (change value to "true" and saves it into the field "facturada) and then using the writeRecords smart service My configuration is: 1. Script Task: The value "true" is saved into the field "facturada" of my record. It´s important to say that I´m updating an ARRAY 2. Write Records Smart Service In the beginning, I was updating the entire record, but this was causing that my data got duplicated (f.example if I created 2 rows, there were 4 rows). So I´m trying to update just the field I want ("facturada") (The target in my last picture is the field I want to update (recordLineas.....recepcionada)) The error that appears is the following: How can I fix this? Thanks a lot

a!dateField( label: "Return To Office Date", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), value: ri!NIC_LeaveSummary.returntoofficedate, saveInto: ri!NIC_LeaveSummary.returntoofficedate, readOnly: ri!isLeaveApplied, validations: { if(calworkdays(ri!NIC_LeaveSummary.leavestartdate,ri!NIC_LeaveSummary.returntoofficedate)- 1 >5,"You can apply max 5 days leaves",{}), if( a!isNotNullOrEmpty(ri!NIC_LeaveSummary.leavestartdate), if( calisworkday(ri!NIC_LeaveSummary.leavestartdate), {}, "Please select weekdays. Weekends are not allowed" ), {} ), if( a!isNullOrEmpty(ri!NIC_LeaveSummary.leavestartdate), "Please select leave start date", {} ), if( ri!NIC_LeaveSummary.leavestartdate > ri!NIC_LeaveSummary.returntoofficedate, " Please select return to office date later than leave start date", {} ), } ),

Hi! I´ve just created a process model for invoices: first, the user fills the invoice fields, and then some checks are made in the process (logic nodes) to determine if the invoice is accepted or rejected (basically, if all the conditions apply then the field "status" of the invoice changes) Now, I´ve added an interface to create invoice lines. And I was wondering how can I make a similar logic (apply conditions for each row and then change the invoice line "status" to "accepted"). I know how to do it for one row, but not how can I "iterate" and make all the invoice line created to "pass" through the conditions Any help would be useful. Thanks a lot!

Hi All, I am trying to add the time to the date. todate(now()) + time(20,0,0)..it's returning GMT time.But, I need EST time to display. Any suggestion please. Thanks!

I am creating a new process model in an application and when I try to set the data type of a PV! to a record type (named "DA Transaction")  It doesn't show me the option to use this record type or any other from the same application. I looked in an older PM from 2020 in the same app and it does have PV! with the correct record type, but if i try to create a new PV in the old PM, again i cant find the record type... I have no clue how to approach this, has anyone seen this before? in the picture you see the old variables with the correct data type and here you see that when i search for it, it doesn't find it. (I tried searching many different ways)

Hi! I´m trying to query a database with the following code (SQL) into the QueryDatabase Smart Service of the Process Model SQL STATEMENT: ------------------------------------------------------------------------------------------------------------------------------------------------------------- Select sum(TotalLineas) as TotalFactura from ( Select PRECIO_UNIT*CANTIDAD as TotalLineas from CPF_LINEAS_FACTURA where ID_PEDIDO = ac!pedidogroup by ID_UNICO ) ------------------------------------------------------------------------------------------------------------------------------------------------------------- If I use the code selected in green it gives no problem. But If I try to include the second "select from"  I have the following error:  What can be causing this? Any help would be useful

How important or realistic is the recommendation to keep under 30 nodes? Has anyone had more than 30 nodes and ran into major issues? How does memory usage impact this?

Hi, I had an requirement to send a file over SFTP. To acheive that  i had created key under third party credential in admin console(Remote server). Using that specific key in send file over SFTP plugin. But getting below error. Error establishing SFTP connection. Confirm your hostname, username and password. See application server log for more details. Error Message: Unable to retrieve credentials from SCS: This plug-in [com.appiancorp.a2.process.runtime.activities.sftp] is not registered to access secured values for the given external system key [sftp-credential]. Check the external systems plug-ins list in the Administration Console.  what could be the reason behind this error?  what does below error mean? Error Message: Unable to retrieve credentials from SCS: This plug-in [com.appiancorp.a2.process.runtime.activities.sftp] is not registered to access secured values for the given external system key [sftp-credential].

We have this defect showing up as "High" in the HealthCheck (done each 2w) of our Appian infra: [Process Model Name] (44.4% of all CPU time, 67.6% of all operations, 117 mins of CPU time, 3213596 operation count) We don't have a huge number of processes of this type per day (around 600 complete), and the number of nodes is low. We also see in the same HealthCheck that the input interface it uses is called 1 million times! Interface.[Process Model Input Interface] (1056180 calls, 113 ms peak average) There is no way our one hundred users could call the interface one million times - there would be many more processes per day. Has anyone ever encountered such a repeated call to an input interface, causing huge CPU usage for a single process? Is it possible that the 1'500 such "Active" processes (kept as drafts of user input) be somehow regularly polled, thus calling the input task, and cause the huge number of calls to the interface ? If the above is pos

I'm trying to parse a large data file into our sql database.  I have found the import csv to database smart service which would work with the "|" delimiter of the dat file except it has metadata as its first and last lines (not a csv header).  I have uploaded the file into an appian document object, but I can't figure out how to remove those lines so it works with the smart service. I should also note the dat file is coming from an external datasouce and cannot be altered prior to ingestion.

Hi! I´ve made a read-only grid and used it in another interface. The read-only grid contains Purchase Order Lines. I would want to select some or all the rows (PO lines) and change their "Estado Recepción" value from "No Recepcionada" to "Recepcionada" I searched and discovered the possibility to make the rows of the grid selectable. But for what I have seen, this only allows me to save the rows selected, not to change a value of the row directly. ¿Is there a way in appian to assign a button for each row and change a value of the row directly? ¿Or is it possible to put a checkbox component inside each row, so that when you click the checkbox, the status value changes? If not, I was thinking about using the selection, put a button to save the selected rows, and create a process model to change the status of the selected rows What do you think? Do you recommend me another option? Thanks a lot!

Hi all - I am building out a document focused application and have created a Document Record that stores document properties, along with a link to the document. I'd like to built out a UI that is similar to Knowledge Center capabilities, but end user focused, as part of our application. For example, (based on roles),  the selectable document list (which i've done), but including actions like Delete, View Properties, File in Folder, Versions, etc.  Similar to KC in the image below. My question is:  Is there a way to embed a subset of knowledge center into my app, with a configurable subset of capabilities?  Or do I built it out myself adding the appropriate related actions?  If the latter, is there a place I can look to see under the covers as to how KC is configured?   And a somewhat related question - i've defined a UI for the user to upload a document and am having trouble figuring out how to map the fileName to my customer record property.

In the grid there are tag fields for different values, initially the values are null as well. For null, the tag field is not working