Discussion Categories

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,

Hello, We have a requirement of capturing the bounced emails which are sent from appian cloud. Can anyone suggest if there is a way of capturing those bounced emails in Appian? 

Appian UX Design Lab is back! This YouTube livestream series is designed for low-code developers looking to sharpen their UX design skills with hands-on feedback from Appian UX experts. Our next session will focus on grids—key components for presenting data clearly and enabling seamless user interactions. Join us for a live review where we’ll explore best practices for designing intuitive, user-friendly interfaces containing grids. Livestream Date: May 8, 2025 | 11:00 AM ESTTopic: Designing with Grids What's in it for you? Get Expert Feedback: Selected submissions will receive a live UX review from Appian’s design experts, with opportunities for real-time Q&A. Earn a Badge: All participants will be recognized with the UX Design Lab Participant badge on their Appian Community profile. How to participate:  Develop your UI in Appian Community Edition Submit your UI link using this form by 4/30: https://ap.pn/4iNKWlh Join the livestream on May 8th for expe

Hi everyone, I'm running into an issue with the "Import Excel to Database" smart service plugin in Appian. When I upload a .xlsx file that has been marked as "Confidential - Internal" in Excel (using sensitivity labels or classification settings), the plugin fails with the following error: "The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (e.g. HSSF instead of XSSF)" However, when I upload the same file marked as “General”, it processes successfully. Both files are .xlsx format. The only difference is the sensitivity label (General vs. Confidential - Internal). The error suggests the file is being interpreted as .xls (OLE2 format), even though it has an .xlsx extension. It appears that applying a "Confidential" label might be modifying the file in a way that makes it unreadable to the

Hi, After migrating to 25.1 version, we are unable to download excel from any of the records. The file will be attempting to be downloaded and fails after timeout. Below is the log we found in tomcat file, Caused by java.lang.reflect.InvocationTargetException Caused by java.lang.RuntimeException: Fontconfig head is null, check your fonts or fonts configuration

Hello, I am currently taking the appian developer course and it wnats me to access the operations console from the build view waffle menu on appian designer, but as soon as I select this I am greeted with the following message:Error Evaluating UI Expression Expression evaluation error [evaluation ID = UIYZI] : java.lang.RuntimeException: Retrieving resource failed, status code: 500Any fixes to this? Thanks for any help!

I want to design the application for Employee onboarding which consisted of HR, Admin, IT and EMployee So I need to make links from one interface to another, please guide me on this

Hi Champ, I want to call an related action from an image component using the link parameter. Is there a way to do that? Regards, Ghanashyam

Hi, KIndly help me how to get keys from dynamically listed dictionary, this could be of any type means list of variant, list dictionary, list map, map, dictionary, when getting result, it is type of dictionary, when checking its type it is showing of any type.  Below is the code which is not working. a!localVariables( local!data: { id: 1, name: { firstname: "shree", lastname: "tiwari" } }, local!name: property(local!data, "name", null()), local!keys: a!keys(local!name), local!keys /*{*/ /*typename(*/ /*typeof(property(local!data, "id", null()))*/ /*),*/ /*typename(*/ /*typeof(property(local!data, "name", null()))*/ /*),*/ /*property(local!data, "id", null()),*/ /*property(local!data, "name", null()),*/ /*local!keys*/ /*}*/ ) Commented code to check type of above local!name variable. added screenshot of response for reference.  Kindly suggest how to do this in appian. Thanks in advance, Shree Krish

I'm working on a use case for comment functionality, and I'm considering whether to use Appian’s built-in Event History List or to build a custom record type to store and manage comments. The Event History List is convenient, especially with @mention support and auto-timestamps, but I'm curious if there are any reasons to prefer a self-made comment record type. Are there any performance, scalability, or user experience considerations you’ve encountered in either direction? Would love to hear best practices or examples from others who’ve navigated this tradeoff!