Foundation

Is it mandatory to give Appian Certified Associate Developer exam if someone is having L2 Credentials and wants to attempt Appian Certified Senior Developer exam ? Thanks, Gaurav Singh

Hi everyone, please can anyone guide me through RPA browser Selenium recording ? I have  "Browser initialization failure" error after recording browser with Selenium " . I have no idea what steps to follow in the RPA to solve this issue. The screenshots are attached.  Thank you in advance .

Hi, I have set up timer event  in the escalations tab and selected Send Alert in what action to be taken section ? and gave my e-mail address, it's not working. Tried Send e-mail smart service, i can receive e-mail with this smart service, ONLY change i made is changed Timezone in process model properties to IST, which is my time zone, any help is much appreciated.

HI, Does appian takes care of Day-light saving when the time changes in winter?

Hi, can anyone help me with this error please An error occurred while trying to write to the entity "SHA_listing" [id=5e13a319-1194-43c0-8694-7083cec21cb0@26128, type=SHA_listing (id=6198)] (data store: SHA Tables and Views). Details: org.hibernate.PropertyValueException:

I am trying to build a simple application which allows users to log hours worked. In the summary page, there is a table of logged shifts, and the ID field has a link to a page with details about the shift with the particular ID. I have an Expression Rule called TST_getTimesheetSubmissions which returns an entity with specified a!queryFilter( field: "id", operator: "=" Currently, in my summary view, I have the following configuration: rule!TST_TimesheetSubission( TST_timesheetLog: rule!TST_getTimesheetSubmissions(rv!identifier).data[1], cancel: null, readOnly: true ) The page loads without any error. However, the hyperlink from each ID redirects to the same entity with ID=1. Can someone help me fetch the appropriate row of data from the table? Thank you!

I've been following a tutorial to build a simple system which allows users to record their work hours and date. When I try to edit record type using rf and rp, I receive an error message "Improper scoped variable". For example, I try to edit the "summary" view using the rules defined in an Expression Rule: rule!TST_TimesheetSubission(rule!TST_getTimesheetSubmissions(rp!id).data[1],null,true) I receive an error because I have rp!id, and  and when I try to edit the List so that the ID of each row becomes a hyperlink to an individual page about the shift logged, I have: - Label: rf!id - Record Type: rp!type - Identifier: rp!id the above three get an error, so when I access the Site, I receive an error "The Requested Record Type Is Not Available". Before the edit, it is a Text field and uses fv. How do I access rf and rp, or alternatively, how do I use the rp equivalent with fv to fully display the page? I'm new to Appian and the forum, if I

I have an array where I would like to replace the zero values with the previous non-zero value. i.e. convert { 15, 0, 0, 23, 0, 0, 0 } to { 15, 15, 15, 23, 23, 23, 23 } Any ideas?

My requirement is to find out all the unused objects of the Application, unused rule inputs from of the Interface and unused Process variables from the Process Model. I know manual work is very lengthy so can someone suggest me any shortcut method or any plugin can help in this. Thanks in advance

We have a requirement where user wants to upload bulk data in Appian. A file upload option in an excel or CSV format is desired. Once uploaded, the file contents should be written to DB and later available for user to view data in a grid format. File can contain a maximum of 200+ columns & 10K rows. What is the best practice to address this requirement in Appian. Thanks in advance.

Hi All, i am getting following error on my summary view. Error Evaluating UI Expression Expression evaluation error [evaluation ID = EEBZL4J1] in rule!APN_qry_xyz at function a!recordBodyWrapper: An error occurred while retrieving the data. Details: Cannot open connection (APNX-1-4198-000) I can see rest of my code(expression rule, qry rule, interfaces, integration and all other objects) working fine except summary view. Kindly help me. Thanks in Advance.

In case that we developed an application system through Appian and have it delivered and implemented to our client, one of their documentation requirement is the full source code of the application/ system given to them. Is there an option or facility in the Appian that we can generate the full source code of the built application? Thanks..

Hello, We have a requirement to display certain statements in the form of checklist, so the user would read one by one and check it. The statement also contains links. Our initially idea was to have checkbox field in an array to display the items as a checklist. But now since links are involved in the items, we cannot really use checkbox field as the field labels can only be of text there. The other way around we could think of is displaying it in a grid field. Links is achievable here. But the check issue, when we disable the selection, we get a default selection option (Selecting all ) along with the column title. We would not want to have this option because, the primary goal is to read through every item in the list and click on the checkbox. So any idea to remove the All Selection option ?  Thanks Nandini

Please provide the code for printing the below pattern: a ab abc

Can I import  and export process in BPMN 2.0 and the documentation it generates for the process flow. If yes, can someone please guide me on how can we do it?

Hi , we are using Export Data Store Entity to csv smart service (pipe delimited) and for few columns ' and " prefixed/suffixed in the generated csv file even though it does not exist in the actual data. Below is sample data: -  Phone number in the database is started with +, but generated excel column has ' prefixed - Actual text in the database doesn't have the " but there " prefixed and suffixed in the generated execl.  Observed ' is appended when there is + in the beginning of the string and " are getting appended in a couple of scenarios. Is this the expected behavior of plugin? how can we avoid these characters?  pls advice.

Hi, I am not sure if I get it right but I am now trying the hands on for the low-code app in the Free Trial version. I am following what is indicated in the lessons but i can't seem to proceed to in Picture 1 after I created Group, Folder and then Record Type. In the video, once he saved the added Record Type he was directed to Picture 1 but when I tried, it only saved and only stayed in Picture 2. Did I miss something? Thanks for your help! PICTURE 1: PICTURE 2:

Hello. In my send email activity, part of my message logic uses the workday function in an expression. =if(  isnull(pv!request.value),  workday(today(), 5),  workday(today(), 6)) While testing last night (July 1st), we expected the date returned to be 5 working days ahead (July 8th) since the value is null (verified). The resulting email was 6 working days ahead (July 9th). My only assumption is that Independence Day is observed on Monday, July 5th so the workday function excludes Monday in its calculation. Is this true? The workday function allows for an array of holidays to exclude, but the sample seems to want specific dates, not just a identifier of the holiday name. Are we expected to write every year of dates? It can be done, but was just interested in this approach.

Hi, I have a scenario where my Database is in GMT and I am trying to convert it to EST time by using GMT function  gmt(property(local!data,"XXX",{}),"EDT") its working fine during night time but when this function is executed during day time its giving current date-1. Any solution for this would be really appreciated.

Hi All, I am exploring options for automated testing:  have anyone has experience with automated testing for appian using BDD Cucumber ? ease of implementation  ease of Integration OOTB  support level of skills required to build test scripts and execution cost involves preferred option will be able to cover the testing automation required from SAIL interfaces, expression rules, to WEB services and plug-ins Is Jenkins purely for automating deployment? Can it be used for some level of automated testing?

Hi all, I am getting the following error when I try to execute a robotic process in Appian RPA console: [ERROR] 2021-06-17 10:27:07 33s (0h) - Exception thrown on agent...com.novayre.jidoka.client.api.exceptions.JidokaBrowserInitFailureException: Browser initialization failure. Make sure the browser is installed and the driver version is compatible with the browser version. Can someone please guide me to fix this issue? Thanks in advance, Brinda 

Hi, I have the following scenario: Take a shopping cart. I have three tables: cartdetails which has foreign key productsId from product table, product table  which has categoryId from category table. the grid data is -> cartdetails and columns are ->   srno| category name| category type| category data| productname| product price| product data| quantity| totalprice Now in the grid i can call a rule to fetch the required data as: 1. call getcategorydata()-> for  category name| category type| category data 2. call getproductdata()-> for productname| product price| product data Instead of calling the rule again and again for the three columns each, i want to call it once per row. So im trying to use localvariables.  But the data that i can use is only fv!currentpage outside the gridcolumn() . so i tried doing fv!currentpage.data.productid. This is giving me the whole array of products. I want to index this to only get the individual row

Hello everyone, I kindly ask for a piece of advice doing this query. I have a CDT called PurchaseOrderDetails and another one called ProductOrderedDetails. In this case, my PurchaseOrderDetails is pointing to an array of ProductOrderedDetails, like in the image below. I was wondering what can be done in case I want to get all the information regarding the ProductOrderedDetails for a specific Purchase Order. I already tried a few variations pointed in this page (https://docs.appian.com/suite/help/21.2/cdt_design_guidance.html) but I'm still unable to retrieve that information. In the MySQL database, the PurchaseOrderDetails doesn't have a specific column called "ProductOrdered", but my ProductOrderedDetails column has one called: On this case, what it's the best way to build queries around nested CDTs like this example? Kind regards

I have an interface where a supervisor can prioritize orders.  Is there a way that when one order ships that the numbers will automatically change to a lower number?

I have just started exploring event management part of appian and I have few doubts, 1.  If we configure start node in process model with receive message event with config 'External to Process' it would mean that once message arrives from an ext system the process would start.     Doubt is that how would external system trigger this event? what component or configuration would be used by external system? 2. What is the difference if we, - configure start node with receive message event (with external to process config) - if we create a web api with start process configuration  as these both would allow external system to start process Any leads would be appreciated.