New to Appian

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

Hi, I am trying to get the document name by passing the documentId. If I am fetching the documentid into a local variable and pass, then I am getting an error. Where as when I pass the documentId number manually, I am getting required output. Not sure what is wrong. Do I need to do any kind of conversion before assign to a local variable. a!localVariables( local!templateDetails: rule!LC_getTemp(Key: 4), local!documentId: index(local!templateDetails, "documentid",null()), local!documentId /*document(local!documentId,"name")*/) When I try to execute below code, I am getting below output. a!localVariables( local!templateDetails: rule!LC_getTemp(Key: 4), local!documentId: index(local!templateDetails, "documentid",null()), document(local!documentId,"name")) Whereas when I try to execute the above code, I am getting the below error. Can someone advice here.

Expression evaluation error : com.appiancorp.connectedsystems.templateframework.functions.pipeline.proxyDecoratorPipeline.TemplateInvocationException: Contact the developer of this template to resolve the following issue. java.util.ServiceConfigurationError: io.grpc.ManagedChannelProvider: Provider io.grpc.netty.shaded.io.grpc.netty.UdsNettyChannelProvider not found

Hi I am trying to emulate the 'Corporate Raffle' tutorial in Appian with some changes in the requirements.  I have to show a 'details' section within the 'summary' section.  If user selects an item, product id and product description information has to be shown in the 'selection' column. Right now, when I click on the 'checkbox', it selects all options and I can't display the selected item(s) in the "Selection" column.  Is there a way to include collapsible section within a grid?  I am using card layout since I couldn't get the collapsible section with selectable grid layout. Any suggestions or idea would be really appreciated. Thank you. a!localVariables( /*--- start of localVariables */ local!pageHeaderTextColor: "#44546A", local!sectionDividerColor: "#333F50", local!isSelected: { false() }, local!dataSummary: { { productId: "123", productDesc: "item Apple" }, { prod

Hi, I have 2 groups one is parent and child. Parent grp having test users and second grp having SSO users. How do i show users from both groups in user picker. I can’t merge or delete groups. Client having thier own way of handling these grps. Thanks

Hi Everyone,  I am calling the expression rule from the interface through button widget using startprocess and the process model calling the rule in the script task. But the rule is not executing. Can anyone please help me how to achieve this? Thanks in advance!

Hi! I have a process model which creates a XLSX file, which I want to convert 1:1 to CSV. But I have 2 problems: 1. The columns don't get separated and are written to the same column, where attributes are separated by commas. 2. For some reason even having only one row in excel, it continues to read until row 95, so I get 95 rows full of commas. Screen:

How everyone, I have the requirement to merge two or more rown in a grid. An example is shown below: Col A Col B Col C 1 2 ab cd 7 9 yz If the value of col A and col B are same for two rows and Col C value is different then both rows for col A and Col B should be merged. Thank You