Discussion Categories

Hi All,We currently have 3 servers in our production environment hosted in appian cloud. Server 1 is having memory used % of 69%, server 2 is having around 59% and server 3 is having around 60%. Any reason why the memory usage is not symmetrical, I mean why they are not much closer to each other(server 2 and 3 are close but 1 is little high). Any idea how these are handled? Any suggestions would be helpful.

Hi All, I am trying to display the table header on repeat when there is page break inside a table when using the plugin html to pdf. I have tried most of the options, has someone faced trouble with this or implemented the same? Attaching the html code   body{ font-size:14px; } img { max-width: 100% !important; max-height: 100% !important; } thead { display: table-header-group } tfoot { display: table-row-group } tr { page-break-inside: avoid } One One Row 1 Column 1 Row 1 Column 2 Row 2 Column 1 Row 2 Column 2 Row 3 Column 1 Row 3 Column 2 Row 4 Column 1 Row 4 Column 2 Row 5 Column 1 Row 5 Column 2 The generated pdf is as follows: 

Hello,We are trying to create an Appian RPA bot which creates and configures a process model in an appian application. We are able create one, but facing issues while configuring the process model. As the bot needs to drag the smart services from the palette and drop between start node and end node, we are unable to find the X co-ordinate and Y co-ordinate in the Drag RPA service. Also the bot is unable to identify the selectors such as XPath, CSS, or ID in the Interact with Element RPA Service.So is there any alternate way to achieve this. Suggestions would be helpful.Thanks In advanceRohith

=a!formLayout(   label: "Hiring Request Form",   contents: {          /* Section: Request Information */     a!sectionLayout(       label: "Request Information",       contents: {         a!radioButtonField(           label: "Are you making this hiring request on behalf of yourself or someone else?",           choiceLabels: {"Myself", "For Someone Else"},           choiceValues: {"Myself", "For Someone Else"},           value: ri!requestFor,           saveInto: ri!requestFor         ),         a!radioButtonField(           label: "What type of hire do you need?",           choiceLabels: {"Non-Emplo

Hi Team, I was using the below rule and trying to fetch the data with the condition that selecting one ID from a grid should get one CaseID: 50324 and if selecting more than one ID should get CaseID: Multiple ID. can anyone please help me on this  a!localVariables( local!data: a!queryEntity( entity: cons!BEMS_ENTITY_PAYABLE_CASE_VIEW, query: a!query( /*selection: a!querySelection(a!queryColumn(field: "clientName")),*/ aggregation: a!queryAggregation( a!queryAggregationColumn(field: "clientName", isGrouping: true) ), filter: a!queryFilter( field: "caseId", operator: "in", value: a!flatten({ ri!caseIds }) ), pagingInfo: rule!TCO_defaultPagingInfo() ) ), { if( local!data.totalCount > 0, if( local!data.totalCount = 1, left( "Standard Template - " & proper( joinarray(local!data.data.clientName, " & ") ) & " - " & "CaseId:" & joinarray(ri!caseIds, ", "), 80 ), if( local!data

Hello, I have added a security expression in record-level security to handle complex filter criteria that include the logged-in user as one of the filters. I am exporting the record information using related actions and a scheduled job. Export from the related action is fetching the expected output; however, export using the scheduled job is not returning the correct results because the record-level security condition is failing due to the logged-in user check. To get the correct results, do I need to explicitly pass the filters defined in record-level security when querying the record from the scheduled job? Or is there a better way to achieve the same results? Please advise. 

Hi Team, I was unable to get the data with the below condition that passing one ID should get CaseID: 1234 and passing more than one than one ID should get CaseID: Multiple ID a!localVariables( local!data: a!queryEntity( entity: cons!BEMS_ENTITY_PAYABLE_CASE_VIEW, query: a!query( aggregation: a!queryAggregation( a!queryAggregationColumn(field: "clientName", isGrouping: true) ), filter: a!queryFilter( field: "caseId", operator: "in", value: a!flatten({ ri!caseIds }) ), pagingInfo: rule!TCO_defaultPagingInfo() ) ), { if( local!data.totalCount > 0, if( local!data.totalCount = 1, left( "Standard Template - " & proper( joinarray(local!data.data.clientName, " & ") ) & " - " & "CaseId:" & joinarray(ri!caseIds, ", "), 80 ), if( local!data.totalCount >= 2, left( "Standard Template - " & proper( joinarray(local!data.data.clientName, " & ") ) & " - "

We have test like below " Need modification. Remove last line " In this example, we just need to remove next line char after remove last line string. We still need to keep next line after Need modification. We are generating some documents and formatting should not change if users has entered next line in between the lines but only last line should be removed as soon as Users entered Save. trim will not work here as it will remove from all the text

Hi Team, I am unable to download the Appian 24.4.  (FORUM>SUPPORT>DOWNLOADS > PLATFORM > LOW-CODE PLATFORM) It is throwing below error. Is there any alternate way to download. Regards Janardan Mahto

Hello i m follow this guide https://academy.appian.com/#/online-course-player/270dc9fc-ad42-4d30-94db-ebfcc2f39331   But on Create the Part Record Type in step 8 I have this error when I click on new relationship.   HTTP Code: 500 APNX-1-4198-000 Error Evaluating UI Expression Expression evaluation error [evaluation ID = KP48I] : Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!getInterchangeableTypes [line 27]: The data source [_a-0000eada-3d9b-8000-9ba4-011c48011c48_12846-w1857] was not found   Can you help me please? Im new in appian.       Best regards!

Hi, I want to create a Kanban board in Appian. I tried using the Draggable component, but it seems to have limitations in adding more information. Here's the reference I was looking at: see attachmentAppian Marketplace Documentation Is there an alternative approach or a workaround to achieve this? Thanks!

Hi, I have a user input task assigned to  Approvers group (which has Manager access). The process model security also has Approvers(group) - Manager access. I want to control the reassignment by users of this group to do within the group of Approvers but not from all users and groups. I tried the below setting, but still I see "All users and groups" option shown. 

I have a process model where I call several apis and write result to table, the process model is long so I didn't chain it. But user want to see the values updated by the process model when the process is completed, without refresh. Or at least tell user when to refresh, meaning we have to make a flag indicating the whole process is completed. How can I do that? I tried to write a flag at the end of each sub-process and make it a refresh variable in my interface, hoping it'll refresh to its latest value. But it didn't work

Hey Team - I am new to Appian and working with internal teams to setup right Roles and responsibilities around this platform. Where should I start with to understand about best practices around Roles and permissions for Product, Business Analysts and Devs etc.

It shows the above error message when I try to create a site showing vehicles as the practice book shows in the community edition.

In the a!eventHistoryListField, I want to display the date and time in this format: 01/Feb/2025 19:25 GMT+00:00. How can I change the format of the timestamp parameter? It supports date-time, date, and date-time-zone format values, so I can't use the cast text function.

I am using process model to create simple application to use accountid column from one table to filter other table. The accountid list is passed as PV but I am not able to pass the PV in SQL query and its not accessible even after creating a input variable.  SELECT Account_id,Name,'Status code','C&D' FROM Account_table where Account_id in (pv!bkk_act_list.Account_id)

Hi Community I have a process model that is started from an interface. A node in process model throws error 'rank (Data Outputs)' for an instance but when tried with similar inputs the node runs correctly after a minute. Can you please suggest on this.

Hello everyoneI am facing the following issue: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 3]: No enum constant com.appiancorp.core.expr.portable.cdt.LogicalOperator.<>   And after some triage, I am not able to find the route cause for this issue. Can you give me some tips?  Thanks in advance Edit: a!localVariables( local!paging, a!gridField( label: "Envelope List", labelPosition: "COLLAPSED", emptyGridMessage: "No Envelopes", data: rule!VCP_qr_getEnvelopeLookupView(filters: ri!filters), columns: { a!gridColumn( label: "Envelope Name", value: if( ri!isReportMode, a!linkField( links: a!recordLink( label: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{905ee3c6-5418-44bb-b35d-29317c1ed879}name'], recordType: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope', identifier: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e0428291

Hello everyoneI am facing the following issue: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 3]: No enum constant com.appiancorp.core.expr.portable.cdt.LogicalOperator.<>   And after some triage, I am not able to find the route cause for this issue. Can you give me some tips?  Thanks in advance Edit: a!localVariables( local!paging, a!gridField( label: "Envelope List", labelPosition: "COLLAPSED", emptyGridMessage: "No Envelopes", data: rule!VCP_qr_getEnvelopeLookupView(filters: ri!filters), columns: { a!gridColumn( label: "Envelope Name", value: if( ri!isReportMode, a!linkField( links: a!recordLink( label: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope.fields.{905ee3c6-5418-44bb-b35d-29317c1ed879}name'], recordType: 'recordType!{b010e97a-6864-4483-a8a3-f88e04282917}VCP Envelope', identifier: fv!row['recordType!{b010e97a-6864-4483-a8a3-f88e0428291

Hi Community, I have noticed strange and unexpected behavior of the Write Records Smart Service in the current version of Appian. I have a table with a primary key that is not automatically populated via auto-increment or a sequence; instead, the value is provided by the application. A sync-enabled record type is configured for this table. I am trying to create a process model that is responsible for cloning a record. The process model consists of three steps: Retrieving the data using queryRecordByIdentifier and storing it in a process variable (pv!record). Adjusting the attribute values of the process variable (pv!record), ensuring that certain attributes in the cloned record have different values, and assigning a new value to the PK field. Writing the record to the database using the Write Records Smart Service. While executing the process model, I encountered the error: The input "Records" cannot update a record's primary key value. The request to update t

I have two process variable bkk_act_id,filt_table. Both are record type of two different table with common Account_id. I want to use account list in the first table to filter the second table rows containg that Account_id. While this work if I use the record type directly, but when I try to do the same with process variable its throwing error for both the variable processing:  Expression evaluation error at function a!queryRecordType [line 11]: Could not cast from Tst_act_list to RecordType. Details: CastInvalid) (Data Outputs) a!localVariables( local!accountIds: index( a!queryRecordType( recordType: pv!bkk_act_id, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 5000) ).data, pv!bkk_act_id['recordType!{c1a6fae6-0413-4ce9-b777-4bf0906e36a2}Tst_act_list.fields.{50cfb814-61d1-4617-9005-25befed5abe7}accountId'], {} ), local!filteredData: a!queryRecordType( recordType: pv!filt_table, /* Table to filter */ filters: a!queryFilter( field: pv!filt_table['recordType!{73b2f9fb-792e-4

Hi all, I am trying to make a small robot that downloads an excel file from Appian and uses a macro template to apply formatting to the downloaded file.Using the Open excel workbook action on the downloaded file everything works. When I use the same action to open an xlsm file, that is, the file with the macro, I get this error which I attach.I thank in advance those who will help me solve the error.Best regards,Marco Pennacchia

I have a scenario where, if I click the "Reject" button, the comments field should be required and cannot be empty. If the "Approve" button is clicked, the comments field should be optional and be submitted. I have a ri!cancel input that changes to true when "Reject" is clicked and false when "Approve" is clicked. However, the validation isn't working as expected. I tried setting the "required" parameter to ri!cancel, but after clicking "Reject" and then "Approve," ri!cancel doesn't seem to change back to false, and still throws validation for approve button if comments is emptyCode for the interface comment field and buttons: a!textField( label: "Comments", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), value: ri!TR_Expense_Details.comments, saveInto: ri!TR_Expense_Details.comments, characterLimit: 250, showWhen: ri!TR_Expense_Details.hrApproval = true(),

My current phone number is getting off in few days so I need to change the number to a new one, but i'm unable to do that cause i can't find the option to do that. Anyone who knows about it ,do tell.