Process Automation

Goal: John Joe(12/2) Breakdown: Name: John.Joe (User picker) Birthday: (date&time)If no name is selected then present "N/A"What I have tried:  =if(isnull(pv!processvariable.name), "N/A", user(pv!processvariable.name,"firstName")& " " & user(pv!processVriable.name,"lastName") & "(" pv!processVariable.birthday &" )" )Problem: Issue with If statement 

"Activity Chaining in Process Model" I have 3 User Input tasks which are assigned to different Groups/users. For instance, I enable activity chaining between them . What will happen in that case. 

how can we get today date with time instead of now() function.

Hi, i have a picker field when i select some particular users names it has to show validation message else no  i have written like this but it is showing for all users whoever i select in picker field 

Hi,I have downloaded the latest jre version and installed it but anytime I run a bot it gives me this error of "[ERROR] 2022-05-10 18:54:49 - - java.lang.reflect.InvocationTargetException    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)" and more lines of error? Any clue on how this can be managed?

Could someone explain why the following code work without compiler errors? if( isnull(ri!user), "", isusernametaken(ri!user), user(ri!user, "firstName") & " " & user(ri!user, "lastName"), joinarray(split(ri!user, "."), " ") ) I expect some kind of evaluation error, but it works just as the three lines starting on "isusernametaken" were an embedded if. I saw that in one of the Appian courses and I'm wondering if it is some undocumented feature of the if function. Thank you

Hi, I have a!queryEntity where I have to apply few filters for querying data. I have to apply 3 filters with an "AND" along with these filters I have to apply additional 2 filters with "OR".  Is this possible. Any advices please.

Hi,I'm trying to setup the configurator ( maven) for Appian RPA and i'm unable to add the URL needed to the appian repository.Can anyone guide me on what exactly needs to be mentioned and where can get the required URL for the configurator to get set up.

Hello, I am using Appian RPA using Google Chrome to login to a client web site for downloading PDF documents. The URLs for downloading the PDFs are obtained from the web site, but on navigating to these URLs the documents are getting directly opened in browser. Is there a way by which I can download them ? I would also like to whether there is a way by which I can directly upload these documents to Appian without downloading them to the local machine ? Regards, Deepak Devarajan

Hi, For the above expression rule, if I try to add a!isNullorEmpty(local!ID), then I can getting false, but I am expecting true. Am I doing anything wrong here.

I'm just trying to learn if there is any way that we can introduce business exceptions and system exceptions into the automation flow like the other RPA tools (like try catch ) kind of elements?

I have created this rule to get the group names from my task report in a grid . but when there are multiple groups are present at assignee column, it gives error saying invalid group exception. Here is the code: if( or( runtimetypeof( ri!groupOrUser ) = tointeger( 'type!{http://www.appian.com/ae/types/2009}Group' ), like( ri!groupOrUser, "?Group:*" ) ), touser(group( togroup( touniformstring( ri!groupOrUser ) ), "groupName" )), rule!APN_displayUser( touser( ri!groupOrUser ) ) ) Rule input-user or group Any suggestions?

To get the all numbers between 2 numbers.

We are having a start date Eg. "2022-04-22 18:10:03"(Datatype: Date & Time) . I need to add 5 hours to the date and should provide me result as "2022-04-25 14:10:03". Requirement: Should not include time between 19:01(7:01 pm) to 9:59(am) and week end (Saturday & Sunday). Explanation: 4th April is Friday and the time given was 18:10(6:10pm). Total time taken is 50 min to complete 7pm on 4th April. As 23rd and 24th comes under week ends (Saturday & Sunday) we need to remove those date and time. Then we need to add date from 25th10:00am resulting in adding 4 hours 50 min on 25th.

Has anyone implemented a custom picker that queries all the expression rules in an environment ?

Hello! I'm with a problem using Appian RPA that when I click in one button in any browser (IE, Chrome or Firefox) it opens another tab that I can't switch to. I can do that using "Does desktop window title match?" but using both "Does browser window title match?" and "Switch tab or browser" it doesn't work and I can't use that tab. Can someone help me please? Appian Version: 22.1 Appian RPA Version: 8.1.0-79fe6dbff

I have a query entity where i am passing date column AA to fetch some info from table. Now based on Source,i need to use different date columns.Example: For Source A i have to pass column DateAAAA, for source BB pass DateBBB etc. I dont find a way to pass the source here. Like if source is A,then do this ...  a!queryFilter( field: "dateFilterXXXX", operator: ">=", value: gmt( todatetime( workday( local(now(), "America/New_York"), -10, ri!holidays ) & " " & totime("16:00 PM") ) ) ), else.... a!queryFilter( field: "dateFilterBBBB", operator: ">=", value: gmt( todatetime( workday( local(now(), "America/New_York"), -10, ri!holidays ) & " " & totime("16:00 PM") ) ) ), I am not passing parameters from any other place into this rule, so i dont find a way to pass the source. I need to get the source first and then define filters accordingly. Please suggest on how i c

Hi!, I need to change the name of a rule input from a expression rule. But this rule it´s called by nearly 20 rules/interfaces in my app. So, is there any way to change all que code quickly from all 20 objects with the new rule input name? the only solution i have is going one by one changing the name. Thanks!

I am getting the below-mentioned error while converting xml to cdt using torecord() function.  Does any one know what is the root cause of this error ?? or Let me know alternatives of converting XML to CDT ? Thanks

I have created expression rule to find data like {{changeid:"1234",prioritystatus:null}} now i want to update this list of dictionary using a!update how can i do that? i want to update that field prioritystatus. I am doing this by selection of one prioritylist in dropdown box. I have done this in user interface and on changing this status it will update the above field in this list of dictionary. But it gives error. I have done like this: a!update (data:{{changeid:"1234",prioritystatus:null}},index:"prioritystatus",value:1)

Hello All, My requirement is to search a word from the sentence. for example: sentence(single text): "The document is AI contain the data"  search text :"AI"     Output: true The desired result is:- get that the sentence is having the search text but only if exact word is there no if that alphabet is any word. For example: "The document  contain the data" search text: "ai". output: false regards sahil

a!queryFilter( field: "expiredDays_int", operator:"between", value: {rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation( selectedItemType_txt: 1 ).startIndex_int, rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation( selectedItemType_txt: 31 ).endIndex_int } ) how can write this query without between operator 

Hi there, I need to use the date string in format "YMMd", for example, "20220329" for today. I am using the datetext function: datetext(today(), "YMMd"),  if today() function return "03/29/2022", then the datetext(today(), "YMMd") will return "20200328". what's the issue there? why I cant get "20220329"? what's the good way to archive it? Thanks! Lin 

Need to build a robot that will interact with JAVA/SWING client.  It seems that there are JAVA extensions by Robocorp and UIPath.  What are the implications for having that to work with APPIAN/RPA ?  Thanks

Appian Lovers,  Per Appian Documentation Developers can design the Decision Table and delegate the same to Business Users to add Business Rules. This can be achieved by providing the Editor access to Decision object which will then give them to update the Decision via "Analyst View". Please refer to link below  https://docs.appian.com/suite/help/22.1/Appian_Decisions.html#analyst-view I am not sure, where or how to access the Analyst View. This question is in reference to a request from the Line of Business to figure out if they can manage the Decision Table themselves. Thank you,  Janaki Ram Kavuri