New to Appian

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

Hi, I am trying to access different parts of the Appian IDP but I see only the configure tab.   Going through the documentation at https://docs.appian.com/suite/help/22.2/idp-1.6/groups-reference-page.html I got myself included in all the groups this document is asking for. I am a member of DU Administrator. So net net I am a member of  what am I missing ?? Any help will be appreciated thanks jaideep

Hi, We have pre-prod environment n prod environment. We have a prod deployment near by. Deployment is manual85 not yet automated. Phase 1 is already running successfully in live. Now phase 2 is gng to live.. I am planning to deploy whole application from preprod to live. my application contains groups aswell. if I take groups from preprod will the users also be effected in prod. Users also will be deployed

In this Enterprise Architecture Diagram clearly shown that we can deploy our own Application on Cloud. But I Don't know how to configure and connect . pls suggest some Blogs or Documentation for this issue.

All I really want to do is be able to create a filter on a read-only grid but it appears to only work on a filter associated with the record type.

Hi!  Is there any way to have 2 different y-axis for the same plot? May be a plugin? For example: one y for gdp, one y for population, while they have in common x (year).

Hi, I have am read only grid where I have enabled search functionality. The Search text field is giving some default text. Can someone let me know how to customize that text. Basically, I would like provide a text which is more meaningful. Thanks

Hi, I am trying to convert the text which is entering into the textField into a upper case and trying to store into a ruleInput. But, it is not working as expected. I am attaching the code here to get some experts advise. Thanks. a!localVariables( { a!columnsLayout( columns: a!columnLayout( contents: a!textField( label: "Name:", value: upper(ri!name), saveInto: upper(ri!name) ) ) ) } )

Hi, I would like to know if there a way we can switch on Audit to generate audit log for each action in Appian. Please advise if we have to do this activity manually. Any advises are highly appreciate. Thank you.