Foundation

here am using record to display the grid along for that grid need to add the filters  a!localVariables( { a!gridField( labelPosition: "ABOVE", data: 'recordType!{81e1435a-de76-4bff-8b85-6ae5a581d036}Documentation Checklist', columns: { a!gridColumn( label: "CIF", value: tointeger( fv!row['recordType!{81e1435a-de76-4bff-8b85-6ae5a581d036}Documentation Checklist.fields.{cif_int}cif_int'] ), align: "START", width: "NARROW" ), a!gridColumn( label: "Customer Name", value: fv!row['recordType!{81e1435a-de76-4bff-8b85-6ae5a581d036}Documentation Checklist.fields.{customerName_txt}customerName_txt'], align: "START", width: "1X" ), a!gridColumn( label: "Source", value: a!linkField( links: a!recordLink( label: if( rule!APN_isBlank( fv!row['recordType!

am trying to create read only grid using record type but am getting this error, record type is updated only  

I upload multiple PDF files in the interface. I want to save the files in a folder that matches the name of each PDF file.

Is it possible to direct flow from Write to DSE Smart Service on error?  Ideal scenario would have the DSE node fail, and based on error, flow would continue to different node.  Right now process pauses when DSE fails and email goes out. Is it possible to continue process flow on DSE fail?

Hi, we need to create an integration with JMS on Cloud, being able to send messages to an external JMS Queue or Topic, and starting processes with a receive Message Event This can be easily done in a OnPremise Installation, but according to the documentation, this is not supported on cloud, but most of the cases can be achieved with a plugin from the market, but in the market we only find two old smart services that are only supported in previous appian versions. How can we achieve this requirement if we are working in an on Cloud instance? Regards

Hi, Please help me out to populate date and time in fitnesse script |set test variable|start_date             |with|10/13/2023 02:30| |populate field |Start Date|with|tv!start_date| Thanks

Hi  i have a requirement to show only unique index value while using for each how can i do that ? in local!voucher Details have 4 item that is duplicate i need only unique value

Hi all, I need to validate that in a texfield, the user on type characters, I mean (100k, 80k, ect), numbers with text values. if the user enters 10k,20k like in textfield, I have show some validation message,How could I achieve this, is there a special functions? Can anyone help me please on priority?

I have a Process Model which is Called from Web API via Start Process. a!startProcess( processModel: cons!MA_WRITE_TO_DB, processParameters: { getData: local!getData, } onSuccess: a!httpResponse( statusCode: 200, body: a!toJson( { a!map( value: fv!processInfo.pv.value ) } ) ), ) I need to return value from Process Model(so we have used Activity chaining in PM), but due to  Activity chaining its taking too much time.  Is there any alternative way(without Activity Chaining) how i can return the value from PM so that it takes less time

a!gridLayout( emptyGridMessage: "No Claims assigned", headerCells: { a!gridLayoutHeaderCell(label: "Dietary Ingredient"), a!gridLayoutHeaderCell(label: "Claim"), a!gridLayoutHeaderCell(label: "Decision"), a!gridLayoutHeaderCell(label: "Category"), /*a!gridLayoutHeaderCell(label: "Updated Cat"),*/ a!gridLayoutHeaderCell(label: "Keywords"), a!gridLayoutHeaderCell(label: "Comments"), a!gridLayoutHeaderCell(label: "RFI") }, columnConfigs: { a!gridLayoutColumnConfig(width: "DISTRIBUTE"), a!gridLayoutColumnConfig(width: "DISTRIBUTE"), a!gridLayoutColumnConfig(width: "NARROW_PLUS"), a!gridLayoutColumnConfig(width: "DISTRIBUTE"), /*a!gridLayoutColumnConfig(width: "WIDE"),*/ a!gridLayoutColumnConfig(width: "DISTRIBUTE"), a!gridLayoutColumnConfig(width: "DISTRIBUTE"), a!gridLayoutColumnConfig(width: "NARROW") }, rows: {

Hi Team, I need solution for this requirement, please help me on this. We are generating the QR code and attaching to the document and sending to document to external system people through mail. Requirement is like once the external system people open the document and scan the QR code, need to redirect to Appian portal and open the document. Thanks in advance.

Hi  I have dynamic List of comments. A comment may have one link or more (there is no restriction on the number of links), as an example is shown below. 1. [{color:#4F50FF}ISSUE-120{color}|https://apps.Tsca.com/suite/sites/lowrider/page/home/record/lQBzulQNzBso196rg0E7ESk00riOSRPp8CPq_KH4VquOjcsriDU6l5j_CxkCY3Ckxt7DZght8D6EZ4CtItPtDmx_uQf3vIm9JzMPvW8QmMKoSTzXRo/view/summary] has been updated to the following status: In Review in Tier 1 by Klaus Lewis,  2. [{color:#4F50FF}ISSUE-122{color}|https://apps.Tsca.com/suite/sites/lowrider/page/home/record/lQBzulQNzBso196rg0E7ESk00riOSRPp8CPq_KH4VquOjcsriDU6l5j_CxkCY3Ckxt7DZght8D6EZ4CtItPtDmx_uQf3vIm9JzMPvW8QmMKoSTzXRo/view/period] ,     [{color:#4F50FF}ISSUE123{color}|https://apps.Tsca.com/suite/sites/lowrider/page/home/record/lQBzulQNzBso196rg0E7ESk00riOSRPp8CPq_KH4VquOjcsriDU6l5j_CxkCY3Ckxt7DZght8D6EZ4CtItPtDmx_uQf3vIm9JzMPvW8QmMKoSTzXRo/view/period]  has been updated to the followi

Hi,everyone How to publishing process models as web services.How to configure in WSDL URL  .Need advice and help!!! Thanks

What should I write script for grid Thanks

Is it possible to download the data in Compare and Deploy grid into an Excel file. Or any way to implement a custom report around it to download the data in that grid?

Hello Techies, We are planning to roll out Appian to thousands of our customers and looking to onboard a digital adoption platform like "WalkMe" with Appian. They typically use either JavaScript or browser plug-ins to work with a web application. Appian does not support adding JavaScripts to sites or elsewhere.  Have you used DAPs in your projects? If not, have you configured JavaScript anyhow?

I have a grid layout consist of dropdown,  If I select a value on the first drop down then if I add new row it will show new drop down on the second drop down I need to hide the value that is selected on the first drop down. Here is my initial code. I just  created it but the problem is in choiceLabel it's showing id. The requirements is to show the column "name". I try indexing it but it show an error.  a!localVariables( local!service: rule!IBM_GetServiceByFilter( extractData: true, fetchAll: true, status: {cons!IBM_SERVICE_STATUS_PENDING_APPROVAL,cons!IBM_SERVICE_STATUS_ACTIVE} ), local!user: user(loggedInUser(), "firstName") & " " & user(loggedInUser(), "lastName"), local!now: now(), { a!gridLayout( labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "List of services"), a!gridLayoutHeaderCell(label: "" ) }, columnConfigs: { a!gridLayoutColumnConfig(width: "D

Hi, I have a date time field in DB stored with max value 9999-12-31 00:00:00.000000 i have a record type synced with this DB column field as date time type. when i am querying the record from Appian I am getting 4/10/2292 11:47 PM as result. when i verified the field in the record list this expression is used if( isnull(fv!row['recordType!{dd3dec1e-fa8b-4d23-b987-227710abaa1b}PM Processdir.fields.{cad2d16f-825b-49a8-a577-aeb727fb031d}dueTs']), fv!row['recordType!{dd3dec1e-fa8b-4d23-b987-227710abaa1b}PM Processdir.fields.{cad2d16f-825b-49a8-a577-aeb727fb031d}dueTs'], datetext(fv!row['recordType!{dd3dec1e-fa8b-4d23-b987-227710abaa1b}PM Processdir.fields.{cad2d16f-825b-49a8-a577-aeb727fb031d}dueTs'], "default") )

Hello , In the current client we have the need to create a document (specifications for tenders). The functionality is that in the bpm there is a form with several sections that the user must fill with information. This information must be formatted (tables, bold, list of items). We need to be able to add this formatted text in specific points of the document that is used as a template. We have tried with the smart service dynamic template but it does not preserve the text formatting. What would be the right solution for this?

Hi, In DB we have one date set to 12/31/9999 (MM/DD/YYYY) which is a data source for a recordtype. When this record type is used in one of the site page the recordlist date and time column is display the wrong date as below  Is it somewhere setting max date? Not able to find. Expected Date to display in recordlist: 12/31/9999

Hi,  Has anyone ever had to send an encrypted password from Appian to an external system? In my case, I need to send an encrypted password to RPA (Blue Prism) and I have tried the encryptvalue() function of this Encryption Functions plugin  that uses the AES-256 method to encrypt, but the RPA team is not able to decrypt it from Blue Prism... I had also thought about using the native encryptedTextField() component but I don't know what method it uses to encrypt or how to obtain the key needed to decrypt from an external system. Thanks

a!localVariables( local!array: cast( 97, { { item: "stapler", name: "Mike", countryId: 1 }, { item: "printer", name: "Larry", countryId: 2 }, { item: "laptop", name: "Mike", countryId: 1 }, { item: "glass", name: "Mike", countryId: 3 } } ), local!updatedArray: a!forEach( items: local!array, expression: remove(fv!item,"item") ), local!finalArray: a!forEach( items: local!updatedArray, expression: remove(fv!item,"name") ), local!finalArray )

An Award Record has 3 sections: Section 1, Section 2, and Section 3. Section 1 and 2 combine to serve as a unique identifier. When you edit Section 3 of an Award Record, all of the Awards with the same values for Section 1 and 2 should be updated as well. This process model updates the value for Section 3, but it does not check to see if there are other awards with the same combination of Section 1&2 before writing to the DB. I was told to "build a dictionary in building the CDT before the DB write and write the array". Any help would be greatly appreciated! Thank you

Hi, what is the Appian's Policy for data collection in regard to a company data?  and we have a use case to enable the SSO authentication via Microsoft to login into the site or portal that we made in an application. what is the process for the same?  

Hello Community! I have next error after running tomcat: aused by: java.lang.ClassNotFoundException: Unable to load class: org.postgresql.Driver from ClassLoader:java.net.URLClassLoader@326de728;ClassLoader:AppianWebappClassLoader  context: suite  delegate: false----------> Parent Classloader:java.net.URLClassLoader@326de728                at org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:56)                at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:304)                ... 29 more        Caused by: java.lang.ClassNotFoundException: org.postgresql.Driver                at