Discussion Categories

The process model is showing as invalid, but there are no logs indicating the reason for the invalid status. I’ve reviewed all subprocesses, and they appear to be valid. What could be the possible cause? Is there a standard or recommended approach to debugging this issue?

I am doing example "Build an Application: Step 10". This is where you build from scratch a simple process model to enter in a maintenance request. Everything work fine from the process start form to writing the data back to the Maintenance recordType. However, the XOR cancel does not work. When I click it, the flow process as if I am submitting the form. I followed the step by step instructions exactly. I even completely deleted the XOR and is corresponding End node and rebuilt. Still same thing. 

In the below piece of code, I'm attempting to update "id" value to 567. The output expected is the same as what is in local!groupEndpointResponse with the updated value of id. a!localVariables( local!groupsEndpointResponse:{ {totalResults: 1, startIndex: 1, itemsPerPage: 100, schemas: {"schema1"}, Resources: { {meta: {created: fn!datetime(2024, 12, 8, 3, 12, 45, 350), lastModified: fn!datetime(2024, 12, 8, 3, 12, 46, 910), resourceType: "Group"}, displayName: "Abc", members: {{display: "Joe", value: "123"}}, externalId: "null", id: 2}}}, {totalResults: 1, startIndex: 1, itemsPerPage: 100, schemas: {"schema2"}, Resources: { {meta: {created: fn!datetime(2024, 12, 8, 3, 12, 45, 690), lastModified: fn!datetime(2024, 12, 8, 3, 12, 46, 770), resourceType: "Group"}, displayName: "lmn", members: {{display: "Sam", value: "789"}}, externalId: "null", id: 2}}}}, a!f

Hi All, i want to know , how to configure the below logic BY default all the option should be selected. and also in dropdown i can have the option to deselect all /select all along with all the options. Please help me how i can go about this

I have used an multiple dropdown box here and whenever i try to select more than 1 option from the multiple dropdown list it is showing this error. Can anyone please guide me through this issue kindly.Thanks and Regards.

Hello. I am having a trouble while using this plug-in. i am trying to get data from a cell in an excel file but the file is in the xlsb format and the plug in gives me the following error : Expression evaluation error at function 'readexcelsheetpaging': com.github.pjfanning.xlsx.exceptions.OpenException: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Invalid byte 1 of 1-byte UTF-8 sequence. is there anyway to use this plugin for these files? Or is there any work-around to get this same functionality? This is a step in my process model where the user has submitted the excel document. 

My company has a huge process model, includes hundreds of nodes and a lot sub process, there are a lot form nodes in this pm, they all having activity chaining and assigned to same user, we are developing on this pm and also have changes on ui and forms. When user finish and submit this form, will automatically redirect to next form node and do next form. Form data is complex list of cdt saves in process variables, and will write to db The problem is, our form can add multiple blocks of a same form, this can make list of data very big, when we added too many form blocks, likely 30 + blocks, then submit, then it shows a little action complete banner, and redirects to home page, but you can countiune this process and find next task in current user’s tasks, user can countiune task with no error. And in process instance monitoring, no error.  I guess it’s data size problem, but I didn’t find a way to resolve this problem, some times there will be a huge form.

I have a client request to look into the capabilities of converting Rich Text Format (RTF) into HTML. This is not regular rich text encoding, it's the older version of it. A sample might look something such as this  "{\rtf1\ansi\deff0 {\fonttbl {\f0 Times New Roman;}} \f0\fs24 Hello, world!}" I cannot seem to find any information on interactions between Appian and RTF. All of my searches return information relating to Appian's new rich text editor components. Is this something that simply does not exist? Was RTF deemed "too old" for Appian to work with it? Any information on the topic would be a huge help, even if it's just confirmation that there is nothing that currently handles RTF within Appian.

Hi Team, Whether we have any documentation on the difference between all the authentication types as mentioned in the subject of this post. Because, when I have gone through Appian documentation not able to get the difference clearly. Kindly guide me.

Hi Everyone,  I have issue that I am syncing the records with sync record smart service within a process model in batch after the excel upload ;the excel have around 67k+ entries I am inserting the data using strore proc after some data manipulation ;  after the sync completed when I check in the data preview section for updated records they are available there but when I try to query the records I m  not getting those newly added rows. So I did manual sync then I was able to query it. What could be the reason can anyone help?

Hello, I have a requirement where I want to build a html file out of a template which would have some special characters i.e Greek characters.  The html file is generated properly and even the alphabets are also displayed eg: alpha , beta etc.  But when the same file is converted to PDF using the HTML to PDF plugin the Greek alphabets are not displayed. We are currently using: HTML Doc from Template to generate the HTML document. HTML to PDF plugin to convert the HTML into a PDF. Can any one suggest what we can do here ,any configuration we can use? Regards, Salil Raje

In a process model activity chaining is added some tasks are executing some tasks are breaking what could be the reason?

Can anyone help me with why iam getting this error when iam try to map a new field in the record table. Iam new to appian.

So i want to create an site and add an Interface as a page in it but it should be read only and i should have fields but the data in those fields must be coming from a record table.

HI Team, We are trying to connect SFTP to Appian Server using the SFTP Smart service, We are getting the error - "  Auth fail for methods 'publickey,password' " We are providing all the required configration mention below. 'type!{plugins.ps.appiancorp.com/.../}FT_Config'( serverHostName: "hostname", serverPort: 22, scsExternalSystemKey: "key", privateKeyFile: private key , usePerUserCredentials: false(),) Plugin Verions - 4.1.0 We have tried multiple times to connect using ppk , pem files , still we are getting the Auth fail issue. Help us with some guidance , if anyone gonne throught this.

I have a csv file with delimiter '|'. When I try to run the smart service by passing a csv file where few fields are null, it is returning the error message 'Error executing SQL'. But when I replace the null with random text values it is writing the data to DB. Is this an expected behavior of this smart service? Is there any way to import or read a csv file with null values?

How do i add a new manual action in the summary view with an auto generated interface. Is that possible ?

Join Appian experts for an in-depth livestream on maximizing value from Appian's Data Fabric and AI tools. We'll explore key strategies and best practices to implement during development, ensuring you leverage these powerful features to their fullest potential. Whether you're new to Appian or looking to refine your approach, learn how to optimize your projects for success. We'll dive into practical applications, share insider tips, and answer your questions live. Don't miss this opportunity to enhance your development skills and harness the full power of Appian's Data Fabric and AI capabilities! Turn on notifications to make sure you don't miss it!

HI All, I have a requirement, where we need to generate the Dynamic Word Template. we are using "DOCX from Dynamic Template." How to add signature & check boxes in the word template dynamically Signatures: Lets say I have an Employee editable grid, whenever we add an employee, signature will be provided by employee, how we can show those signatures in the Word Template.  In the Employee form we have a checkbox field how we can represent that in Word Template.  

Hi All, There is a requirement to have a RTE component where it is working properly in the interface, But when I open that from the site. RTE Component is refreshing with the key press with the below code. Can someone suggest a way why it is refreshing with key press in the RTE component? a!localVariables( local!data: a!refreshVariable( value: a!forEach( items: ri!Data, expression: if( search("<html>",fv!item,1)=0, null, fv!item) ), refreshOnReferencedVarChange: false() ), local!emailData: a!refreshVariable( value: reject(fn!isnull(_),index(ri!qmcData,wherecontains(null,local!data),{})), refreshOnReferencedVarChange: false() ), local!linksData: a!refreshVariable( value:tostring(reject(fn!isnull(_),local!data) ), refreshOnReferencedVarChange: false() ), { richTextEditorField( label: "Query Management Links", richTextValue:local!linksData, richTextSaveInto: { local!linksData, a!save(ri!Data,append(local!emailData,local!linksData)), a!save( ri!segment, a!for

Hi Appian Gurus, I recently came across a code like this :  I noticed that using the If() function with more than three parameters works like a nested If condition. However, I couldn’t find any documentation about this behavior in Appian’s official documentation. Is it acceptable to use the If function in this way?

I'm encountering an issue where I need my suggestion function to return both a dataSubset and an output value (like a flag). The goal is to allow users to enter a new project code if it doesn't exist and make dependent fields editable. I need a way to pass that output from the rule back to the interface Trying with a!update

Hi, We have provided a read-only grid for users. The users are applying some random filters and viewing summary view of one request. When they come back the filters which they have applied are gone and they have to apply filters again.  I know you guys will suggest that we can save filters and access them. But it doesn't work because they have lot of combinations and saving those many combinations is not a good idea. To avoid losing of applied filters, we opened the summary view in new tab. But some users are getting confused to go back to grid. Is there a way in Appian to provide a link/button in the summary page to close the tab? or Is there a way to keep the filters applied when user going back to the grid from summary view?

Hi All, I found placeholder in picker component defined as "Text to display in the field when it is empty. Does not show if the field is read only."  Ref: https://docs.appian.com/suite/help/25.2/Custom_Picker_Component.html However dropdown component it is "Text to display when nothing is selected and the value is null." Ref: https://docs.appian.com/suite/help/25.2/Dropdown_Component.html So when the picker field been disabled or in readonly, it will show blank, how ever in the same page, disabled dropdown field can show the placeholder words.  Is there a way we can show the placeholder in disabled placeholder words in picker field or anyone knows why dropdown allows to show placeholder when its readonly.

Hi Everyone,I'm working with two lists in Appian and need to find the exact indices of elements from one list (local!checkList2) in another list (local!sourceList2) without sorting the data. For example, if local!sourceList2 is {1, 2, 3, 4, 5, 1, 2, 6, 3, 2, 7, 2} and local!checkList2 is {1, 2}, I want to get the indices where these values appear in local!sourceList2 in the original order. I've tried using wherecontains, but it sorts the data, which I don't want.  a!localVariables( local!sourceList: {3, 4, 5, 3, 7, 4, 7, 6, 5, 4, 3, 9, 2, 2, 3, 2, 2, 3, 3, 2, 4, 2, 2, 2, 2, 3, 2, 2, 3, 2, 4, 2, 3, 2, 2, 2, 4, 3, 2, 2, 2, 2, 2, 3, 2, 4, 5, 4, 2, 5, 6, 3, 4, 4, 7, 3, 4, 6, 4, 4, 2, 3, 2, 2, 2, 4, 2, 2, 4, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 2, 5, 6, 2, 2, 2, 2, 2, 2, 3, 4, 5, 3, 7, 4, 7, 6, 5, 4, 3, 9, 2, 2, 3, 2, 2, 3, 3, 2, 4, 2, 2, 2, 2, 3, 2, 2, 3, 2, 4, 2, 3, 2, 2, 2, 4, 3, 2, 2, 2, 2, 2, 3, 2, 4, 5, 4, 2, 5, 6, 3, 4, 4,