Community

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

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.