New to Appian

a!localVariables( /* * All of these local variables could be combined into the employee CDT and passed into * a process model via a rule input */ local!allRole:rule!KONE_Development_ROLE(), local!allLanguage:rule!KONE_Development_LANGUAGE(), local!allBranch:rule!KONE_Development_BRANCH(), local!allRegion:rule!KONE_Development_REGION(), /* * local!isFutureHire is a placeholder varaiable used to set the validation group trigger. * When isFutureHire is set to true, a user can skip phone number and start date. */ a!formLayout( contents: { a!textField( label: "Username", value: {ri!userinputsheet.kone_user_name}, saveInto: { a!saveInto(ri!userinputsheet.kone_user_name,ri!userinputsheet.kone_user_name), a!saveInto(ri!userrole.NAME,ri!userinputsheet.kone_user_name), }, required: true ), a!textField( label: "firstName", value: {ri!userinputsheet.FIRST_NAME},

a!dropdownField( label: "Role", placeholder: "All Roles", choiceLabels: local!allRoles, choiceValues: local!allRoles, value: local!Role, saveInto: local!Role, ), The error report:A dropdown component [label="Role"] has an invalid value for "choiceValues". Choice values cannot be null. local!allRole:local!allRoles:rule!userinputsheet_Role() which is as below: a!queryEntity( entity: cons!user_input_sheet, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 50, ), aggregation:a!queryAggregation( aggregationcolumns:{ a!queryAggregationColumn(field:"ROLE",isGrouping:true), } ), filter:a!queryFilter( field:"ROLE", operator:"not null", ) ), ).data.ROLE

error as title

a!localVariables( local!insert:false, local!update:false, a!formLayout( label: "Username", contents: { a!textField( label: "username", labelPosition: if( ri!readOnly, "ADJACENT", "ABOVE" ), value: ri!username.username, saveInto: ri!username.username, refreshAfter: "UNFOCUS", validations: { if( a!queryEntity( entity: cons!usernameConstant, query: a!query( fetchTotalCount: true, pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1 ), logicalexpression: a!queryLogicalExpression( operator:"OR", filters: { a!queryFilter( field: "username", operator: "=", value:(ri!username.username), applyWhen:not(isnull(ri!username.username)) ), }

It report error with this which have been hinder me for couple days. Interface Definition: Expression evaluation error at function a!queryLogicalExpression [line 25]: The a!queryFilter function has an invalid value for the "value" parameter. When the value of "operator" is "=" "value" must not be null or empty. a!localVariables( a!formLayout( label: "Username", contents: { a!textField( label: "username", labelPosition: if( ri!readOnly, "ADJACENT", "ABOVE" ), value: ri!username.username, saveInto: ri!username.username, refreshAfter: "UNFOCUS", validations: { if( a!queryEntity( entity: cons!usernameConstant, query: a!query( fetchTotalCount: true, pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1 ), logicalexpression: a!queryLogicalExpression(

Sorry, i keep looking for ways to not let user insert duplicate username to the database, but always fails, i know primary key as username can't be repeatedly insert in to the database by its service, but i just want to give user a hint, and tell him can't register same username others used before and let it not to update to the back end database by its smartservice, then how can I do? { label: "Insert", saveInto:( a!writeToDataStoreEntity( dataStoreEntity: cons!usernameConstant, valueToStore:(ri!username) ), ), submit: if(ri!username.username in local!rule.username ,false,true), style: "PRIMARY", }      OR label: "Insert", saveInto:( if( ri!username.username in local!rule.username, {}, a!writeToDataStoreEntity( dataStoreEntity: cons!usernameConstant, valueToStore:(ri!username) ) ), ), submit: true, style: "PRIMARY",

I'm trying to export my sample application built in Appian Community trial version. System not showing any error message and not exporting app as well. Export option in Application view is disabled. Is there any option to export the application please suggest.

I am trying to pass a value from one interface on button/richtext click to another interface rule input, please help.

Off to a great start. I cannot find the site navigator icon on the website... Clicked for around 25 minutes. Perhaps add a link for the idiot guide?

Hi, In My Generated Text output file, am getting Blank rows in between, but in actual text output file those blank rows were not there. Can anyone help me with proper code to remove those Blank rows in Text output file.

#1452 - Cannot add or update a child row: a foreign key constraint fails (`Appian`.`#sql-alter-34ce-15086d9`, CONSTRAINT `table1_ibfk_2` FOREIGN KEY (`first_id`) REFERENCES `table2` (`first_id`)) What does this error mean?

I want to do some typecasting in data store and save it in new column . For example I import  the  excel and it read the date as varchar,if I change its data type as date then the value shows as 00-00-0000 , I want to do typecast for entire column and save it in a new column so that i will use the latestcolumn for query entity. Please help me on this

I have requested for trial account access three days prior but still not received trial account login details

How to write trigger in appian database? Any KB?

Hi All, I am creating the relationship between two tables but system does not allow me and throws the error "1452 - Cannot add or update a child row: a foreign key constraint fails ". Do I need to update in the CDTs for these tables as the CDTs are already created for these tables. 

Hi, Can anyone please help me how to import the excel in appian database without using database.

Can anyone please tell me how can I link tables in Appian so that data flows from one table to another using primary foreign key relationship?

Is that possible to create multiple CDT from a single database table ?

Hello, I am currently building my application.  However, There is just a certain bit of functionality in my process model that's too data manipulation heavy, and I would like to run it on am external web server.  I can write code that can handle this for me in Python, and I can set up an api for it on a web server.  Now all I need is for Appian to call that API every time I need to run that ETL functionality in my process model. is there a way for Appian to call an external web API from a process model? 

Hello All, I have a requirement that status need to be updated until following Monday. We will upload spread sheet on Every Monday or Tuesday or Wednesday. While uploading it will check the date(it is a column in spread sheet) current date and previous date records will be updated to New Status. Now the requirement is it should be validated previous dates, current date and until following Monday records. We are able to achieve previous dates and current date. How to get following Monday date as we are not sure about the file upload week date. For example: On 08.12.2021 If I upload the file it should be validated on or before 08.12.2021 and until following Monday(08.16.2021).   On 08.11.2021 If I upload the file it should be validated on or before 08.11.2021 and until following Monday(08.16.2021) Please Suggest. Thank you

Hello Appian, From the appian cerification FAQ link, https://community.appian.com/learn/certifications/p/faqs  It says that "To maintain your certification, we require that you consume the quarterly release training and complete a short assessment." Where can I find the Quarterly release training? Is the "Release Showcase training" the right one? https://academy.appian.com/#/catalog/e17ac3d6-142b-418a-a4d6-1a23386be533  Also, do I get a message or alert before my certification gets expired? 

Hi, I am using the send email smart service. I let the user write the body of the email in a paragraph field, save body text in a text variable, and in setup>Message Body field, I use an expression to fill the body with the text variable.  However, the email gets sent with no formatting. At least, I want to capture the "new line" breaks that the user enters in the paragraph field. I would appreciate your help.

My use case: "Implement a related action. The related action will send an email. The list of recipients is inputted by the user. The subject line is inputted by the user. The body text is inputted by the user. These user inputs are captured after submitting a form interface"  I am using the "Send E-Mail" smart service. I am passing recipientsList, emailBody, and subjectLine text values as inputs to the process model.  How can I use these process variables in the Send E-Mail smart service node? I can't seem to figure this out!

Is there a way we can use xpath expressions on Appian Selenium api without initializing webdriver class?

I have a table called reference amenity in which I have manually mapped amenityId and amenity types, I want to call this table using the foreign key field of another table called amenity table and want to store the amenity Type.By using the expression rule I have called the reference table but I want to store the amenity types  using the foreign key  can anyone suggest to me how to do this. Reference table: ammenity table:from this table I want to call the ammenity type  ...