Discussion Categories

Hi ,  I am using a default Export functionality of Record in an Interface , But I am facing an issue that while exporting some data is not available . I am having a relationship in my record and some other customs fields .  Please let me know why this is happening.  Thanks in Advance

We are trying to enter a decimal value into a!floatingPointField(), where the datatype is Number(Decimal) and applying rounddown(value,2) to limit the decimal values to 2 places based on the requirement we recieved. This is being done in editable grids. But it seems that random numbers keep appearing after the decimal for the numbers. (47.3 shows as 47.3000000004, etc.). This case is specifically occurring for only certain numbers in certains fields, such as 47.300909 shows as 47.3000000004 only in 1 particular field for the a specific number starting with 47.30x.. If we enter 47.32x, it will correctly round down to 47.32. We tried using round(), roundup(), rounddown(), floor() functions also, but it keeps occurring atleast in 1 row in any one of our grids. What might be the reason behind it and is there any fix??

I created an interface via an array of components, i.e.  { rule!header_component, a!gridField(  ... ) rule!footer_component } The grid is using a recordType for it's data, I enabled the export to excel button to the grid but when I click the button I get the error in the csv file: " Expression evaluation error: could not find variable 'model!parseModel' ". I have no idea what this variable is or where it could be from or what it does. I checked within the record list view, and that exports perfectly fine, it just doesn't work in the grid Interface I have.

Hi All,  Please advise how do I write a Query rule to fetch case Id and folder id from database ? Below is the query rule I've written to fetch the case Ids and folder Ids from database. How do I map this to a process Model? a!queryEntity_22r2( entity: cons!ABC_CASES, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1,) ), selection: a!querySelection( columns: { a!queryColumn(field: "caseId"),a!queryColumn(field: "folderId") } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "caseId", operator: "=", value: ri!abc_cases.caseId, applyWhen: not( rule!APN_isBlank(ri!abc_cases.caseId) ) ), ) } ) ))

Hi, We are currently using the a!startProcess function within a Web API to initiate a process when triggered by an external API call. Our goal is to return a response to the external system using the onSuccess parameter with fv!processInfo. However, as of Appian version 24.4, we understand that isSynchronous must be set to true in order to receive fv!processInfo through the onSuccess parameter. According to the documentation, when isSynchronous is true, the maximum wait time for the process to complete is 30 seconds. 1. Is there any way to extend this 30-second timeout to 60 seconds or more? 2. If increasing the timeout is not possible, what is Appians recommended approach for use cases where more than 30 seconds is required to generate a response to the external caller? 3. What Appian Version is recommended for such situation that doesn't get affected by the time out for a!startProcess function?

Hi All, I have a query rule as below and when passing to the process model, output is coming weird as Data: object,object. Please help!! Expression rule output - [startIndex=1, batchSize=1, sort=[field=updatedDateTime, ascending=false], totalCount=-1, data=[caseId:123,IDNumber:122567,caseStatus:On-Hold/Request for Info,clientName:user155678,folderId:1267888], identifiers=322] When same rule passed and saved to pv of type datasubset in process Model: [startIndex=1, batchSize=1, sort=[field=updatedDateTime, ascending=False], totalCount=-1, data=[object Object], identifiers=322]

Hello,In the scenario below, I understood the reply, but could you explain me how to implement an "Event Subprocess" please ?I don't see any simple option or such smart service in the process modeler palette. And in the "subprocess" service I don't see how it can be triggered by an event.Do I need a Rule or Timer event, or "Receive Message" to activate the supProcess?If you have a tutorial on internet, it would be perfect :-)Ms. Durant is working on an Appian application to track customer orders for a retail company. The application needs to trigger a series of tasks to validate order details, check inventory, and process payments. However, if the payment fails, the task flow should automatically halt and notify the customer service team to follow up. Additionally, the process must be able to send notifications to the customer about their order status at each stage. What is the best way for Ms.

Hi,  I'm trying to schedule a process using start node. Below is the screen shot. If I use pp!timezone I'm getting below. Problem: An error has occurred in evaluation of an expression for a Start Event. Details: ERROR:EVAL:@reason=Domain pp is valid only in execution Recommended Action: Examine and correct the expressions on the Start Event's Event Properties. If I'm using pm!timezone I'm getting a problem. The clients are at US and I'm working from India. If schedule 1 AM it is not executing correctly. I want to schedule a process at 1 AM at US time zone. How to schedule it. Please suggest.

is there any direct way to change the background color to white or any light color as chart labels are invisible with Black back ground in the download image( default capability) of charts.

Hello,In the scenario below, I understood that B/ was the good reply, but could you explain me how to implement an "Event Subprocess" please ?I don't see any simple option or such smart service in the process modeler palette. And in the "subprocess" service I don't see how it can be triggered by an event.Do I need a Rule or Timer event, or "Receive Message" to activate the supProcess?If you have a tutorial on internet, it would be perfect :-)(Scenario-based). Ms. Taylor is working on an Appian application to track customer orders for a retail company. The application needs to trigger a series of tasks to validate order details, check inventory, and process payments. However, if the payment fails, the task flow should automatically halt and notify the customer service team to follow up. Additionally, the process must be able to send notifications to the customer about their order status at each stag

Whenever we click “Generate Record Actions” on a Record Type an error is displayed to user like below, this issue seems to have a higher changes of occurring for record types that contains data/rows in database. and tomcat-stdOut.log spits out  2025-05-26 19:14:35,956 [http-nio-8080-exec-22063] ERROR com.appiancorp.type.handlers.RecordType2Handler - Failed to find uuid attribute with namespace [Namespace: prefix "a" is mapped to URI "http://www.appian.com/ae/types/2009"] + in the XML element 2025-05-26 19:14:36,037 [http-nio-8080-exec-22063] ERROR com.appiancorp.type.handlers.RecordType2Handler - Failed to find uuid attribute with namespace [Namespace: prefix "a" is mapped to URI "http://www.appian.com/ae/types/2009"] + in the XML element 2025-05-26 19:14:36,225 [http-nio-8080-exec-22063] ERROR com.appiancorp.type.handlers.RecordType2Handler - Failed to find uuid attribute with namespace [Namespace: prefix "a" is mapped to URI "http://www.appian.com/ae/type

I am able to add a new value to a  time field successfully. But when I am trying to update the same row, the update is happening in the backend, but not reflected in the UI.

I have a portal (yes a real portal) where parishes set their preferences for a speaker for Mission Co-Op Mission Sunday. The interface has a dropdown where they select the parish they want to set preferences and sets a local variable, slectedParish.  Once the parish is selected, I load a local variable, selectedParishProfile.  local!selectedParishProfile: if( a!isNotNullOrEmpty(local!selectedParish), rule!PMSO_getParishProfilebyParishID(local!selectedParish), null ), Now, the parish may or may not have an existing profile. So the expression rule either returns the profile or null if one does not exist. In the interface, I have a radio button field.   a!radioButtonField( choiceLabels: { "Yes", "No" }, choiceValues: { true, false }, label: "Can the Parish Provide Lodging?", labelPosition: "ABOVE", value: local!selectedParishProfile[PMSO Parish Profile.fields.parishLodgingType'], saveInto: local!selectedParishProfile[PMSO Parish P

a!recordActionField( actions: { a!recordActionItem( action: 'action_1', identifier: ri!identifier ), a!recordActionItem( action: 'action_2', identifier: ri!identifier ), /* this last one should be the primary */ a!recordActionItem( action: 'action_3', identifier: ri!identifier ) }, style: "TOOLBAR_PRIMARY", display: "LABEL_AND_ICON", align: "END" ) I have the following code above with the following style "TOOLBAR_PRIMARY". I would like to be able to set which action is the primary one. I haven't seen such option. It always applies the style to the first one one the left. What if I want the one on the middle to be the primary action? Or the last one on the right to be the primary? I appreciate any hints on this since then. 

a!localVariables( local!data:ri!asr_Requests, local!rawEmails: ri!asr_Requests.emailAddresses, local!integrationResult, local!isintegrationSuccess, local!individualEmails: reject( a!isNullOrEmpty(_), a!forEach( items: split(local!rawEmails, char(10)), expression: trim(fv!item) ) ), local!invalidEmails: reject( a!isNullOrEmpty(_), a!forEach( items: local!individualEmails, expression: if( regexmatch( pattern: "^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,}$", searchString: fv!item, regexFlags: "si" ), null, fv!item ) ) ), /*local!formattedEmailString: joinarray(local!individualEmails, ","),*/ local!formattedEmailString: a!toJson( { emails: joinarray(local!individualEmails, ",") } ), local!validationMessage: if( a!isNotNullOrEmpty(local!invalidEmails), "Emails must be valid and each on a new line.", {} ), a!formLayout(

Out of 3 environments (dev, test and prod), prod is giving wrong output to a default datetime conversion. Attached screenshots.  How to resolve this? Does it depend on some settings?Dev environment - First rule input is converted to GMT-4:00 Prod Environment - First rule input is converted to GMT-5:00 Created and deployed the same rule across environments, just to verify that I am not doing anything wrong. Appian Version 25.1Hosting: Cloud

Hello, I’m working on a bidirectional integration between Appian and an external system via a middleware gateway. In this setup, we often encounter two categories of errors: Technical issues Data issues Errors series (500 and 400) [emoticon:71aee13fb1eb4feea8d56f3f0189f580]My question: What are the best practices for functionally handling these types of errors on the Appian side? Specifically: Should we simply display messages to end users via pop-ups or alert banners? Are there recommended design patterns or built-in Appian features we should consider (such as retry logic, logging strategies, fallback mechanisms, or dynamic UI error messages)? Any advice for differentiating user-facing errors from those logged for admin troubleshooting? Thanks in advance for your insights!

Hi, I have a local variable with 2 items . I need to add each element in the array with the corresponding index and display the total . Eg {1,2,3} +{1,2,3} = {2,4,6} But in my case I can't apply the addition directly . It should be in a loop. I even tried using merge function but it is not working.. . How to achieve this. The below output is present inside a local variable (local!final).I need to add {0+2,36+82,2+8} and form a single array.

Hi, We are trying to integrate an application with DOCUMENTUM/CMIS document management system. The APIs used do not work for large documents due to the 5MB input/output size limitation in Appian's Integration objects. We would like to know if there is any way to integrate with this document management system, such as a marketplace app, plugin, or other, from Appian, to work around the size limitation. Does anyone have an idea? Thanks

I have an action that opens in a Medium Dialog Box Size and would like to know if it's possible to automatically trigger another action in a Small Dialog Box once the initial action is completed. Is there a way to dynamically change the Dialog Box Size during process model execution? Alternatively, can an action with a Small Dialog Box be automatically called from within a Medium Dialog Box upon completion? It's important for the second dialog to remain optional, giving users the ability to cancel it with the "X" icon. I appreciate any insights or suggestions on achieving this functionality. Thank you in advance for any insights!

I have an editable grid where I can validate if the grid contains any duplicates. I m able to write the validate message but I need to get the index or highlight the row where duplicates actually exists. 

Hi team,There is one requirement where I have one record for which I have one summary view. In the summary view, I am maintaining 3 tabs: Request Details, Country List, and Audit History. Here, I am maintaining a site with 2 tabs. In Tab 1, I want to show a grid, and upon clicking on the Request ID, it will open the summary page. In this tab, I want to show the Audit History section. However, if I click on a request in the grid in Tab 2, I want to show only the Request Details and Country List. Is this possible in Appian?

Hi Community, I’m working on a requirement where I need to create dynamic columns in read-only grid in Appian and would appreciate some guidance. Problem Statement: I have a database table with the following columns: ActivityName ForecastDate (Date field) ForecastAmount (Decimal) Requirement: I want to display a grid where: Each row represents an ActivityName. Columns dynamically represent Month-Year values (like Jan-2025, Feb-2025, etc.), based on the date range selected from interface. Each cell should show the corresponding ForecastAmount for that activity and month, if available. So the table should “pivot” the data such that ForecastDate drives the column structure dynamically. Note: Any Date range between 2020 to 2030 can be selected and searched. Questions: What’s the best approach to dynamically generate these month-year columns in an Appian interface? Should I preprocess the data in an expression rule or CDT before pas

Hi Team, We have configured the required access and security for a recordtype to be displayed in the process HQ, but for some reasons it is not getting displayed, the left-pane is empty as in the screen shot below. Requesting assistance on this. Thanks. we are not able to see the Process HQ enabled although we have added ourselves to the Process HQ, Data Governors and Report Creators group.  Enabled the record type, to be visible in the Process HQ workspace. But still not able to see. This is a self-managed appian env, the version is 25.1. Please advise if we are missing anything to be configured or setup.

I am using Import CSV to Database v6 to import CSV file to a database. I have a field in the table that is not part of the CSV. I tried to configure the additional column and additional value thinking that will store the value into the table but it didn't save the value in the table. Any thoughts how to populate the field in the table that is not part of the CSV using this plugin? For instance, my table has 5 columns, my csv has 4 columns and I want to store a value in the 5th column of the table (e.g. hardcoded value). Thank you.