Foundation

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

Hi All, I have a simple audit form as interface used for auditing between members. I am trying to configure as below,     When details are entered and pressed on submit that need to save the details in database which is happening successfully except a column regarding balance left. which will be calculating the balance left with the previous row. example: Money = 1050price in row 1 = 50; balance_left in row 1 = 1000; price in row 2 = 100; balance_left in row 2 = balance_left - price= 900price in row 3 = 100; balance_left in row 3 = balance_left - price= 800 Please let me know how can we configure this in interface when clicked on submit button

Hi, I just designed a simple process which has only three nodes. They are: Start node, Write to data store entity node, and a end  node. When i click on submit, its says that action completed. But when checked the database the data is not inserted. When checked the process monitor its shows only two nodes(Not sure Why). Please let me know what's happening in back end, and what might be the reason for showing only two nodes.  My CDT looks like below Id --- Primary key autoincremented Name --- Using cons for list of names Money --- entered by user in interface Transaction_id --- entered by user in interface from_bank. --- Using cons for list of Banks Transaction_Date --- now() is used to update date. Description: The interface has only Name, Money, Transaction_id, from_bank; a cancel and submit button when summitted the data need to written directly into the database. (Which is  not happening) Let me know where might be the error and first point to check. Thanks in Ad

Hi I want to skipValidation for a button- buttonWidget() inside this function how can i include skipValidation parameter?  Thanks 

Hi! As I am new to Appian, so I have faced a problem while creating a process model. I wanted to know how can we check in a process model whether the employee id of the user already exists in the database but is in the inactive state or it is a new user? 

How to read the cell locked and password protected excel(with multiple queries in it) to save it in db

Hello, I've just developped a simple application thats will be used on mobile and on desktop computers, and I am facing some strange behaviour related with a dynamiclink. On desktop, the link always work as expected, on mobile browser it always work fine as well, but on the appian app, sometimes works fine and many times the link just won´t fire any actions. You hace to tap several times on the link unitl it comes into action and the works as expected. No errors in any case. Appian app v 21.3 Tested in Galaxy A8; Android 9; Kernel 4.4.111-22305650. Best regards

Hi community, Don't know where to report this, so used the forum.In the exercise there is a variable declared like: local!purchaseOrder: rule!VOF_GetPurchaseOrderLineItemsByEntityId(),Instead of  rule!VOF_GetPurchaseOrderLineItemsRecordByEntityId(). Both in the excise and in the answer. VOF_AdvExpP1_L3_ExA_Answer This results in this error: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error in rule 'vof_orderlineitemgridview' at function a!textField [line 6]: Could not cast from List of Variant to VOF Order With Line Item. Details: CastInvalidCould not cast from List of Variant to VOF Order With Line Item. Details: CastInvalid. Kind Regards, Erik

Hi, I have to display a caption on a icon that shows to dates on it, and I want to display one of them per line. So I need a way to insert a line feed on caption text. I've already tried putting a char(10) in between both dates, and also with char(13), even "<br>", no luck so far. Any help will be appreciate. Regards

HI I have changed name of PM but in instance it's coming old PM name how can i change instance name to new PM name? Instance  PM  Thanks 

Hi, can anyone let me know the meaning of infinity and why it is coming in the instances.  Thanks 

How to copy the latest email body to one of the columns on reply back from end user? Please let me know how to achieve this..., 

How to have customized column/field configuration to display when creating a Query based on the selection of fields while creating a category