Discussion Categories

In many cases, we have to do join other than primary key for the tables as same can't be configured with sync Record type and ultimately, we need to depend on  Database views and we loose many capabilities of Sync Record type

I'm trying to write into a record and earlier it was getting written but now it just pauses indefinitely at "write record " node. no error nothing , no discripancy in data too

I understand that Record Types are generally preferred over CDTs in modern Appian development. However, apart from plugin compatibility (some plugins only support CDTs), are there any other real advantages of using CDTs over Record Types? In what scenarios would choosing a CDT be the better or recommended approach compared to a Record Type?

Hi All, I am getting this error after upgarding the SFTP Functions Plugin version from 1.7.0 to 4.1.1 -  Error copying the Appian document to the remote server. See application server log for more details. Error Message: Permission denied Can someone please advise urgently what changes are required to use this upgraded SFTP version. Regards, Nirupama

I'm using the Microsoft Document Editor Helper Servlets and Functions advanced plugin to display editable Word/Excel/PowerPoint documents from our Knowledge Center in an interface via microsoftDocumentEditorField().However, a failure popup appears when users try to open/view/edit the document (screenshot attached for reference).Please suggest the possible steps or configuration changes required to resolve this issue?

Hello All- We have created a connected system plugin which uses delegated permissions to authenticate the user  As part of this plugin we are using the book definition route of pulling the access token from the context, The issue here is we had to authorize the connected system every single day to ensure the token remains active & not expired. If the user relogs in the token should always be a new one, we are pulling the token off the context why is there a need for us to click the authorize button every day  Did anyone face this issue ? Any workarounds for this one.

My Requirement is I need to fitch data from a view where all the columns are unique except 2 column data i need to show the unique data in the records page just filtering these two records. can you please help me with this using a!queryentity()

Hello! I'm wanting to create a Synced Record Type for Salesforce objects for use within Appian. I successfully created the connected system for Salesforce, but when I go to create an Integration using the Salesforce Connected System, I'm unable to get pagination to work correctly. The SOQL response shows the "nextRecordsUrl" and the first batch of records. However, after playing with the expression rule for the Record Type, I'm still unable to get the Integration to know that it should query the "nextRecordsUrl" instead of attempting the same SOQL query. Essentially, I can't get pagination to work. Has anybody had success building out a Synced Record Type for Salesforce records without building out a custom HTTP Integration, but instead relying on the standard Connected System? Any help is appreciated!

Node Instance Error OccurredExport SQL Request To Excel Admin The following error was raised by the Export to Excel function: Specified named range 'Total' does not exist in the current workbook. Dec 22, 2025 9:41 AM Is anyone can assist, I changed the file name or excel file template and folder name change. after that getting the same issue with smart service Problem:  An error occurred in executing an Activity Class. Details:  The following error was raised by the Export to Excel function: Specified named range 'Total' does not exist in the current workbook. Recommended Action:  Examine the activity class to correct the error and then resume. Priority of this problem: High Priority

Hello — I would like advice on how to aggregate some data. ## Purpose- The goal is to trace daily changes in workers' working hours. ## Data structure- Each record represents a user's single work session and contains: - **RECORD_ID**, **USER**, **START_TIME**, **END_TIME**, **DURATION**- A user can have multiple sessions in one day, so one user can have multiple records for the same calendar day. Example:RECORD_ID | USER | START_TIME | END_TIME | DURATION1 | A | 12/23 10:00 | 12/23 12:00 | 1202 | A | 12/23 13:00 | 12/23 15:00 | 1203 | A | 12/24 10:00 | 12/24 11:00 | 604 | B | 12/23 10:00 | 12/23 12:00 | 1205 | B | 12/23 13:00 | 12/23 15:00 | 1206 | B | 12/24 10:00 | 12/23 12:00 | 1207 | B | 12/24 13:00 | 12/23 15:00 | 1208 | B | 12/24 16:00 | 12/23 17:00 | 60``` ## Required aggregation steps- First, aggregate these records by **user + work date** to compute each user’s total working time per day.- Then, calculate the **average daily working time per organizational u

Hi , have 6 integrations in the process model flow , it should be run in sequence manner and each integration is depending on previous integration call, now i have to complete the process model within 5 see , could you please let me best approach to follow ? thanks!

In my application, there are three columns for each user in the default Group; Name, Details, and Member Type. I would like to add additional fields for users so that we can separate them based on their roles and grant them different access.  Is there a way to add additional fields to the user groups? I tried to do some research into this and it seems like Group Types are the way to go but I am unable to figure out how to set it up. Specifically, I want to add something like these fields to the user table.  <Name>   <Region>  <Country>  <Department>  Do I create a Group Type for each new column? How do I add the values for each field so it can be a drop down list? Thanks.

Hi, I have a read-only grid with the selectable parameter enabled. Lets say as a user i select 2 or 3 rows in a grid and then when i try to filter the data using the user filter, is there a way to unselect the existing rows ?

In my application, I am trying to associate the same document with different Activity IDs. However, when I go to the documents section, I get this error, which seems to indicate that it is impossible to manage the same document ID on different activities. However, the relationship is 1 document, many activities. Does anyone know how to solve this problem?

I would like to implement a function in Appian that retrieves a list of actions associated with a record. I have been testing multiple approaches and configurations in an attempt to achieve this functionality; however, none of them have produced the expected results so far. Despite extensive testing and exploration of different alternatives, I have not yet been able to successfully obtain the desired list of record actions.

Hi, I made a clumsy error along the way and now I want to reset my workspace and delete everything to date. Is there a way to do this? Thanks Haleigh

Hi Team, I am using a record-based grid to display data. But unless search button is clicked, data does not get loaded to grid. Thanks, Kavya

Hi Everyone, Thanks in advance, I have list which is having list of dates {1/1/2026; 2/2/2026; 12/31/2025; 11/24/2025}.I needs to identify the least date and Maximum date from the list. Regards Divya K

The Appian World Live Build Challenge is back for its 5th year! This crowd favorite showcases developer skill and speed using the Appian Platform. This year, six developers will compete for a $15,000 prize and eternal glory. Selected participants will receive a free conference pass and hotel stay.  Think you have what it takes? Apply by February 21st.

Hi everyone, We are planning to connect Appian to an on-premises SQL Server environment. Due to security and network restrictions, Appian developers do not have direct access to the on-premises SQL Server. As a result, we are unable to directly inspect table structures or view data stored in the database during development. To support smoother development, investigation, and testing activities, we are exploring whether it is possible to view and reference on-premises SQL Server data from Appian. Specifically, we would like to understand the following: Is it possible to synchronize or replicate data from an on-premises SQL Server to the Appian Cloud Database? If so, is there a way to browse and inspect table data using a GUI similar to the Appian Cloud Database? Thank you in advance for your help. Hatsune

I have deployed a new package which contains a expression rule doing some calculation, into Production Environment and its running Live ,Somehow its failing in production, and there are around 300 instances which got failed due to error of this Expression Rule which called in a Script task, May i know how to fix this Error,Can someone suggest us some possible and most efficient Ways to do this. Thanks in Advance.

I am new to Appian and I'm creating a form interface to save data to the database. I've gone through several of the tutorials and I created an Interface and a Process Model that will save data to the database. However, it only works when I launch it from the Process Model. How do I launch it from the Interface by clicking on the Submit button?  I want to click Submit after filling out the Interface and have it fire up the process model to save to the database. 

i am Doing the Application Building Blocks Course and i cant finish the Hands on Practice because the PDF "cannot be viewed in this browser" and when i click on it when i try with different Browsers it also not work (chrome, opera, firefox) same issueI think it happens with all those pdfs but this time it was with Step 4

I need to call a stored procedure that takes a lot to complete (around 6min) and it does not return anything. It could be called in a async way that it would not matter.  Having said that, can I just use the timeout field to give it a short value (one second) being sure that in the DB, the SP will complete even if my Process model completes?Cheers

Hello Team, Can you please help me out to findout this server.conf.notifications file in Appian (25.1). Regards, Srini