New to Appian

Any body know why I already add another column in the table from cloud database from backend, and I reconnect it in the datastore, but somehow no matter how I readd this table in the interface of rule input, that last column I just add just not appear, so i can't add information into it.

As title

Hi, I have an interface where I have a fileupload component in designer mode the upload button is active and works perfectly fine, how ever If I bind this interface on site it turns disabled automatically. Please help me with it.

as title, how can i add data to multiple table at same time by using a!writeToDataStoreEntity, give me a example code, thank you

a!localVariables( local!allRole:rule!KONE_Development_ROLE(), local!allLanguage:rule!KONE_Development_LANGUAGE(), local!allBranch:rule!KONE_Development_BRANCH(), local!allRegion:rule!KONE_Development_REGION(), a!formLayout( contents: { a!textField( label: "Username", value: {ri!userinputsheet.kone_user_name}, saveInto: {ri!userinputsheet.kone_user_name, a!save(ri!userrole.NAME,ri!userinputsheet.kone_user_name) }, required: true ), a!textField( label: "firstName", value: {ri!userinputsheet.FIRST_NAME}, saveInto: {ri!userinputsheet.FIRST_NAME}, required: true ), a!textField( label: "LastName", value: {ri!userinputsheet.LAST_NAME}, saveInto: {ri!userinputsheet.LAST_NAME}, required: true ), a!textField( label: "Email", value: {ri!userinputsheet.Email}, saveInto: { a!save

Hi Everyone, Can anyone please tell me, how can I implement that only manager role can edit the data from the front end in the application. I have craeted a edit button in the application but do not know how to implement that only managers role can edit.

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?