Community

Hi, Is there a way we can provide a link in an interface to download the data in an excel from a recordtype. Thanks

Hi Experts, How to use Index Function to extract  whole row data from a list of records based on one record field value? We want to extract one row data from local! data where one fieldname : id has a value: 100051

Hi, I have an expression rule which is returning data from the database table. Now, I would like to get a latest db record using that expression rule. How can I achieve this. Any advises please. Thanks.

I am new to this concepts, please explain?

Does anyone know how to read the first line of a CSV? I have tried the readcsvlogpaging() function but it only works for files that are in the logs directory, and the readexcelsheetpaging() function does not work for CSV documents. Any ideas? Thanks!

Hello: I am looking to convert an array of number to a single string with comma as the separator.  In 23.1, they have a function called a!joinarray which seems to be the function I want to use but I am on 22.4 CE.  So, the question is there a similar function that will enable me to accomplish this?   Thank you. Final desired result: 360392, 361150, 361177, 377913, 378165 

HI, I have a scenario where am getting list of questions from the decision rule. i have to use that rule in expression rule to show all the question. could anyone help me with this

Hello,As the title says, I'm trying to extract data from a table using Appian RPA, and then apply some transformation to that data, and save it to a variable also in the RPA.The data is being fetched correclty, and the transformation "tested independently" is also working, but when trying to combine them, it doesn't work, as no data is being written to the final variable.Can anyone help me please?Thank you in advance!

Hi I am just looking for the horizontal scrolling in Appian. Is there any kind of components to achieve this kind of scrolling just like the Trello boards  horizontal scrolling, Or may be in feature we can solve this type of scrolling use cases.

Hi Everyone, Can anyone please help me how to split values, for example if input is 102-105; 109-111 then output should be 102, 103, 104, 105, 109, 110, 111. 

Hi All, I have the following nested cdt data and would like to get the errorCode field from it. Can anyone please help me out: [decision=DATA_ERROR, error=[errorCode=1003, errorMessage=Invaid ARN, errorDetails=The ARN details are invalid],[errorCode=1004, errorMessage=Invaid WorkFlow, errorDetails=The workflow details are invalid], isReferredToCreditVerification=]

Hi, I have a data in an an entity. I would like to pass two different dates and fetch the data between those dates and at the same time I would like to export to excel. Can someone advise how can I can achieve this. I found "Export Data Store Entity to Excel", but not sure whether this service will support date ranges to get the data from Data Store Entity. Thanks.

xybf.appian.community my trail version is not working and its across one moth with no solution.

Hi, If you use the Appian Site for a long time, the performance of the site slows down. For example, the time to press a button and move the screen or perform a data query is delayed. At this time, if you turn off the internet browser and turn it back on, the speed(performance) will recover to some extent. What causes this to happen? If the cache is causing this phenomenon, is there any way to fix the slowdown other than turning off the internet browser and turning it back on again? Thank you

Hi, I would like to run a process model once Every 2 weeks, every other Wednesday. Is this possible. Any advises please. Thank you

I'm working through the step-by-step guide for building an app, and I'm having trouble with something on Exercise 10: Process Modeling 101, Part 1. The guide tells me to open the AX Add Vehicle process model, click the Properties button, navigate to the Variables tab, click the record variable, and update the name to vehicle. Which I did: Next, the guide instructs me to click the Expression Editor icon next to the Process Display Name field, open the rule in a new tab, and change the name of the record rule input to vehicle. Which I did: I saved changes, as instructed, and returned to the process model. In the expression, I deleted record: pv!record and replaced it with vehicle: pv!vehicle: Finally, I'm instructed to navigate to the Process Start Form tab and make sure the rule inputs and values for this interface are vehicle and cancel. Cancel is there, but vehicle is still record: I changed the drop down to show vehicle from whatever it was sho

I have checked the group securities, the task is getting assigned, but when the task is opened from the task list access denied error is shown, process model security is also checked. Can anyone help me out?

So, I am trying to capture and store nested data from USDA Database - API (image below)  Now I am trying to store this data in a record - fields being gtinUpc, number, name, amount, and unitName.  I am trying to use the forEach-nested loop example from  https://docs.appian.com/suite/help/23.1/fnc_looping_a_foreach.html. However, when I try to nest another forEach and iterate over the foodNutrients, I get errors.  I have tried moving lines around - for example, move line 21 to outside the inner a!localVariables - nothing seems to work.  As always, any and all feedback/assistance would be appreciated. Thanks

Hi, I have below process model where I am trying to use "Export Data Store Entity to Excel". It was throwing an error when I try to use. I have not used any crazy setups related to this smart service, but still I am getting an error like ":  An error occurred when attempting to write the document Excel Export 3_9_2023 7_10 PM GMT+00_00. Please contact your system administrator for additional details. (APNX-1-4505-056) ". This error message is not giving any kind of clue to trace exact issue.

a!queryEntity( entity: cons!D202301DIV_GRL_DSE_ENTITY_REQUEST_DETAILS, query: a!query( filter: a!queryFilter( field:"requestId", operator:"=", value:ri!requestId, applyWhen: not(isNull(ri!requestId)) ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 50 ) ), fetchTotalCount: false ) I am facing this error when I'm opening one of my forms in my process model. 

Hi: I was experimenting with the Grid example in Appian Tutorials (https://docs.appian.com/suite/help/23.1/Grid_Tutorial.html) and noticed that I had some rows with no firstName and LastName.  So, I thought I would use "fv!row.firstName" as part of the showWhen-attribute to prevent those rows from being show (see image below).  However, I am getting "scoping error" messages.  I know I can use query to filter out those rows but thought I would experiment with this approach because I have had issues with understanding local-variable scoping.  For example, when I use {} right after a!localVariables (), I get scoping error (see second image.  Any responses to helping me understand local-variables/scoping would be appreciated. Thank you. Ma

I have created a MNI in a user Input task  In the assignment Tab, set the assignment to one to one as well The above group contains two users. But as soon as one user completes the task, whatever the data filled by that user is showing to the other user as well.  Could you please help me to resolve this error

Hi. I'm working through the Appian Developer course online, and I'm stuck on something in the Appian Step-by-Step #10. Specifically the first task, Configure Process Properties. The guide tells me to "Click the Expression Editor icon next to the Process Display Name field... Before you use this expression rule, open the rule in a new tab... Once the expression rule is open, change the name of the record rule input to vehicle. Click Save Changes." I did that:  I returned to the process model, as instructed, and in the expression, I deleted "record: pv!record" and replaced it with "vehicle: pv!vehicle". But when I went to the Process Start Form tab to make sure the rule inputs and values for the interface were "vehicle" and "cancel", the input I had changed form "record" to "vehicle" still showed up as "record" (I also changed the value to vehicle from... whatever it was; I do

Hello Folks: I am trying to figure out why the "value: ......." works when I use fv!identifier but fails when I use fv!row (this gives me all 14 values as the output) whereas I am looking for just the current grid-row's value (one value).  The gridfied documentation seem to imply both are equi As usual, thanks to the community on my Appian learning journey. Ma

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.