Discussion Categories

Is there a way to display the user input in different color instead of black inside the editable textField or paragraph while typing?

Hi!  We would like to connect to IBM MQ 9.0.5. In the market it used to be a plugin for this, but I can’t find it anymore. Isn’t it working anymore? I would like to check if it works with IBM MQ 9.0.5 since we have to use a new cipher only supported in the version or a newer one.    Furthermore, in the documentation it is mentioned the following: JMS configuration is not supported on Appian Cloud. If you need to integrate with JMS on your Appian Cloud site, you can achieve most JMS use cases via a plugin https://docs.appian.com/suite/help/21.4/Working_with_the_Java_Messaging_Service.html#see-also   ¿Which one could be the correct plugin to be used? Thanks to the community! 

Any thoughts on how we can handle this problem?Did anyone else faced similar issue and how did you handled it? Many times recently we have cases that get "stuck" are doing so because someone processes on them twice. There's three flavors of this: The same user opens the case on two different tabs/windows. They process the case on one and a few hours later process the case again because they found the second tab Two users open the case. User 1 processes and completes. User 2 then does the same a few minutes later [only seen twice] Two users hit get work within milliseconds of each other and got the same work object We're less concerned with option 3 because we've only seen it once. Options 1 and 2, though, are painful.  Could  we change those process models to prevent this issue: We want to include clear messaging to the user when they try and process the second time. Consider performance too.

There is a requirement where i have to insert nested CDT(one to many) data into table and then read in another process model. Parent CDT : policyDetails policynumber customerId actiontype nomineeDetails Child CDT= nomineeDetails { title: "Mr", forename: "abc", surname: "Test One", dateOfBirth: "01/01/2000", percentage: 80, relationship: "Brother", addressLine1: "Hall Road" } { title: "Mr",forename: "xyz",surname: "Test two",dateOfBirth: "01/01/2006",percentage: 50,relationship: "sister",addressLine1: "aaaaa", } My Approach :  Create two tables policyDetails & nomineeDetails with foreign key = policynumber Insert policy details into first tables without nomineedetails. Insert nominee details into second table using MNI in process model. Create 2 expression rules to read data from both tables and use it. Do you guys feel that there should be be

Hi, I have a database table called "Status" along with a CDT in Appian with the below list of values. Also, I have an employee table with statuskey reference along with a CDT and while adding an employee using employee - add interface, I am saving the status as "1" (default). Also employee table is having loggedInDate. statuskey status 1              Active 2              Inactive 3              Terminate Can someone suggest what need to be done if I have to implement below requirement. I have to mark the employee as “Terminate” if the employee is in inactive status for 30 days. I have to mark the employee as “Inactive” if the employee is in active status for 15 days but not logged in(By looking into loggedInDate.

Hi, when i edited one row data and submitted after that second row is not getting selected means after selecting first row the local variables selected row and selected row index has the value 1 after submitting it it was nullified when i am selecting the second row the local variables not taking value to edit. please find the below screenshot for the same and suggest on this. After selecting first row: After submitting first row and selecting second row:

Hi all, This is my uses case. I have a reference table with 2 columns (id(PK) and description)  with all the possible statuses: 1 - Ongoing; 2 - Completed, ..... I need to insert an entity case, that it has a FK to that statuses. For instance, idCase = 1, idStatus = 1. So my question is, what is the best approach to map the value (Ongoing, Completed, ...)  into my case CDT? My initial approach is to have a CONSTANT with the status values: "Ongoing", "Completed" and get the id by a query rule to the table status. Thanks in advance.

Hello Community: This probably a dumb question but here is my dilemma.  I have two tables 'Consolidated Product List' and 'Brand Owners' (fields: brandIdentifier, brandOwner).  The field 'brandIdentifier' in Brand Owner is the foreign-key in 'Consolidated Product List'. I am trying to populate a grid with brandOwner for each product in 'Consolidated Product List' but having a heck of time display the brandOwner.  Here are images of my query, my interface, and my debugging screens. Any help would be appreciated. Ma

In Appian RPA , there it is not showing Resource Tab. How to locate it ?

I am trying to save data using Rich Text Editor having longtext Data Type. But when I check the record type for the saved data, the full data is not showing up, only 40% data is showing up in record. What can be the possible reasons for it?

Hi, I am fileUploadField() to uploaded the document in a specific folder and saving the documentId in the database under one of the field/column. When I try to perform delete functionality against the database record, I am using "Delete from Data Store Entities" smart service. When I delete a database record, I would like to delete the corresponding document which is linked to the database record. How can I achieve this. Any advises please. Thanks.

Hi, is there a way to task record unsupported element in RPA.

how can i integrate outlook with appian. my use case is i want the emails from my outlook inbox to be in appin. where i can store it in db. almost tried all the connected system and plugins. kindly someone help me out.

Hi Folks, I need little help. I want to handle my outlook mailbox via Appian for incoming emails and for replies with & without attachments. Can someone suggest me the solution because I am unable to find the right connected system for Microsoft 365 & appian. Evenly there is no plugin option available for this. 

I have created a local variable that will fetch all the tasks from a process report. When there is a change in  the task,i.e. i have accepted or assigned or completed the task, or added a new task, it should automatically refresh the grid and show the change in it. How to do this process?

in the expression the time value shows in EDT, but the zone display as GMT+00:00. how can I change this ?

as i have written the following code .. but how to increase the index.. iif user clicks on add new .. new field of mobile number should get added..a!localVariables( local!add , local!npi, a!sideBySideLayout( items: { a!forEach(items: local!npi,expression: a!sideBySideItem( item: a!textField( label: "Mobile Number", labelPosition: "ABOVE", value: fv!item, saveInto: fv!item, validations: if( a!isNullOrEmpty(fv!item), {}, if( not( regexmatch("^([0-9]{" & 10 & "})$", fv!item) ), "Maximum " & 10 & " digits are allowed", "" ) ) )) ), a!sideBySideItem( item: a!linkField( label: "", links: { a!dynamicLink( label: "Add New", value: { local!npi + 1

Need to add multiple phone numbers.. on screen  and want to store in DB .. what could be the best approach

Hello All, I recently created a process report , wasn't able to access SAIL functions like tp!name, tp!assignees. I get a warning improperly scoped variable Was suspecting it to be because of the report type value. I don't remember which one I selected from the below screenshot ( Process model, Process, Task) Question: Where i can see the value of the report type for the already created report and is there a way to update it ?

Hello! I am getting an error message trying to run a test after updating to the latest version yesterday (March 6, 2023). We are using Appian 22.4, Chrome version 111. The test crashes on trying to open a Chrome window in which to run the automation. The issue seems to be with the chromedriver.exe. Can you please update the driver to the latest version? The error message reads as follows: setup with browser__EXCEPTION__:org.openqa.selenium.SessionNotCreatedException: Could not start a new session. Response code 500. Message: session not created: This version of ChromeDriver only supports Chrome version 107 Current browser version is 111.0.5563.65 with binary path C:\Program Files (x86)\Google\Chrome\Application\chrome.exe Host info: host: 'GS-5CD7525XJ9', ip: '192.168.1.251' Build info: version: '4.7.2', revision: '4d4020c3b7' System info: os.name: 'Windows 10', os.arch: 'x86', os.version: '10.0', java.version: '1.8.0_211'

Hi, It was identified during the Monthly Health check that few of the interfaces is hampering the Prod performance, I learned looking at the code that we have many calls to the different integration object in just single interface and each of them are taking a lot of time to get the response back. We did few analysis on Appian code as well, where large data set is not retrieved using large batch size, looping functions are used wherever it's necessary, not many dynamic components are used etc Finally it was drilled down that Integration call is the main culprit which is hampering the performance, we tried hard if we can exclude the integration call wherever iit's possible and just to call the integration only when it's necessary, after thinking through every call made is genuine and required. Before we go ahead with API services team for the solution can we check anything from Appian perspective before having a discussion with them, Thanks in advance, Nimisha.

Hi, my application has a number of record types with associated summary views. When the user enters they filter the records, make use of the paging, and then open the summary view. Unfortunately on closing the summary the filter and paging info is lost. Is there a generic way to maintain this state? 

Hi All, I have updated a CDT and table by adding a new column and deployed those changes to PROD. Now I have couple of active process instance of each request in PROD which is using old CDT version and I need to fill new column with a specific value as per customer request. Since we have " write to data store entity" smart service in active process instance, even though if i try to update backend table directly to update that specific column for each request, the column value changes to Null when process moves forward(Specifically after "Write to DS entity"). Please suggest an approach to resolve this issue. Thanks in advance

how should i approach from appian side ... to add mobile number dynamically .. For now i am having  blank text field where user can enter mobile number.. next to it i want to provide add button .. so whenever it gets clicked a new text field should appear to add new mobile number with validation ... a!localVariables( local!add , local!npi, a!sideBySideLayout( items: { a!sideBySideItem( item: a!textField( label: "Mobile Number", labelPosition: "ABOVE", value: local!npi, saveInto: local!npi, validations: if( a!isNullOrEmpty(local!npi), {}, if( not( regexmatch("^([0-9]{" & 10 & "})$", local!npi) ), "Maximum " & 10 & " digits are allowed", "" ) ) ) ), a!sideBySideItem( item: a!linkField( label: "", links: { a!dyna

Hi, I am using Import CSV to Database plugin to save data from CSV to database table. However the last row of the CSV data is getting stored twice in the database table. Can anyone please let me know how to overcome the issue? Below is the configuration of the smart service we are using: Delimiter: , File Has Header: true Column names: <no value> Csv header names: <no value>