Discussion Categories

when user upload any kind of excel sheet then interface will extract data and show the user the data. I have created a Expression rule  readexcelsheetpaging(excelDocument : todocument(ri!ExtratExcel), sheetNumber : 0,pagingInfo:a!pagingInfo(startIndex:1,batchSize:1000),) but don't know how to add it in script task and make process model out from this.

Is there a way to create application and add provided artifacts into it on Appian using Process model or some other mechanism. Problem statement : Create Backup application from higher environemtn with provided artifacts added into the created applicaiton. export it before code promotion 

Hi, I have a process model that generates a document, and the id of the document gets stored in the process variable. Now in my interface I want to call this integration and extract the document ID so that I can provide it for the document download link function for the user to download the document. Now the problem is I am unable to access the result of the integration. I tried accessing the id using 'rule!integrationRuleName.body.id' but it constantly gave me an error saying cannot index property body of reaction tree. Can anyone help me in this, how to extract the document ID from the integration result ?  

Scenario is need to filter the data based upon user access to certain business unit id,forum id.Business unit id's are different sectors of business and they are mapped to certain forum id's.Business unit can have duplicate forum id's. they are stored in table like  user id bu id forum id 117 4 80 117 4 103 117 4 114 117 19 80 19 also has records with 103,114 forum id but we need records on the above mapping but when we try to filter it out by querying and storing in a local variable not able to filter out records for mapping of(19-114,19-103). local!buid(filter:userid), local!forumid(filter:userid,buid), In a interface we are using a record type in data and in filter we are using logical expressions.

We can do Numerical rating in appian , Is it possible to create a Decimal rating like , on click of star once (0.5,1,1.5,.,.....)

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'