Discussion Categories

Hi Community, i have a requirement to create a html template using expression rule to create a table. i am able to create a table but i am unable to generate borders for each row and headers. please prefer below code snippet. TIA [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] 

Hi EveryoneI’m using a custom picker as a user picker to select users based on custom properties. However, I’ve run into an issue:       •     If I type something in the picker but then erase it without selecting a suggestion, the field ends up holding a garbage or null value.       •     This behavior causes unexpected results in my form/data submission. Has anyone faced a similar issue? If so, what’s the best way to handle it — for example, ensuring the field resets properly or validating before submission?

Hi team We've just set up an application that uses the Send E-Mail Smart Service. Our Health Check Report has this to say: "SAL Approve Installation (0002edb5-ade8-8000-43ed-7f0000014e7a) Node: ""Send To user"" references a smart service that is no longer recommended for use (Send E-Mail). Please remap this node in the process model to use the latest version." I can find nothing in Appian documentation saying Send E-Mail is no longer recommended for use I can find no details in Appian documentation of any Smart Service that might replace this I can't seem to find a thread in this Community that addresses this issue Can anyone assist me to resolve this?Thanks and blessings Stephen

Hi Community, I am encountering a strange issue with Record Chat. Occasionally, I receive unintended or unusual responses. The behavior is inconsistent—sometimes it occurs after a few messages, other times after just one or two, and occasionally even with the very first message. I’m unsure whether this is a bug or a configuration issue. One example, shown in the attached image, is that the conversation output includes entries formatted as 'H:' and 'A:', resembling a question and answer dialogue, which I did not configure or expect. My setup appears straightforward: I’m using fields from both the primary record and the required related record fields, passing the correct identifier. I also attempted to adjust the behavior using the additionalInstructions parameter, but this did not resolve the issue. Has anyone else experienced this problem or have any insights into what might be causing it? Thank you in advance!

Trying to move the logic from query entity connecting to VW to Proc with input parameter and was able to create a Procedure on Maria DB . Challenge is trying to recreate includes operator logic for an column on proc using LIKE operator but not able to achieve it 100% currently got to an extend as below , there are multiple input paramter on WHERE clause and one below AND ( input_parameter IS NULL OR input_parameter = '' OR REPLACE (LOWER(COLUMN_NAME),' ' , '')  LIKE REPLACE (LOWER(input_parameter),' ' , '') ) additional checks made From Appian while passing the input parameter have also converted the input parameter to lower case and have appended %% before and after the string Input parameter definition have set charset as per the column definition. Still issue is value with alphanumeric value ending with number fails Ex: %abc1234_def4%. No result (actual record exists), but %abc1234_def% gives results 

Hi Community, I was exploring a scenario, where when user loads records summary page, I want write some data into Records /enitty. I tried to create a web API which writes records, an integration to connect the web API, call that integration from local variable inside the interface. But this doesn't seem to be working. When I tested web api from integration object , I am getting below details as response but its not writing the data    Any work around or other approach to achieve this? Thanks in advance

hmacsha256bytehashbase64key - We are using this funciton in appian onpremise and now we are deploying to cloud . In cloud this function is not supporting .Is there any alternative function to use instead of hmacsha256bytehashbase64key ?Thanks

I have created a Robotic task, and it is throwing error when I try to execute it. The error is "Problem when launching executions: ROBOT_NOT_ALLOWED_NOW". The robot is online and it as also added to the Robot Pool. Any reason we get this error?

Hi Team, I need Last working Day date of every month as i need to start process for every month Last working day. Let's say if i take Aug-2025 Month & its month end date is 31st & falls on Sunday but in my case process should trigger on 29th Aug which is a last working day. I need dynamic approach so that it iwll pick last working date & start process. prompt response really appreciated,Thanks

Hi, I am trying to generate excel document by using the a!exportDataStoreEntityToCsv(). Below is my code snippet: load( local!exportDocId, local!errorMessage, { if( isnull(local!exportDocId), a!linkField( labelPosition: "COLLAPSED", links:a!dynamicLink( Label: "Export Inactive Users Details to Excel", saveinto:{ a!exportDataStoreEntityToCsv( entity: cons!VW_EPMT_EWR, selection: a!querySelection( columns:{ a!queryColumn( field: "ewr_number" ), a!queryColumn( field: "name" ), a!queryColumn( field: "active" ) } ), documentName: "EWR Grid Record Data", saveInFolder: cons!EWR_FOLDER, onSuccess: a!save( local!exportDocId, fv!newDocument ), onError: a!save( local!errorMessage, "Error in Exporting File" ) ) } ) ), {} ), if( not(isnull(local!exportDocId)), a!linkField( links:a!documentDownloadLink( Label:"Download Excel File", document: local!exportDocId ) ), a!textField( value:local!errorMessage, readonly:true ) )

Hi all! New to Appian, and I am stuck on figuring out how to correct configure a dependent dropdown.  The first dropdown field is called "Plant," and its fields consist of plantId, value, & description. The second dropdown field is called "Storage Location," and its fields consist of werks, name1, & land1. Both queries have one similar field, which is "value" and "werks," but I need to call back "plantid." How would I do that? Thanks! 

Hello Everyone I want to achieve POPUP/Dialog Box in Interface without using Process model is there any way to achieve this within interface without using record action or process model ?  for now i am only using a!dynamicLink function for  show/hide option but for many USE Cases , POP UP would be the best option!  Thanks , Raj Thakor

Hi, I am trying to import a CSV file, but I receive this error "java.lang.IllegalStateException: (line 76) invalid char between encapsulated token and delimiter". The CSV file has an open quotation mark but no closing quotation mark, and my separator is ‘##’. How can I get around this problem? Is it possible to insert some escape characters?

Hi Everyone [emoticon:c4563cd7d5574777a71c318021cbbcc8], I have a sync start process(Process Id is used to select the Process Model) in my Parent Process.Now I am not able to save the Output. PVs are not shown in pv!.

The basic user who has viewer permission can't initiate the send email node? Will it get errored at send email node?

Hello everyone, Is there a method to programmatically reset all column sorting/filters simultaneously within the GridPlus component? For instance, consider a grid with five columns where a user applies sorting and filtering on three separate columns. Currently, the user must clear each column’s sorting/filtering individually to restore the grid to its initial state. My idea is to reset all sorting and filtering criteria with one button action.Thanks!

Appian delivers process automation powered by enterprise AI, empowering organizations to design, automate, and optimize business processes through a unified platform for process orchestration, automation, and intelligence. This latest release, 25.3, introduces significant advancements and exciting features across the platform, including highlights on AI Smart Search, AI for self-managed environments, High-throughput data fabric, Generalized async loading for SAIL UIs.Join our team of Appian experts as they delve into the key highlights of this release. Tune in to see Appian 25.3 in action and engage with the experts by asking your questions.Turn on notifications to make sure you don't miss it!

We are seeing a strange issue in which write to record is not working properly. If we check the process variable value, it is successfully updated, but when we look at the database, the latest data is not being updated, no expression error is generated, and this is an intermittent issue. As per this thread we updated to latest version https://community.appian.com/discussions/f/data/39426/data-fabric---write-to-child-records-via-relationship, still we see same issue. Anyone knows the reason?

I am running some processing in parallel that includes api calls.The result with then populate an interface attended by a user. I have tried both a!forEach and MNI but for both the performance is not as expected. By looking at the performance tab in the expression rule, it is clear that the items in the array are running sequentially and not in parallel, as the total time for the expression rule is the sum of every iteration. As a test I tried to put only a GET api call in the foreach loop and the result is the same. This is not what I was expecting, is there anything that can be done to enforce the threads to run in parallel to optimize the performance?

Record Type details not showing after  click on View Record List

The description tooltip is not visible when hovering on the Record action icon. Although I was aware it was there, now unable to see this tooltip on icon.

Hi FolksJust sharing the experience!When writing to child record via write record, there was no error on process model, but it was still not writing to DB. Then we realized the issue was because of two reason which we did not pay attention 1. We need to make sure the record object is updated o latest version means below pop should not be visible 2. On the model switch to latest version of smart service.

Hi All, Below is one of the issue we are facing it an intermittent issue. While Executing Write Record Smart Service for the Process Models we are getting the below error:- Unable to write to or delete from the source due to a data integrity violation.Error Details: Column 'TaskStatus' cannot be null. The TaskStatus is set to NotNull in Database . We have always value set or Update in taskStatus Field before Executing the Write Record Service Node. Below is the Screenshot attached. attaching the logs screenshot as well for the issue:-

Hi all,  Is there any way that we can implement a copilot that will answer about our record data? For ex: it should be like a chat bot and it should be in the record summary page, if we ask about the details of the record summary, it should provide the answer. Can anyone please help me in implementing this ?Thanks in advance!!

Hi everyone. I need to step by step guide line . As my requiremnet (Connect  from Appian to AWS RDS Using Private Link)I checked this references link :https://docs.appian.com/suite/help/23.2/Access_Customer_VPC_using_AWS_PrivateLink.html I cannot understand below of point (check below of screenshot)>Appian will create a VPC endpoint to connect to the VPC endpoint service you have provided. How to create vpc endpoint in appian enviromnent?