Foundation

Hi all  From an Interface, I need to extract Data from a given CSV file (present in APPIAN). The only solution I am seeing is to extract the data into a DB table on the cloud and then query it.  Does anyone have the same issue? Does anyone know a possible solution? 

Has anyone created a PDF Template where a field can flow to a second page if needed?  I have a need where the selected data may fit on one page but may also need to run to a second page.

Hello, If we want to keep alive a process in order to use reports to show information to the customer, is that a big memory usage for Appian?  Thanks

How to configure the execute stored procedure smart service?

I have to update 6rows in a table and need to create a new row with updated values in a table. I have used query entity to fetch the data and configured in script task at output and writing into the table.but am calling same rule for 6 times to update each fields,so it may not work efficiently.can you provide me alternative way. Thanks in advance

Hi, Basically, I need to upload a document into Appian BUT I only have the link for that document and I want to use it directly on my interface/process model. there is a way to do it or I really need to upload it manually? Thanks

Assume I have a form which saves many parameters into a rule input myDataDict of a custom data type with different entries, let's say myDataDict.name (required field) and myDataDict.common is directly visible on my interface. However, in addition to the visible things, I want to automatically populate myDataDict.timestamp with the date-time when the submit-button is pressed. How do I do that in the most standard way? Where do I have to place my a!save()-call? Inside my a!buttonWidget() ?

Here I have attached process model config image,I want trigger different mail based on order status but when I try to configure condition it is not showing other two email option. Any Idea how to do this?

Hello, I am facing the below error while completing one task by clicking on a button. Also, I am getting the below error for the same task while I am trying to complete the same task using the Process Model's User Input Task's 'View Form' option: The process is getting stuck on this user input task without throwing any error. This error has been occurred after Appian 21.1 release. Is it something related to the new release? Please help me in resolving the issue. I can't post the code here due to some security restrictions. Thank you in advance.

Hi Experts, Is it possible to generate pdf file with data in in tabular form. I have a requirement where I need to generate the pdf having tables which contains rows defined dynamically.

We are trying to read emails in a process model, so we are using the node "Receive message event" but we don't know how to indicate the email where we read the information. For example, if we have the email "read_event@gmail.com" and we want to read the body in the process model, how can we indicate that we wan't to read this email?

I am trying to populate the values of a pull-down menu from a database. For this purpose, I defined cons!GENERIC_TASKS which points to corresponding database entity. I also have the following expression rule which reads all necessary data from the respective entity: a!queryEntity(  entity: cons!GENERIC_TASKS,  query: a!query(    selection: a!querySelection(      columns: {        a!queryColumn(          field: "genericTaskName"        )      }    ),    pagingInfo: a!pagingInfo(      startIndex: 1,      batchSize: -1    )  ),  fetchTotalCount: false) The test result of this rule looks promising since it contains all required data, the labels and the values. In my user interface, I am no

Async subprocess Vs Start process activity         which is best in terms of performance and max thread?

Sned e-mail smart service hangs without showing any errors on Process model Monitor Process View -> Process Detail screen. Also no smtp/mail related log messages available in tomcat-stdOut.log file.  Cusom.properties setup done as per https://docs.appian.com/suite/help/19.3/Mail_Server_Setup.html Tried using  toemailaddress/toemailrecipient - Not successful. Any other log file i should be looking into for processuuid, custom sender emails errors?  Is there any mail-listener log file available to check? If yes, could you suggest where/how to find this mail-listener log file location, please? - thanks. Example Screen,

I am noticing some behavior for the multipledropdown field component that seems unexpected to me. I have included an interface code snippet below, which is what the following example is based off of. The issue is this: When I select any value from the muldipledropdownfield in the code below, the most recent selection is added to the end of the array in local!selectedColumnsToDisplay. However, when I select a second value, the index of the previous selection changes, and it moves to the position that it is in the choiceValues array. For example, when the page loads the value of local!selectedColumnsToDisplay is {"Three", "Four"}. Then, I select "One" from the dropdown. Now the value of local!selectedColumnsToDisplay is {"Three", "Four", "One"}. Then, I select "Two" from the dropdown. Now the value of local!selectedColumnsToDisplay is {"One", "Three", "Four", "Two"}. The val

Just checking if there any options/functions available to search specific text on Appian application's constant objects.It looks we can only search the content of expressions/rules not constants? For example, one of the constant object: EMAIL_VALUESwith array values Test1@xyz.com Test2@abc.com Test3@ijk.com If I'm searching for the text "@xyz.com", should show the result of constant name "EMAIL_VALUES". Thanks.

Hi, richTextItem not reevaluate once surveyDoc variable changes, can anyone help me a!richTextDisplayField( label: "", labelPosition: "COLLAPSED", value: { a!richTextItem( text: {index(local!languageData,"survey",{})}, style: "STRONG" ), " : ", if(count(local!surveyDoc)>0, a!forEach( items: local!surveyDoc, expression: { a!richTextItem( text:document(tointeger(fv!item.appianDocumentId),"name")& char(13), link: if(rule!APN_isBlank(fv!item), null, if(rule!TCA_isFileTypeSupportedInDocumentViewer(fileType:document(tointeger(fv!item.appianDocumentId),"extension")), a!startProcessLink( processModel: cons!TCA_PM_DOCUMENT_VIEWER, processParameters: { documentId: fv!item.documentId, appiandocid:fv!item.appianDocumentId } ) , a!documentDownloadLink( label: document(tointeger(fv!item.appianDocumentId),"name"), document: fv!item.appianDocumentId ) )) ) } ),a!richTextItem( text:"Not Available&qu

I have a checkbox field that is saving an integer if checked as true. However, when I check the summary interface the checkmark is not there but it does save the value correctly. Please help. New to appian. Thanks in advance a!checkboxField( label: "", labelPosition: "ABOVE", choiceLabels: {year(today())-2}, choiceValues: {year(today())-2}, value: if( ri!Address_Change.'year-2', {year(today())-2}, null ), saveInto: a!save( ri!Address_Change.'year-2', if( isnull( save!value ), null, {year(today())-2} ) ), validations: {} )

Hi, Can we skip the Document Reconcilation task generate by Reconcile Doc Extraction Smart Service? If yes how it would be possible.

Unable to access documents related to Sales in Appian academy, i see for my other team members who can access documents like various comparision documents - Pega Vs Appian, Mendix vs Appian etc., Please provide required access

Hello, If I have an XLS doc in a process model, how can I read the information in different sheets and cells?Thanks

Hi, I would like to know if there is an option/way to assign a task to a user and/or group to a "Start Event" node (similar to the "User Input Task" node)

Hello community, I have a scenario where user will submit a request and later he have to update the value before the request is approved. In my process model I have request form as a start form , a write node to write to request table, then a user input task which will assign task to approver.  Now even after the task is assigned the user can go and change the number of items. This must be possible only before approval. User should have a form where he can  edit the form he submitted. On click of "update" button the values should be updated in the process instance pro and the task already assigned should have a updated value. Please help me to solve this.

{ a!gridLayout( label: "Customer Details for Loan Transaction", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "Customer Name"), a!gridLayoutHeaderCell(label: "Customer Address"), }, columnConfigs: { a!gridLayoutColumnConfig( width: "NARROW", ), a!gridLayoutColumnConfig( width: "NARROW", ), }, rows: { a!gridRowLayout( contents: { a!textField( value: ri!customerDetails.name, saveInto: ri!customerDetails.name, ), a!textField( value: ri!customerDetails.address, saveInto:ri!customerDetails.address, ), }, ), }, addRowLink: a!dynamicLink( label: "add field", value: 'type!{urn:com:appian:types:SSA}SSA_CustomerDetails'(), saveInto: ri!customerDetails, ), selectionSaveInto: {}, validations: {}, shadeAlternateRows: true )} In the above expression, by clicking on Link, a new empty rows are added to grid, and type! plays a role in it, i'm still confused, how does type! will do it exactly?

I want to dispaly a confirmationMessage :  "For more information please click here" for the button. a!safeLink: ( label: "click here", Url: "Www.google.com") Please help me to get this .