Community

Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error: An error occurred while executing a smart service: An error occurred while trying to write to the data store [KONE_User_Development_Database]. No values have been written. Details: could not insert: [USERROLEDT2804] (APNX-1-4208-004) I make a interface for new user to register, but once new user finish his information fill in and hit submit, the first time is good, all data inserted to back end without problem. However,if he click twice in submit button, always jump out report error as above.

as title, i can i access to tomcat-stdOut.log

Hi All, can anyone please help me how can I implement email messages functionality on approval of tasks. How to create email template in appian? Thank you

a!localVariables( local!rule:rule!KONE_Development_userinputsheet_Rule(), 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!noFiltersApplied: all(fn!isnull, {ri!userinputsheet.KONE_user_name}), local!searchValue, a!sectionLayout( label:"Update Info", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Username", value: local!searchValue, saveInto: {local!searchValue }, refreshAfter: "KEYPRESS" ), a!buttonLayout( primaryButtons: { a!buttonWidget( label: "SEARCH", saveInto: { local!searchValue, },

How i can enable the field of a particular Question   Based on the UserLogged In  appian. please help 

Hi everyone, How can I apply condition of grid column so the only particular logged in user can see the specific rows in the grid layout. Thank You

Hello everybody, I need to create a view using two record type (expense and expenseInfo) that have a field in common (PK and FK) I have created a query that returns all the information from the two tables using the relation with the id (AT Expense Information) and the idexpensedet (AT Expense). In the first part I need to show the requester information (That one is ok.) In the second part of my view I need to populate a Grid ONly Read with all the expense related to the requester. And I don't no know how to do this, I have tried to test in the grid Only Read (data source: using RULE (call the expression and testing ) and EXPRESSION (with this code) ) it is not working  a!queryRecordType( recordType: 'recordType!{854cabc5-d20e-4764-95c5-5e0485f3715f}AT Expense Report', filters: a!queryFilter( field: 'recordType!{854cabc5-d20e-4764-95c5-5e0485f3715f}AT Expense Report.fields.{277d529f-c83c-47ea-a269-f1eec6e4a2d3}idexpensedet', operator: "=", value: ri!id )

a!forEach( items: local!rule, expression:a!gridRowLayout( contents: { a!textField( label: "Username", labelPosition: "ABOVE", value:fv!item.KONE_user_name, saveInto: { a!save(target:fv!item.KONE_user_name,value:save!value), a!save(target:ri!userinputsheet.KONE_user_name,value:save!value), a!save(target:ri!userrole.NAME,value:save!value), a!save(target:ri!userrole.USER_ID,value:a!localVariables(local!value:fv!item.KONE_user_name, a!forEach(items:rule!KONE_Development_Username_UserId(),expression:if(local!value=fv!item.username,fv!item.userid,{})) )), }, refreshAfter: "UNFOCUS",

Hi everyone I'm newbie to appian I am planning to take the Appian Associate Developer exam next week. I looked up the document about the test information on the site, but I'm still confused. Help me if there are people who took the reorganized test. 1. I'd like you to tell me what's usually covered in the test.2. What courses should I take from appian academy in preparation for the exam?3. What's the exact passing score on the test?4. Are there any useful tips for preparing for the exam?5. Can I get an example question about the test? Thank you

for exmaple: value:fv!item.value, saveinto:{a!save(target:ri!value,value:a!forEach( items:local!rule, expression:if( outside fv!item.value=inside fv!item.value,null,null ), Then how i express? ))}

a!localVariables( local!rule:rule!KONE_Development_userinputsheet_Rule(), local!noFiltersApplied: all(fn!isnull, {ri!userinputsheet.KONE_user_name}), a!sectionLayout( label:"Update Info", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Username", value: ri!userinputsheet.KONE_user_name, saveInto: ri!userinputsheet.KONE_user_name, refreshAfter: "KEYPRESS" ), a!buttonLayout( primaryButtons: { a!buttonWidget( label: "SEARCH", saveInto: { ri!userinputsheet.KONE_user_name }, disabled: local!noFiltersApplied ) } ), a!gridLayout( label: "Editable Grid", labelPosition: "ABOV

as title, i just want my editable grid shows up only 15 rows and able to go next page with arrow.

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: { a!save(target:ri!userinputsheet.kone_user_name, value:save!value), a!save(target:ri!userrole.NAME, value:save!value), }, 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",

Hi Everyone, Can anyone please tell me how to use a!writeToMultipleDataStoreEntities function. I am new to appian and want to store the updated data from interface into multiple tables.

Hello, I am following step by step 4. On page 13, testing the add vehicle form with the data in the tutorial image, I have seen that: - The first time I click submit the form, the value of "lastUpdated" is updated, but "nextServiceDate" is not updated. - If I submit the form again, the value of "nextServiceDate" is updated. Is this behaviour correct or should both fields be updated when I click submit the first time? The "Submit" button configuration I have is: a!buttonWidget( label: "Submit", value: if( isnull(ri!vehicle.lastUpdated), "", rule!VFM_CalculateNextServiceDate( vehicleType: ri!vehicle.category, dateUpdated: ri!vehicle.lastUpdated ) ), saveInto: { ri!vehicle.nextServiceDate, a!save(ri!vehicle.lastUpdated,now()) }, submit: true, style: "PRIMARY" ) Thanks for your help. Best regards.

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)) ), }