Community

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.

Hello Community: This probably a dumb question but here is my dilemma.  I have two tables 'Consolidated Product List' and 'Brand Owners' (fields: brandIdentifier, brandOwner).  The field 'brandIdentifier' in Brand Owner is the foreign-key in 'Consolidated Product List'. I am trying to populate a grid with brandOwner for each product in 'Consolidated Product List' but having a heck of time display the brandOwner.  Here are images of my query, my interface, and my debugging screens. Any help would be appreciated. Ma

Hi, I am fileUploadField() to uploaded the document in a specific folder and saving the documentId in the database under one of the field/column. When I try to perform delete functionality against the database record, I am using "Delete from Data Store Entities" smart service. When I delete a database record, I would like to delete the corresponding document which is linked to the database record. How can I achieve this. Any advises please. Thanks.

Hi,  My company is moving towards Appian and we would like to use the power of Appian IDP. However there are many data that are confidential and are customer related and keeping it on Appian application or DB may violate our data protection or GDPR policies. We as Appian developers won't be able to promote IDP even though we have an Appian domain. People might see it as risk. So for me to sell IDP and its features I will also have to prove the post reconciliation data is being removed/deleted from Appian application or DB. I do not have the end to end knowledge of all the Appian IDP objects and process models. Please help me to know how I can ensure that once my data is processed if I have to delete the document and its related data - how do I do it ? Currently I see on the site Is there a way user is given a choice to delete the document ??  Tables: For now I am aware that dudocunderstanding and tables related to the newly created CDT like contains the

Hi, I have a process model with the below scenario. I have a main table where I need to store my parent db record and after generating the parent db record I am collecting the parent record id using script task. So far so good. Now, I have a "Write to Multiple Data Store Entities" smart service using which I planning to store data (DB records) of the child tables and passing parent record id reference to the child tables. The way I have designed my db tables like using parent child reference keys (using primary, foreign key reference). I am good at this stage too. Now, the issue was, I may or may not have child entity tables data. If there is no data in the child entities, still an empty row getting created in the child db table. How can I handle the situation.

I have a date field that autopopulates a read-only field and also saves to the data. Right now in the read-only field the dates are displayed as 2/28/2023 and I would like to have it displayed as February 27 2023. any suggestions for the code? this is what I have atm text(local!birthDate, "mmmm") & " " & text(local!birthDate, "dd") & ", " & text(local!birthDate, "yyyy")

Hi Guys, Just wanted to know since a lot of work is done in expression mode which is in light theme so is there any way we can switch to dark theme as most of the editor of other languages have dark theme. And it's sometimes difficult to look in light theme for a long time. Thanks in advance

Hi, While clicking on few of the documents below to see the summary like INEE1 and INEE2 - I am getting an error as below.  1. This is not happening for all the documents. I am able to see the summary of other docs 2. Also this is not happening with the problematic document when the document state is in Auto Extracting or Pending Reconciliation State. At Auto Extracting or Pending Reconciliation State - I can see the summary of the docs. The moment it moves to Completed status I get the above error. any help will be appreciated thanks jaideep

Hi Appian team, I am learning IDP and this is not a blocking issue though.  When I set up everything as in the given tutorial for IDP I have 1 doc type - let's say - 'Expense Reimbursement' I do the required configurations in the Configure tab and then upload 1 pdf and it asks for classification Why it should be asking users to classify if I have only 1 area of classification? Shouldn't it pick it be default ? thanks jaideep