Community

i have 2 level approval , first team 'A' has to approve and after they approves  it should go to team 'B' . If i'm on same page it shows "team b" form . if i comeback to the same request  again after sometime it starts from "team A"  form again instead of "team b" form

In bulk search, like we searched 3id's (lets say 8,2,6) in one bulk search paragraph. Now in bulk update function, order of selected searched id's should be same like ( 8,2,6) same as bulk search. It should not be in any other order like (2,6,8) ,(8,6,2) or (6,2,8) etc. So how can we achieve this. Please suggest

i want an interface as "TEST 1 APPROVAL" with  fields name, section and class with cancel,approve and reject button .once we approve another interface with same fields must display with title "Test 2 approval" 

I'm a newbie to Appian, looking for the documentation on initial steps for creating the promote-to-production landscape.  )This is assuming an "enterprise application" architecture (think: multiple users creating POs and then a Purchasing Dept. making buys), and not a mobile app architecture where we have to deploy an applet to multiple devices.) I have found the documentation on "Deployments" and "Packages," but not the precursor documentation on how to set up the landscape, declare where Dev is and where Test is and where Prod is, how to add a Training environment into the landscape if desired, how to set up Primary Dev and HotFix Dev, etc., such that a Deployment can move applications and objects from a Source to Target. Tried searching on "landscape" but that took me to portrait-vs-landscape in document orientation.  Other ideas on what search terms to use, or can anyone point me directly to the documentation?

Hello: I am trying to use a!writeRecords() to write a list of records (of the same recordType) to the DB and it is writing a column of one-field to each field in the DB (images below).  The debugging section shows the values before I click on 'Submit'.  The second image is the data in the DB (Data Preview screen). My understanding was that a!writeRecords smart service would insert two records - one for each row of information.  Obviously, I am not correct in my understanding of the service.   How do I get each row to be written as a record in the DB? As always, thanks for the help! a!localVariables( local!userSelection: null(), local!ListOfOptions: rule!FST_getGuidelines(), local!ListOfChoiceValues: enumerate(length(local!ListOfOptions)) + 1, local!ListOfCategories: {}, a!formLayout( label: "Category Management", contents: { rule!FST_UserSelection( ListOfOptions: local!ListOfOptions, ListOfChoiceValues: local

My needs is to check if other user is standing on page, so in this case i cannot edit data on it. Is there some functionality to check that the record summary page is in use right now? Thanks for help!

I am trying to use a!writeToDataStoreEntity   to write to into a database , if one on the fields is a (foreign key) which is an auto-generated primary key of another table in the "same interface ", how can i pass it to the other table when it  hasn't been generated yet?   

Hi, in my interface I have two buttons, "save" and "send as signature", the "save" button saves the filled and unfilled fields but the "send as signature" button must ensure that all the input fields are completed before making a recording. what solution can I use? THANKS !

Hi,  After the script ran, i found Error in execuation log and report does not gets generated. Thanks in advance.

while crteating a constant to the all users group , after naming that constant with the name it is showing like that "name already exists"   i need solution for step 4 

I have two dates ex. 03/05/2021 & 03/10/2021, I am trying to get all dates within this range. (i.e  03/05/2021, 03/06/2021, 03/07/2021, 03/08/2021, 03/09/2021, 03/10/2021). Please help me with it.

HI, Thanks for all the details that i get here. Iam new to Appian tool ( 1 day ) , i would like to understand if appian is available in china region. I dont see any appian related services in the china marketplace. Please help me understand if appian is available in china region. If it is not available, what are the other alternates that i can use in China region as a low code hyper automation tool. Thanks for all the details 

Hey everyone! I am writing an expression rule to count the rows in multiple task tables so I the user can have the total number of tasks they need to complete on the label for one of the View pages on the record. I have been using a!queryProcessAnayltics().totalcount and I have modeled each of the 8 off of the expression mode code for each of the tables. Unfortunatly I keep receiving 0's when I'm expecting a few on them to have values >=1. Is thre anything right off the bat wrong with my code? Do I need to wrap the code in anything to get the results I want? This is essentially what my code looks like. (I have a rule input called prjId (text value). a!localVariables( local!name1: a!queryProcessAnayltics(                      report: REPORT_NAME,                      contectProcessModel: {LIST_OF_PMS},                 &nbsp

Does Process deadline triggers escalation?

I am new to Appian and I want to understand the process for achieving my goal of building a website within the platform. I would like for users to be able to sign up, sign in, and add their information to a database. They will also be uploading documents, and I need to extract information from these documents and save it in the database. I am trying to make this a community accessible site. However, I am currently stuck as I am unable to determine if my sign-up and sign-in functions are working correctly, as only community users are allowed to log in. Can anyone suggest some resources or tutorials that I can use to learn and achieve my goal, as I am having trouble finding a comprehensive guide on how to create a website and deploy it to a domain where users can sign in and log in? Also, I would appreciate any information on using zonal OCR for document reading. Thank you in advance for your help.

Q1.  what is difference between null, empty,blank Q2. can I use for  a!isnullorEmpty() for removing/checking null,empty and blank or apply different functions for checking them.

a!localVariables( local!priceId: http!request.queryParameters.pgenId, local!docId: http!request.queryParameters.docId, local!entities: a!forEach( items: local!pgenId, expression: a!queryEntity( entity: cons!DS_ENTITY1, query: a!query( logicalExpression: { a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "priceid", operator: "=", value: local!priceId ), } ) }, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50) ), fetchTotalCount: true ).data, a!queryEntity( entity: cons!DS_Entity2, query: a!query( logicalExpression: { a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "docId", operator: "=", value: local!

Hi All, I have a query in export dse to excel. How many characters or word count can be exported in one column of excel? Thanks!

I have a local variable that holds an array. When I pass this local variable to a a!forEach items, it does not loop. When I take the array value and paste it directly into items, it works. Why is it not working when I pass in the array from the local variable? a!localVariables( local!groups: { cons!AX_ALL_USERS, cons!AX_MECHANICS, cons!AX_REGISTRARS, cons!AX_SUPERVISORS, cons!AX_ADMINISTRATORS_POINTER }, { a!sectionLayout( label: "Groups for " & loggedInUser(), contents: { a!gridField( label: "", labelPosition: "ABOVE", data: todatasubset(a!forEach( /* WORKS */ items: { cons!AX_ALL_USERS, cons!AX_MECHANICS, cons!AX_REGISTRARS, cons!AX_SUPERVISORS, cons!AX_ADMINISTRATORS_POINTER }, /* DOES NOT WORK */ /*items: local!groups,*/ expression: { {

Hi Could anyone help me to know how can i access the below "backup" Schema in appian cdt/record , whenever I create cdt/ record type I can only see tables from "Appian" schema, cannot access "Backup" Schema

When applying an edit action to a dropdown field. Due to the lack of an enumeration data type, the dropdown field may inadvertently transform into a text field when an edit action is applied.

a!gridField( data:local!data, columns: { a!gridColumn( label: index(local!labels, "id", null), sortField: "id", value: fv!row.id ), a!gridColumn( label: index(local!labels, "createdBy", null), sortField: "createdBy", value: fv!row.createdBy ), }, pagingSaveInto: local!pagingInfo, selectable: true, selectionValue: ri!idDoc, selectionSaveInto: ri!idDoc )

if(a!isNullOrEmpty(fv!row['recordType!AX Vehicle.fields.image']) ,a!EXAMPLE_DOCUMENT_IMAGE(), fv!row['recordType!AX Vehicle.fields.image']) Hello AppiansI am new to Appian and following the Appian developer learning path I faced an error in "write a maintenance record" of the process model, tried to solve it but in the end, I deleted the project and started a new one and now I am facing this error "Error Evaluating UI Expression Expression evaluation error at function a!gridField [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 51]: Invalid Content ID" this error shows up once I add a new Document Image column in the list of the vehicle record type and for some reason, the Acme Auto Solution Application already built has the same error So I guess the problem is not from the expression or the record

Hi All, I am getting this error while adding new column record the table. #1452 - Cannot add or update a child row: a foreign key constraint fails (`Appian`.`ISR_j_Product_TherapeuticArea`, CONSTRAINT `j_taProduct_fk` FOREIGN KEY (`therapeuticAreaId`) REFERENCES `ISR_TherapeuticArea` (`therapeuticAreaId`) ON DELETE NO ACTION ON UPDATE NO ) Could you please let me know how can we resolve this, 

Hi! I´m using an enviroment from a partner to practise. When I want to start with the exercise of chapter "Design appian Records, part 1" ask me to look for "AS_Vehicle" in the application (topic 4). I don´t know why in my environment I don´t have it. Could you tell me how fix this? or can I import this from some place? Thanks!