-
Recently active
Hi Team, I am trying to convert html code in my email template to dynamic so i can loop some values using expression rule but i facing some issue in syntax , Looking for the help below is the html code <!DOCTYPE html><html><body><head> <link rel="stylesheet" href="styles.css"></head> <h2>###bodytext###</h2> <br><br><h2>Please click on any below link to submit you response</h2> <a href="mailto:processmodeluuid0002e98e-199e-8000-273d-7f0000014e7a@cscswdev.appiancloud.com?subject=###resultId###&body=Please don't edit subject and To-email Address, Please add your comments below">Complete</a><br></br><a href="mailto:processmodeluuid0002e98e-199e-8000-273d-7f0000014e7a@cscswdev.appiancloud.com?subject=###resultId###&body=Please don't edit subject and To-email Address, Please add your comments below">Cancel</a> <br><br&g
Hi I have scenario to create a chat bot in my application can any one help me how to do this?
Hi , I want to know what the relevant links or the paths and the topics which are priority for the preparation of RPA +IDP Badge. Also want to know the percentage that need to be achieved in order to get the Badge.
Hi All, I have this cast function cast( 'type!{urn:com:appian:types:TLT}TLT_VEHICLEDETAIL?list', ri!data ) and I'd like to change TLT_VEHICLEDETAIL with a dynamic input using ri!inType. I thought to fix this problem with concat function ex. but it doesn't work. and my result was this one who can help me?
Hi team, I was following the document https://academy.appian.com/#/online-courses/fc14c3d1-0eb3-4d9d-8ae2-fc0149ae7585 asking me to select Template from the toolbar and then select 'Import Template' but I do not find the import template icon on my community edition. I can just see the default ones.. When I see the Appian documentation at https://docs.appian.com/suite/help/22.3/rpa-8.5/templates/rpa-templates.html I can see the import template icon on the top right in the doc. Can someone pls help is it just me or do I need to update something somewhere to get the import template icon ?? for now while I wait I have raised this to support team as well thanks jaideep
Background: Using integrations I have called several endpoints and pulled the data into a map with nested maps. I now need to move values from the nested map to the parent, as they are all 1:1 relations. a!localVariables( local!CDT: a!map(id: 1, name: "Walt Disney", demographics: a!map(age: 73, gender: "M")), local!CDT) This returns: Map id1(Number (Integer)) name"Walt Disney"(Text) demographicsMap age73(Number (Integer)) gender"M"(Text) what I am in the need of is: a!map(id: 1, name: "Walt Disney", Age: 73, gender: "M")
Hello good evening, I need help, well, it turns out that I have a problem, for example, when I want to omit certain special characters, I use substitute, all fine for example if I only want to omit the symbol "&", but when I put another symbol, for example "%", instead of replacing it, I get a blank space, I have already used substitute, stripwith, a regex, and I can not find a solution, I attach my code. a!localVariables( local!subs:substitute(ri!name," & "," "), local!formatB: cleanwith( local!subs, cons!GT_CONS_Clean /*1234567890qwertyuiopñáéÃ%ADóúÃ%81ÉÃ%8DÓÚQWERTYUIOPasdfghjklASDFGHJKLzxcvbnm-ZXCVBNMÑ_ */ ), if( length( local!formatB ) = 0, "attach", local!formatB ) ) I have already tried these functions and I can't get that. regexreplaceall("\s\W", local!sub, "_") stripwith(ri!name," &#$%&/|¡? ") For example, when I try to test this string, instead
Hi Experts, I have a requirement where we have to get the input from user for the time fields, User want the time to be entered in HH:MM:SS in 24hrs format where SS is optional. Below are the input with expected stored output Input1: 23:55:55 Output: 23:55:55 Input2: 10:32 Output: 10:32:00 Input3: 23 Output 23:00:00 Input4: 231000 Output: 23:10:00 Input5: 2359 Output: 23:59:00 Input6: 23 Output: 23:00:00 Kindly suggest for the feasibility of such expression as how can we achieve this.
Hi there, could anyone let me know what's the problem here, in the following expression rule, if the condition is meeting, it will return the records which meet the condition, if there are no records meet the condition, I just want to return 0 item, but here it returns 2 "0 items". replacing "{}" with null does not work either. what I should do? regards Lin
Hi All, I have a table with studentid|subjectid 1 | 10 1 | 11 2 | 12 Students who belong to 10 and 11 should get 1|Science, 2|Maths. How can I get the output like this.
Getting "RecordFormatException" while updating the record in excel file. Used apache poi with the version 4.0.0 for reading and writing to the excel file. Can any one help on this issue?
Hi all, {1,2,3,8,9,9,9,9,9,80,90,70}, {56,76,54,32}, {20,23,45,54,32,54}, {1,2,3,4,5,6,7}, {11,12,13,14,15,16,17,18} Please suggest how do this using foreach function get output like this, length of array 1 is 12length of array 2 is 4length of array 3 is 6length of array 4 is 7length of array 5 is 8 Thank You In Advance
Hi All, I have been trying the image recognition RPA functionality, getting the below error & I have used the given templates & ran the process in the available resource. Kindly let me know where can we insert the image for Image recognition, How to configure this?
Dear david.catalan Could you help me to resolve this issue? I am following the course and trying to record the searching bank name and certificate number action in chrome browser but could not get the list of applications Please refer to the screenshots below: I have chrome in the start menu Could not see any applications in the dropdown list,
My teammate found a bug when using proper() to display a label; a word preceded by a non-alphabetic character will not be converted to proper case. If the 11th floor is home to the HR department. Floor.id = 11 Floor.department.name = "human resources" We would expect: Floor 11 (Human Resources) but instead get: Floor 11 (human Resources) To reproduce the issue, I used this expression to check capitalization: proper( "I am reporting that ""proper() coNverts each [alphabetic] cHaRacter into ProPeR caSe " & "(unless a non-alphabetic character precedes it)""" ), Where I would expect: I Am Reporting That "Proper() Converts Each [Alphabetic] Character Into Proper Case (Unless A Non-alphabetic Character Precedes It) It's returning: I Am Reporting That "proper() Converts Each [alphabetic] Character Into Proper Case (unless A Non-alphabetic Character Precedes It) Is proper() working as designed? Side note: 22.4 documentation reads, "Converts each character i
for example my input is 0323 and i need output march-2023 (or) 03-2023
Hi Everyone, I have the requirement where the excel file is to be read by IDP. But I am not sure if IDP can extract data from excel file. Can anyone please help me out if it is possible through IDP or any other alternatives? Thanks, Shubham
I am new to Appian and I am evaluating the Appian RPA. I have already completed "Appian Robotic Process Automation (RPA): Learn to Develop Bots" course. I want to learn the process automation using Appain RPA so could you please suggest any course with detailed explanation? Thanks in Advance!!!
The guides don't say anywhere how to open IDP.Perhaps it's not installed on our instance and it would be obvious from the main menu.Where does IDP normally appear? In the top right main menu?Are there permissions associated with it?Our system administrator is on vacation and I'm not sure if I just can't find it because I'm learning how to use Appian, or if it's not installed. Thank you.
Hi All, I am Trying to Fetch Last login Details of some users by using getuserlastlogin() but it is returning Null values for users who logged in 1 week before. Does This function work only for last 24 Hrs? Thanks in Advance!!
Hi I am getting an error message below. Could you tell me how to solve it. ■the whole message displayed by the Configurator -----------------------------------------------------------[INFO] Scanning for projects...[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[WARNING] Could not transfer metadata org.apache.maven.plugins/maven-metadata.xml from/to SERVER_ID (mnvk.appian.community/.../repo): authentication failed for mnvk.appian.community/.../maven-metadata.xml, status: 401 Unauthorized[WARNING] Could not transfer metadata org.codehaus.mojo/maven-metadata.xml from/to SERVER_ID (mnvk.appian.community/.../repo): authentication failed for mnvk.appian.community/.../maven-metadata.xml, status: 401 Unauthorized[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[WARNING] Could not transfer metadata org.apache.maven.plugins:maven-archetype-plugin/maven-me
Hi, I have an excel file which looks like that I am importing to my Appian DB through the smart service 'Import Excel to DB' and Ticket_Number is the primary key on my DB. It appears to me that the Smart service is sorting the primary key in ascending order (which I don't want).. I don't want to sort my data in either ascending or descending order. One solution is to create a separate primary key and prevent this from happening but is it possible to restrict the sorting in the smart service 'Import Excel to DB'. Is this a bug ?? or just that I am not aware of how to prevent my smart service to do any kind of sorting ? please help thanks jaideep
Hi I am trying to do 'Maven Setting' with Appian RPA Configurator. However, an error message below is poped up. ・Authentication Error!: Check that the provided console repository URL and the maven API key are valid. This means that the provided console repository URL and the maven API key I input is incorrect, isn't it? Please let me know if there is a possible cause other than incorrect input of the value.
Hi everyone, I have a CDT CDT type process variable called pv!caseIds, which contains a column showing case IDs as below: [caseIDs=1, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=2, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=3, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=-1, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=-2, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=10, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=3030064, deleteDate=11/12/2001 17:30 GMT+11:00] I also have a text list of case IDs, saved in another process variable called pv!caseIdText = {1,2,-2} Now I want to find all the case IDs in pv!caseIds.caseIds column that ARE NOT in pv!caseIdText (which are {3,-1,-2,10,3030064}) I tried using difference() as below: difference((pv!caseIds.caseIds, pv!caseIdText) and got this error message: Expression evaluation error at function 'difference' parameter 1 [line 2]: Invalid index: Cannot index property 'caseIds' of type Text int
When I use formatjson function, it automatically change "&" to "\u0026" , and "<>" to "\u003c\u003e", how to aviod that? Can anybody help? Thanks
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
