Discussion Categories

I had created an interface that calls another interface. Also, I had created a counter as a local variable that is incremented by 1 every time a button in the interface is pressed. On every button press I want to add a new section that calls the child interface. My problem is that on the first press only the child interface appears! So here is the code if you can help me a!localVariables( local!count: 1, { a!sectionLayout( label: "Click the button to add a new Customer Currency section", contents: { a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Add new section below", icon: "plus-circle", value: local!count + 1, saveInto: local!count, size: "SMALL", width: "FILL", style: "PRIMARY" ) }, align: "START" ) } ), if(local!count<>1,a!sectionLayout( label: "", contents: { rule!C_CustomerCurrency(ri!Currency) } ),"") })

Hi, I have process model with process variable value like below if i wanna use  process variable for rule input in interface? Must I do? Thanks 

I have a required where i have to load more than 1lakh records of excel data in database is there any way to do that from excel to database. do appian 17.4 version support below plugin?

Hi Appian Pals, I have a requirement to send a variable which is of type multiple to send it one by one in an incremental way in the sub process.I tried to achieve this by using MNI in the script task and align the values by using spawn all in the list variable and then align them in the new pv.Now that pv is not getting the value from the second index. For the first instance, it is getting the value and getting inside the sub process, but for the second value in the list, it is not incrementing and getting updated.What i want is recursively the list should increment and assign values to the pv so that it can go into the sub process.Any of the directions would be appreciated.

I was trying to follow this course for RPA Windows Automation: https://academy.appian.com/#/online-courses/b08d47ca-0cac-42a4-803d-7384e0127dc4 The course stated to select the Element Selector to Name instead of Automation ID in Interact Element Action, and select the parameterized variables they told to create for the Element Selector Name. The problem is this doesn't work on my end. When I switch the Element Selector to Name and select the parameterized variable, the bot is unable to find the element as shown here:  However, when I deselect the Parameter checkbox in the variables, I was able to proceed with the Action, but the value of the clicked number in the calculator doesn't save in the variables:

Hi All, I am new to Appian programming, and here I need your help; I have CDT, and based on the below screenshot, I need to remove the 5th record based on the following conditions. The Person id duplicates, and ChildCustodialTypeId is NULL. In this scenario 5 the record I want to get rid of when I call the CDT, so please let me know how I could do this successfully.

I see some example images used in the interface 'design mode' templates and seems to high quality like SVG and lightweight.  Where can we find the default example images list available from appian which can be used in SAIL? ( couldn't find any reference in documentation)

Hi every one,  I'm having a local variable that store data in a Json format then converted it into a type that Appian accepts: a!fromJson(local!settings)  and I get this as the result:  Dictionary name"Type"(Text) value"["5"]"(Text) valueDisplay""(Text) I want to get all the settings with value equals a particular ID, but it shows this error: Expression evaluation error at function 'wherecontains' [line 41]: Invalid types, can only act on data of the same type (Number (Integer), Any Type).  index(local!settings, wherecontains(local!currentType.Id,local!settings),"value",null) I guess the issue is because value is now containing special characters.  Any one having a solution for this?  Thanks a lot in advance for your helps!

We have .csv files in System logs   hc-application-objects.csv and hc-applications.csv. I know we have an excel plugin Load/Import CSV to database. But with this approach we have to upload the csv files in Documents folder.  What we want is we have to load these csv files from logs to Database without saving them in documents folder.  Can anyone help me how to approach.

Hi, Does Appian have the functionality to store when a user logs in, what are the reports he downloads, how much time he spends on a particular tab? Does Appian maintain an Audit trail of users? If yes, how can we get access to that?

I have to display the disk space used by the documents in an application in interface.  I found this java method public java.lang.Long getMegaBytesUsed() in docs.appian.com Can anyone tell me how to use this java method in Appian to get disk space. 

Hi, How to compare a any day (this day is added 3 hours)  with today anyDay : 10/02/2021 03:00 AM now: 10/2/2021 05:00 AM it will return anyDay > now

Hi, Few weeks back I was able to create DSE as part of creating Record Action.  But now in the new release of Appian 22.3, I do not see that object getting created while creating Record Action.  What is the alternative? Thanks in advance, Suneetha.

Hi, I am going to take a test for Appian Certified Lead Developer, but I didn't find any offical courses for that, is there any advice for the exam? thank you very much! [emoticon:c4563cd7d5574777a71c318021cbbcc8]

Hi All, I have created a task report where my initial sort is task_id in descending and configured in Site .Whenever I load the task report, it shows me the grid in a correct manner with task_id in descending order. I am also showing a link where I am calling the record action to create a new task. The task consists of 5 milestone with active chaining and all has back button except the 1st milestone. When the user clicks the "next" button in 1st milestone then we generate task id by writing in DB. Not working Scenario :  From task report, the user clicks the link(create new task link),he completes 1st milestone data & click next ,goes to 2nd milestone. Then from 2nd milestone if the user goes back and comes to 1st milestone, then user tries to navigate, so they just click the task report tab . Issues : 1. Now the current task id is not visible in the task report grid 2. The sorting of task_id in task report is totally collapsed. Until this sorting was working p

Can you check if the task has been rejected by all assignees? And is it possible that the task can somehow be seen again on the system or gone for everyone else. 

Hi guys, why when I try to create a rule input in expression rules editor, it told me  could not find the variable? 

Hi everyone,  I'm having a question regarding how to use the writeToDataStoreEntity function to modify values in DB.  To be specific, I'm having a form that allow users to update their phone numbers. It will be saved in a DB with corresponding DSE storing all customer data. When the customer click  the button Save New Change, the existing number need to be replaced by the new number, both on the interface and in the DB. I'm not sure how to do that yet. I'm thinking of using writeToDataStoreEntity, and find the number that needs to change by the unique customer ID, but not really know in specific how.  Any one have a solution for this? Really appreciate your help! Code for the Save New Change button is currently as below, in that local!allUser query list of users from db, and selected user is the one that need to change phone number: This code shows an error:  An error occurred while trying to convert the given data to the type of

In the image bellow the 3fields in the square come from a dropdown  ("SI" or "NO") in a user interface. I can see the user responses in a read-only grid (see the image bellow).  I want IF 3 condition ("Financial", "Documents", "Certificate") in the red square are "SI" then the column "Estado" return a new value "Finalizado"  IF just one condition ("Financial", "Documents", "Certificate") in the red square are "NO" then the column "Estado" return a new value "Pendiente" Next i want to store the value of the column "Estado" in my cloud database

Hello Appian Comunity, Can you pls let me know and explain which is the proper expression rule when configuring the visibility field for the " only show when " option on the record type object? What I´d like to do is to show the image of the car when available. As I have it right now it doesn´t show the image on the record list. also, can you pls help me understand why if I have the following configuration on the display value, and on the visibility, field selected " always show " I get the error?  Thanks a lot.

Hi All, I am using read excel function to read the excel file and mapping these values to CDT. I am giving timestamp field in excel and trying to map with CDT having data type 'Date and Time', and in postgres Db it has timestamp field, but it is not getting mapped to CDT. NOTE: If I enter only Date then it is getting mapped to CDT and updating the DB, but If I am trying with timestamp field the CDT values are null.   Thanks, Kiran

Hi Team, I have a use case where if some user clicks on a link, then first, some data needs to be deleted and then second, an api integration needs to be triggered with a query parameter whose value basically is the value of the link clicked.(local!selectedSuiteName) See below screenshot:  So, if someone clicks on the first link, then first I need to delete the related data from db and secondly then I need to call an integration which is configured basically to call an API. But I want to pass the selected link value as a query parameter to the API, I am not sure how to do it in expression. What I know is I can call an integration using rule!<Integration name>, however I don't know how to pass the parameter which is basically saved in local!selectedSuiteName. So the full flow is like, 1. When user clicks on a link, some related data need to be deleted from an appian table. 2. Now, I need to populate the same table with some data and that data basically I want to fetch

 How can we set a link which is valid for 2 hours only? And I want to send it by email object to someone. If someone tries to open this link after 2 hours it will display a message only e.g. Already submitted!!