Foundation

Looking for recommendations on the best way to go about letting a user print an editable grid. Thanks in advance.

Hi I want to convert the number to 8 digits for example if the ID equals 19 the result should be 00000019 by adding six zeros before the value.can I solve this proplem using for each  ? 

Can someone let me know how to apply query  filter in Datasubset .

Hi All, In My interface I am exporting the data story entity to csv using "exportdatastoreentitytocsv" . once export is done, I am giving an option to download that exported file using documentdownload link in a card interface (I used card layout to make it effective).Now when this document is downloaded I want to update a rule input  at the same time ( When user clicks on the card layout ,document download and rule input updating should happen at same time ), but I am not able to do it.Can any one suggest how can I do that. Thanks in Advance, Siva Surya. 

I want to the change the value of same tag in a single document at runtime for example :-  Schedule_1 : A Schedule_1 : B Schedule_1 : C Schedule_1 : D

Want to know best approach to filter data after getting fetched from Stored procedure

Hi,  The datetext function returns incorrect date with different locale settings. Please refer below:  datetext(ri!dateInput, "dd MMM YYY")  Input Date: 12/29/2021 - English/United states  as locale -> 29 Dec 2022  Input Date: 29/12/2021 - English/United Kingdom as locale -> 29 Dec 2021 - this is correct.  The dateInput is sent as a rule input of type 'Date' to the expression rule. 

Hello newbie here I have a task that I need to compare the current values to  updated values . Once the Coporate Name and Merchant Name have a difference it will pop up a confirmation messager after clicking submit. I hoped you can help me. Thank you ♥

Hi People, I have a requirement where i have to generate both Excel and PDF files for users to download and see Is there any approach that can lead me to achieve to both

Hi  when i click on related action, it showing message as action completed and even in the monitoring view instance also created. but after i click it's not redirecting to particular interface  Thanks  

Hi Team, I have 2 chained user input tasks in between I am generating Dynamic (MS Word 2007 Doc from Template) documents from multiple templates and converting into PDF . but when number of documents exceeded more then 50 that chaining is failing .. please suggest me a best approach so that when user click submit in first user input task directly land to next page with converted PDF preview. 1. Scenario fails if document templates exceeds more then 50 , because appian will not allow then 50 chain nodes . Your suggestion is highly appreciated. Thanks,

There is way to list the applications in the environment? 

I am exporting a report that contains data on two tabs and am using two Export DSE to Excel nodes. Some tabs share the same columns but there is inconsistency in the format. 1. Column Headers are bold in tab 2, not in tab 1 2. ID formatted as number in one, text in another An ID from Appian that should be exported is 000002233403600018 In the respective column, the ID is exporting differently on each tab: Tab 1:  2.2334E+12 Tab 2: (this cell also says an alert message: The number in this cell is formatted as text or preceded my an apostrophe). 000002233403600018 How can I apply the formatting from tab2 to tab1?

Hi Community, I'm working on a local install of Appian and want the site to be secured(HTTPS) instead of HTTP. I generated a certificate and key with openssl and now I have the crt,crs,key files. I'm not sure what configs I need to update or where I place these generated files.  The guide in documentation (Configuring Apache Web Server with Appian - Appian 21.4) wasn't quite clear about it either. Thanks in advance for your help.

Hi All, Emails from send email Smart Service are going into recipients junk folder  .Can anybody help  me on this

Hi Team, A small help required, there is a report with certain fields to be used as search fields. When the user enters any value in those fields then the system should capture all of the answers the user inputted into the UI and transfer it into the excel template. Could you please suggest how to achieve this? Thanks in advance. Anandita

I had been using documentViewer() component to make an inline view for pdf files. But when Excel/PPT files are uploaded it just gets downloaded, unable to have a inline view for it. Is there any other component or any other way to achieve it? Thanks! in advance. 

How does one send an email to a process? I have the following flow, sending email works fine, but did not understand how to configure receiving email (in Managed Service / cloud): I am currently using Appian Community Edition Thanks in advance!

Hi, In the latest version of Appian, there is an option to get the excel by just clicking the checkbox in the user interface section in record type ("Show export to excel button").This generates the default template of excel. But I have a requirement in which i have to give my own customized excel template. How is it possible? Can anyone please help? Thanks in advance. Anandita

Hi, my requirement is to set the default document so i have taken value from my database which i have already uploaded and i used those values into the linkfield with  a!documentDownloadLink but still i unable to see the document can you please help me where i went wrong, Below is my code. a!localVariables( local!text:"Please refer these document and send your reply soon", local!newGrid:'type!{urn:com:appian:types:SHA}SHA_receivedDocuments'(), local!emailSubject:"Sending mail regarding Property Documents", local!document:40915, local!docName:"Dummy Document", { a!sectionLayout( label:"", contents: { a!richTextDisplayField( labelPosition:"COLLAPSED", value:{ a!richTextIcon( icon:"file-text", color:"ACCENT", size:"LARGE" ), a!richTextItem( text:"Document", color:"SECONDARY",

Hello, I am trying to simply display a document image as a billboard. I have added the document and created the constant but when I try to call the constant inside the document image I get an error: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!documentImage [line 3]: Could not cast from DocumentImage to Document. Details: CastInvalidCould not cast from DocumentImage to Document. Details: CastInvalid here is the code we are using: { a!billboardLayout( backgroundMedia: a!documentImage( document: a!documentImage( document: cons!G6EGAF_KPMG_HOWYOUGROW1) ), backgroundColor: "#f0f0f0", overlay: a!barOverlay( contents: {} ) ), the image is a JPG because that is what appian likes. I am out of ideas. Please help

Given a string containing a username (this can change easily to user first + last name), I would like to assign a task. I am using the following expression to get the user =touser("Yoel.Feuermann-yoel.feuermann@zencargo.com", "-")[1]) if I try the above in a FORM - it works. but If I have it in the assignment expression - it doesn't assign properly it gets assigned, but to an empty user: 

Hi, I am getting this error

As someone who likes to have code with easy to read comments explaining what everything does and why, I like to use the annotation feature on my process models. However, the annotation boxes have the baffling functionality of obscuring nodes beneath them. I'd ideally like to just stretch an annotation box over a pack of nodes and note "These nodes are here for purpose x" so the next person who looks at them doesn't have to dive into the nodes to figure it out. Is there any way to do that currently without obscuring the nodes I've put the annotation box around? And if not, can we request that for future updates?

Hi,  I have a webapi created in appian that starts a process model, it always returns a 200 status code because starting the process correctly, but this process can fail. Is there any way that this webapi does not return statusCode 200 if the process fails at some point? Thanks