New to Appian

Hi Everyone, Can anyone please explain me how can I get values from database in a dropdown field in a grid layout. Thank You

Good morning everybody, I have created an summary view interface, which has two RI (solicitud and expenses). So when i call the interface in the record type: , When I clicked in the list view, I obtained this error An Error Has Occurred An error occurred while retrieving the data for "AT Expense Report". Details: Expression evaluation error: Keyword and non-keyword arguments must not be mixed. Used in: recordbodywrapper. (APNX-1-4205-003) When I changed the setting (second screenshot) in the list view, I obtained this error  Error Evaluating UI Expression Expression evaluation error [evaluation ID = 7e51d:51052] in rule 'copypruebaexpenseinfo' : Could not cast from AT Expense Report to AT Expense Information. Details: AT Expense Report cannot be cast to AT Expense Information (APNX-1-4198-000) Could you help me, please and explaining me what is happening? Best regards,

seems I almost there, the problem I found is that the value i supposed to be saved for a!query is not the standard form. What should be the correct one? a!save(target:ri!userrole.USER_ID, value:cast(type!Integer, a!queryEntity( entity:cons!KONE_Development_userrole_Constant, fetchTotalCount:true, query:a!query( selection: a!querySelection( columns: { a!queryColumn( field: "USER_ID" ) } ), filter:a!queryFilter( field:"NAME",operator:"=", value:ri!userinputsheet.kone_user_name, applyWhen:not(isnull(ri!userinputsheet.KONE_user_name)) ), pagingInfo:a!pagingInfo( startIndex: 1, batchSize: 50 ) ) ).data.USER_ID) ),

Hi Everyone, Can anyone please tell me how can I retrieve the pdf files as a link in the interface, based on the name coming from database table? The document is stored in the folder in appian. Thank You

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.