title as above,
code as:
a!save(target:ri!userinputsheet.KONE_user_name,value:fv!item.KONE_user_name), a!save(target:ri!userinputsheet.FIRST_NAME,value:fv!item.FIRST_NAME), a!save(target:ri!userinputsheet.LAST_NAME,value:fv!item.LAST_NAME), a!save(target:ri!userinputsheet.Email,value:fv!item.Email), a!save(target:ri!userinputsheet.Role,value:fv!item.Role), a!save(target:ri!userinputsheet.Branch,value:fv!item.Branch), a!save(target:ri!userinputsheet.Region,value:fv!item.Region), a!save(target:ri!userinputsheet.Manager_role,value:fv!item.Manager_role), a!save(target:ri!userinputsheet.Telephone_number,value:fv!item.Telephone_number), a!save(target:ri!userinputsheet.CE_LEVEL,value:fv!item.CE_LEVEL), a!save(target:ri!userinputsheet.Active,value:fv!item.Active), a!save(target:ri!userinputsheet.Language,value:fv!item.Language), a!save(target:ri!userinputsheet.Exceptional_case_library_view_right,value:fv!item.Exceptional_case_library_view_right), a!save(target:ri!userinputsheet.updateTime,value:now()), a!writeToMultipleDataStoreEntities( valuesToStore: { a!entityData(entity: cons!KONE_Development_userinputsheet_Constant, data: ri!userinputsheet), a!entityData(entity: cons!KONE_Development_userrole_Constant, data: ri!userrole) } )
what is the problem?
Discussion posts and replies are publicly visible
Can you try to comment the Write to Data store entity code and try, if is works, it means there is something wrong with DSE. So we can check there.
still report
a!save( target: ri!userinputsheet.Language, value: if( isnull(ri!userinputsheet.Language), "Chinese", ri!userinputsheet.Language ) ),
Try above code on save into for language.
i promise i don't have null value in the text blank. Because i always let it shows up database value by expression, i show you my overall code.
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!newGrid:'type!{urn:com:appian:types}user_input_sheet'(), local!noFiltersApplied: all(fn!isnull, {ri!userinputsheet.KONE_user_name, ri!userinputsheet.FIRST_NAME, ri!userinputsheet.LAST_NAME, ri!userinputsheet.Email, ri!userinputsheet.Role, ri!userinputsheet.Branch,ri!userinputsheet.Region,ri!userinputsheet.Manager_role, ri!userinputsheet.Language,ri!userinputsheet.CE_LEVEL,ri!userinputsheet.Telephone_number, ri!userinputsheet.Exceptional_case_library_view_right, }), local!searchValue, a!sectionLayout( label:"Update Info", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "USERNAME", labelPosition: "ABOVE", value:local!searchValue, saveInto: local!searchValue, refreshAfter: "KEYPRESS", validations: {} ), a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Clear", saveInto:a!save(local!searchValue,null()), style: "NORMAL" ) }, align: "START" ) } ) } ), if( isnull(local!searchValue), a!gridLayout( label: "Editable Grid", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell( label: "Username" ), a!gridLayoutHeaderCell( label: "First Name" ), a!gridLayoutHeaderCell( label: "Last Name" ), a!gridLayoutHeaderCell( label: "Email" ), a!gridLayoutHeaderCell( label: "Role" ), a!gridLayoutHeaderCell( label: "Branch" ), a!gridLayoutHeaderCell( label: "Region" ), a!gridLayoutHeaderCell( label: "Manager_role" ), a!gridLayoutHeaderCell( label: "Language" ), a!gridLayoutHeaderCell( label: "CE_LEVEL" ), a!gridLayoutHeaderCell( label: "Telephone Number" ), a!gridLayoutHeaderCell( label: "Exceptional Case Library View Right" ), a!gridLayoutHeaderCell( label: "Update" ), a!gridLayoutHeaderCell( label: "Deactivate" ), a!gridLayoutHeaderCell( label: "Inactivate" ) }, columnConfigs: { a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ) }, rows: { a!forEach( items: rule!KONE_Development_updateQueryAllPeople(), expression:a!localVariables( local!userinputsheet:fv!item, a!forEach( items:local!rule, expression:if(fv!item.KONE_user_name=local!userinputsheet.KONE_user_name, if(fv!item.updateTime=local!userinputsheet.updateTime,a!gridRowLayout( contents: { a!textField( label: "Username", labelPosition: "ABOVE", value:fv!item.KONE_user_name, saveInto: fv!item.KONE_user_name, refreshAfter: "UNFOCUS", readOnly: true, validations: {} ), a!textField( label: "First Name", labelPosition: "ABOVE", value:fv!item.FIRST_NAME, saveInto: { fv!item.FIRST_NAME }, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Last Name", labelPosition: "ABOVE", value:fv!item.LAST_NAME, saveInto: fv!item.LAST_NAME, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Email", labelPosition: "ABOVE", value:fv!item.Email, saveInto: fv!item.Email, refreshAfter: "UNFOCUS", validations: {} ), a!dropdownField( label: "Role", labelPosition: "ABOVE", choiceLabels:reject(fn!isnull,local!allRole), choiceValues:reject(fn!isnull,local!allRole), value:fv!item.Role, saveInto: fv!item.Role, validations: {} ), a!dropdownField( label: "Branch", labelPosition: "ABOVE", choiceLabels:reject(fn!isnull,local!allBranch), choiceValues:reject(fn!isnull,local!allBranch), value:fv!item.Branch, saveInto: fv!item.Branch, validations: {} ), a!dropdownField( label: "Region", labelPosition: "ABOVE", choiceLabels:reject(fn!isnull,local!allRegion), choiceValues:reject(fn!isnull,local!allRegion), value:fv!item.Region, saveInto: fv!item.Region, validations: {} ), a!dropdownField( label: "Manager_role", labelPosition: "ABOVE", choiceLabels:reject(fn!isnull,local!allRole), choiceValues:reject(fn!isnull,local!allRole), value:fv!item.Manager_role, saveInto: fv!item.Manager_role, validations: {} ), a!dropdownField( label: "Language", labelPosition: "ABOVE", choiceLabels:reject(fn!isnull,local!allLanguage), choiceValues:reject(fn!isnull,local!allLanguage), value:fv!item.Language, saveInto: fv!item.Language, validations: {} ), a!textField( label: "CE_LEVEL", labelPosition: "ABOVE", value:fv!item.CE_LEVEL, saveInto: fv!item.CE_LEVEL, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Telephone Number", labelPosition: "ABOVE", value:fv!item.Telephone_number, saveInto: fv!item.Telephone_number, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Exceptional Case Library View Right", labelPosition: "ABOVE", value:fv!item.Exceptional_case_library_view_right, saveInto:fv!item.Exceptional_case_library_view_right, refreshAfter: "UNFOCUS", validations: {} ), a!richTextDisplayField( label:"Update", labelPosition:"ABOVE", value:{ a!richTextIcon( icon:"check", link:a!dynamicLink( saveInto:{ a!save( target:ri!userrole.USER_ID, value:rule!KONE_Development_UserId(fv!item.KONE_user_name) ), a!save(target:ri!userinputsheet.Role,value:fv!item.Role), a!save(target:ri!userrole.ROLE,value:fv!item.Role), a!save(target:ri!userinputsheet.KONE_user_name,value:fv!item.KONE_user_name), a!save(target:ri!userrole.NAME,value:fv!item.KONE_user_name), 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,{})) )), a!save(target:ri!userinputsheet.FIRST_NAME,value:fv!item.FIRST_NAME), a!save(target:ri!userinputsheet.LAST_NAME,value:fv!item.LAST_NAME), a!save(target:ri!userinputsheet.Email, value:fv!item.Email), a!save(target:ri!userrole.EMAIL,value:fv!item.Email), a!save( target:ri!userrole.ROLE_ID, value: a!forEach (items:rule!KONE_Development_Role_RoleId(), expression:if(fv!item.Role=ri!userinputsheet.Role,fv!item.Role_Id,{}) )), a!save( target:ri!userrole.ROLE, value: fv!item.Role), a!save(target:ri!userinputsheet.Active,value:fv!item.Active), a!save(target:ri!userrole.PHASE_ID, value:a!forEach (items:rule!KONE_Development_Role_RoleId(), expression:if(fv!item.Role=ri!userinputsheet.Role,fv!item.Role_Id,{}) )), a!save(target:ri!userinputsheet.Branch,value:fv!item.Branch), a!save(target:ri!userrole.BRANCH,value:fv!item.Branch), a!save(target:ri!userrole.BRANCH_ID, value:a!forEach (items:rule!KONE_Development_Branch_BranchId(), expression:if(fv!item.Branch=ri!userinputsheet.Branch,fv!item.Branch_Id,{}) )), a!save(target:ri!userinputsheet.Region,value:fv!item.Region), a!save(target:ri!userrole.REGION,value:fv!item.Region), a!save(target:ri!userrole.REGION_ID, value:a!forEach (items:rule!KONE_Development_Region_RegionId(), expression:if(fv!item.Region=ri!userinputsheet.Region,fv!item.Region_Id,{}) )), a!save(target:ri!userinputsheet.Manager_role,value:fv!item.Manager_role), a!save(target:ri!userinputsheet.Language,value:fv!item.Language), a!save(target:ri!userrole.LANG_ID, value:a!forEach (items:rule!KONE_Development_Language_LanguageId(), expression:if(fv!item.Language=ri!userinputsheet.Language,fv!item.Language_Id,{}) )), a!save(target:ri!userinputsheet.CE_LEVEL,value:fv!item.CE_LEVEL), a!save(target:ri!userrole.LEVEL,value:fv!item.CE_LEVEL), a!save(target:ri!userinputsheet.Telephone_number,value:fv!item.Telephone_number), a!save(target:ri!userrole.TELEPHONE_NUMBER,value:fv!item.Telephone_number), a!save(target:ri!userinputsheet.Exceptional_case_library_view_right,value:fv!item.Exceptional_case_library_view_right), a!save(target:ri!userrole.IS_EXCEPTION,value:0), a!save(target:ri!userrole.ACTIVE,value:fv!item.Active), a!save(target:ri!userinputsheet.updateTime,value:now()), a!writeToMultipleDataStoreEntities( valuesToStore: { a!entityData(entity: cons!KONE_Development_userinputsheet_Constant, data: ri!userinputsheet), a!entityData(entity: cons!KONE_Development_userrole_Constant, data: ri!userrole) } ), } ), linkStyle:"STANDALONE", color:"POSITIVE" ) } ), a!richTextDisplayField( label:"Deactivate", labelPosition:"ABOVE", value:{ a!richTextIcon( icon:"arrow-down", link:a!dynamicLink( saveInto:{ a!save(target:ri!userrole.ROLE,value:fv!item.Role), a!save(target:ri!userinputsheet.KONE_user_name,value:fv!item.KONE_user_name), a!save(target:ri!userrole.NAME,value:fv!item.KONE_user_name), a!save( target:ri!userrole.USER_ID, value:rule!KONE_Development_UserId(fv!item.KONE_user_name) ), a!save(target:ri!userinputsheet.FIRST_NAME,value:fv!item.FIRST_NAME), a!save(target:ri!userinputsheet.LAST_NAME,value:fv!item.LAST_NAME), a!save(target:ri!userinputsheet.Email, value:fv!item.Email), a!save(target:ri!userrole.EMAIL,value:fv!item.Email), a!save(target:ri!userinputsheet.Role,value:fv!item.Role), a!save( target:ri!userrole.ROLE_ID, value: a!forEach (items:rule!KONE_Development_Role_RoleId(), expression:if(fv!item.Role=ri!userinputsheet.Role,fv!item.Role_Id,{}) )), a!save( target:ri!userrole.USER_ID, value:rule!KONE_Development_UserId(ri!userinputsheet.KONE_user_name) ), a!save( target:ri!userrole.ROLE, value: fv!item.Role), a!save(target:ri!userrole.PHASE_ID, value:a!forEach (items:rule!KONE_Development_Role_RoleId(), expression:if(fv!item.Role=ri!userinputsheet.Role,fv!item.Role_Id,{}) )), a!save(target:ri!userinputsheet.Branch,value:fv!item.Branch), a!save(target:ri!userrole.BRANCH,value:fv!item.Branch), a!save(target:ri!userrole.BRANCH_ID, value:a!forEach (items:rule!KONE_Development_Branch_BranchId(), expression:if(fv!item.Branch=ri!userinputsheet.Branch,fv!item.Branch_Id,{}) )), a!save(target:ri!userinputsheet.Region,value:fv!item.Region), a!save(target:ri!userrole.REGION,value:fv!item.Region), a!save(target:ri!userrole.REGION_ID, value:a!forEach (items:rule!KONE_Development_Region_RegionId(), expression:if(fv!item.Region=ri!userinputsheet.Region,fv!item.Region_Id,{}) )), a!save(target:ri!userinputsheet.Manager_role,value:fv!item.Manager_role), a!save(target:ri!userinputsheet.Language,value:fv!item.Language), a!save(target:ri!userrole.LANG_ID, value:a!forEach (items:rule!KONE_Development_Language_LanguageId(), expression:if(fv!item.Language=ri!userinputsheet.Language,fv!item.Language_Id,{}) )), a!save(target:ri!userinputsheet.CE_LEVEL,value:fv!item.CE_LEVEL), a!save(target:ri!userrole.LEVEL,value:fv!item.CE_LEVEL), a!save(target:ri!userinputsheet.Telephone_number,value:fv!item.Telephone_number), a!save(target:ri!userrole.TELEPHONE_NUMBER,value:fv!item.Telephone_number), a!save(target:ri!userinputsheet.Exceptional_case_library_view_right,value:fv!item.Exceptional_case_library_view_right), a!save(target:ri!userrole.IS_EXCEPTION,value:0), a!save(target:ri!userinputsheet.updateTime,value:now()), a!save(target:ri!userrole.ACTIVE,value:0), a!save(target:ri!userinputsheet.Active,value:0), a!writeToMultipleDataStoreEntities( valuesToStore: { a!entityData(entity: cons!KONE_Development_userinputsheet_Constant, data: ri!userinputsheet), a!entityData(entity: cons!KONE_Development_userrole_Constant, data: ri!userrole) } ) } ), linkStyle:"STANDALONE", color:"NEGATIVE" ) } ), a!richTextDisplayField( label:"Activate", labelPosition:"ABOVE", value:{ a!richTextIcon( icon:"arrow-up", link:a!dynamicLink( saveInto:{ a!save(target:ri!userrole.ROLE,value:fv!item.Role), a!save(target:ri!userinputsheet.KONE_user_name,value:fv!item.KONE_user_name), a!save(target:ri!userrole.NAME,value:fv!item.KONE_user_name), a!save( target:ri!userrole.USER_ID, value:rule!KONE_Development_UserId(fv!item.KONE_user_name) ), a!save(target:ri!userinputsheet.FIRST_NAME,value:fv!item.FIRST_NAME), a!save(target:ri!userinputsheet.LAST_NAME,value:fv!item.LAST_NAME), a!save(target:ri!userinputsheet.Email, value:fv!item.Email), a!save(target:ri!userrole.EMAIL,value:fv!item.Email), a!save(target:ri!userinputsheet.Role,value:fv!item.Role), a!save( target:ri!userrole.ROLE_ID, value: a!forEach (items:rule!KONE_Development_Role_RoleId(), expression:if(fv!item.Role=ri!userinputsheet.Role,fv!item.Role_Id,{}) )), a!save( target:ri!userrole.USER_ID, value:rule!KONE_Development_UserId(ri!userinputsheet.KONE_user_name) ), a!save( target:ri!userrole.ROLE, value: fv!item.Role), a!save(target:ri!userrole.PHASE_ID, value:a!forEach (items:rule!KONE_Development_Role_RoleId(), expression:if(fv!item.Role=ri!userinputsheet.Role,fv!item.Role_Id,{}) )), a!save(target:ri!userinputsheet.Branch,value:fv!item.Branch), a!save(target:ri!userrole.BRANCH,value:fv!item.Branch), a!save(target:ri!userrole.BRANCH_ID, value:a!forEach (items:rule!KONE_Development_Branch_BranchId(), expression:if(fv!item.Branch=ri!userinputsheet.Branch,fv!item.Branch_Id,{}) )), a!save(target:ri!userinputsheet.Region,value:fv!item.Region), a!save(target:ri!userrole.REGION,value:fv!item.Region), a!save(target:ri!userrole.REGION_ID, value:a!forEach (items:rule!KONE_Development_Region_RegionId(), expression:if(fv!item.Region=ri!userinputsheet.Region,fv!item.Region_Id,{}) )), a!save(target:ri!userinputsheet.Manager_role,value:fv!item.Manager_role), a!save(target:ri!userinputsheet.Language,value:fv!item.Language), a!save(target:ri!userrole.LANG_ID, value:a!forEach (items:rule!KONE_Development_Language_LanguageId(), expression:if(fv!item.Language=ri!userinputsheet.Language,fv!item.Language_Id,{}) )), a!save(target:ri!userinputsheet.CE_LEVEL,value:fv!item.CE_LEVEL), a!save(target:ri!userrole.LEVEL,value:fv!item.CE_LEVEL), a!save(target:ri!userinputsheet.Telephone_number,value:fv!item.Telephone_number), a!save(target:ri!userrole.TELEPHONE_NUMBER,value:fv!item.Telephone_number), a!save(target:ri!userinputsheet.Exceptional_case_library_view_right,value:fv!item.Exceptional_case_library_view_right), a!save(target:ri!userrole.IS_EXCEPTION,value:0), a!save(target:ri!userinputsheet.updateTime,value:now()), a!save(target:ri!userrole.ACTIVE,value:1), a!save(target:ri!userinputsheet.Active,value:1), a!writeToMultipleDataStoreEntities( valuesToStore: { a!entityData(entity: cons!KONE_Development_userinputsheet_Constant, data: ri!userinputsheet), a!entityData(entity: cons!KONE_Development_userrole_Constant, data: ri!userrole) } ) } ), linkStyle:"STANDALONE", color:"POSITIVE" ) } ) } ),{}) ,{}) ) ) ) } ), a!forEach( items:rule!KONE_Development_updateQueryAllPeople(), expression:a!localVariables( local!userinputsheet2:fv!item, a!forEach( items:rule!KONE_Development_userinputsheet_Rule(), expression:if(local!userinputsheet2.KONE_user_name=fv!item.KONE_user_name, if(local!userinputsheet2.updateTime=fv!item.updateTime, if(fv!item.KONE_user_name=local!searchValue, { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Username", labelPosition: "ABOVE", value:fv!item.KONE_user_name, saveInto: {fv!item.KONE_user_name, a!save(target:ri!userinputsheet.KONE_user_name,value:save!value) }, refreshAfter: "UNFOCUS", readonly:true, validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "First Name", labelPosition: "ABOVE", value:fv!item.FIRST_NAME, saveInto: {fv!item.FIRST_NAME, a!save(target:ri!userinputsheet.FIRST_NAME,value:save!value), }, refreshAfter: "UNFOCUS", validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "Last Name", labelPosition: "ABOVE", value:fv!item.LAST_NAME, saveInto: {fv!item.LAST_NAME, a!save(target:ri!userinputsheet.LAST_NAME,value:save!value), }, refreshAfter: "UNFOCUS", validations: {} ) } ), a!columnLayout( contents: { a!textField( label: "Email", labelPosition: "ABOVE", value:fv!item.Email, saveInto: fv!item.Email, refreshAfter: "UNFOCUS", validations: if(find("@",fv!item.Email),if(find(".com",fv!item.Email),null,"not contain correction .com"),if(find(".com",fv!item.Email),"not contain @","not contain @ and .com")) ) } ) } ), a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "Role", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: reject(fn!isnull,(local!allRole)), choiceValues: reject(fn!isnull,(local!allRole)), value:fv!item.Role, saveInto: a!save(target:fv!item.Role,value:save!value), searchDisplay: "AUTO", validations: {} ) } ), a!columnLayout( contents: { a!dropdownField( label: "Branch", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: reject(fn!isnull,local!allBranch), choiceValues: reject(fn!isnull,local!allBranch), value:fv!item.Branch, saveInto: fv!item.Branch, searchDisplay: "AUTO", validations: {} ) } ), a!columnLayout( contents: { a!dropdownField( label: "Region", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: reject(fn!isnull,local!allRegion), choiceValues: reject(fn!isnull,local!allRegion), value:fv!item.Region, saveInto: fv!item.Region, searchDisplay: "AUTO", validations: {} ) } ), a!columnLayout( contents: { a!dropdownField( label: "Manager Role", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: reject(fn!isnull,local!allRole), choiceValues: reject(fn!isnull,local!allRole), value:fv!item.Manager_role, saveInto: fv!item.Manager_role, searchDisplay: "AUTO", validations: {} ) } ) } ), a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Telephone Number", labelPosition: "ABOVE", value:fv!item.Telephone_number, saveInto:fv!item.Telephone_number, refreshAfter: "UNFOCUS", validations: if( len(fv!item.Telephone_number) <> 11, "phone number should be 11 digits", null ) ) } ), a!columnLayout( contents: { a!textField( label: "CE_LEVEL", labelPosition: "ABOVE", value:fv!item.CE_LEVEL, saveInto: {fv!item.CE_LEVEL}, refreshAfter: "UNFOCUS", validations: {} ) } ), a!columnLayout( contents: { a!dropdownField( label: "Active", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: {0,1}, choiceValues: {0,1}, value:fv!item.Active, saveInto: {fv!item.Active}, validations: {} ) } ), a!columnLayout( contents: { a!dropdownField( label: "Language", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: reject(fn!isnull,local!allLanguage), choiceValues: reject(fn!isnull,local!allLanguage), value:fv!item.Language, saveInto: {fv!item.Language}, searchDisplay: "AUTO", validations: {} ) } ) } ), a!textField( label: "Exceptional Case License Library View Right", labelPosition: "ABOVE", value:fv!item.Exceptional_case_library_view_right, saveInto: fv!item.Exceptional_case_library_view_right, refreshAfter: "UNFOCUS", validations: {} ), a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Update", saveInto:{ a!save(target:ri!userinputsheet.KONE_user_name,value:fv!item.KONE_user_name), a!save(target:ri!userinputsheet.FIRST_NAME,value:fv!item.FIRST_NAME), a!save(target:ri!userinputsheet.LAST_NAME,value:fv!item.LAST_NAME), a!save(target:ri!userinputsheet.Email,value:fv!item.Email), a!save(target:ri!userinputsheet.Role,value:fv!item.Role), a!save(target:ri!userinputsheet.Branch,value:fv!item.Branch), a!save(target:ri!userinputsheet.Region,value:fv!item.Region), a!save(target:ri!userinputsheet.Manager_role,value:fv!item.Manager_role), a!save(target:ri!userinputsheet.Telephone_number,value:fv!item.Telephone_number), a!save(target:ri!userinputsheet.CE_LEVEL,value:fv!item.CE_LEVEL), a!save(target:ri!userinputsheet.Active,value:fv!item.Active), a!save(target:ri!userinputsheet.Language,value:fv!item.Language), a!save(target:ri!userinputsheet.Exceptional_case_library_view_right,value:fv!item.Exceptional_case_library_view_right), a!save(target:ri!userinputsheet.updateTime,value:now()), a!writeToMultipleDataStoreEntities( valuesToStore: { a!entityData(entity: cons!KONE_Development_userinputsheet_Constant, data: ri!userinputsheet), } ) }, submit: true, style: "PRIMARY" ) } ), a!gridField( label: "Read-only Grid", labelPosition: "ABOVE", data: a!queryEntity( entity: cons!KONE_Development_userinputsheet_Constant, query: a!query( selection: a!querySelection( columns: { a!queryColumn(field: "KONE_user_name"), a!queryColumn(field:"FIRST_NAME"), a!queryColumn(field: "LAST_NAME"), a!queryColumn(field:"Email"), a!queryColumn(field:"Role"), a!queryColumn(field:"Branch"), a!queryColumn(field:"Region"), a!queryColumn(field:"Manager_role"), a!queryColumn(field:"Telephone_number"), a!queryColumn(field:"CE_LEVEL"), a!queryColumn(field:"Active"), a!queryColumn(field:"Language"), a!queryColumn(field:"Exceptional_case_library_view_right"), a!queryColumn(field:"updateTime") } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "KONE_user_name", operator: "=", value: local!searchValue, ), }, ignoreFiltersWithEmptyValues: true ), pagingInfo: fv!pagingInfo ), fetchTotalCount: true ), columns: { a!gridColumn( label: "KONE_user_name", sortField: "KONE_user_name", value: fv!row.KONE_user_name ), a!gridColumn( label: "First Name", value:fv!row.FIRST_NAME, ), a!gridColumn( label: "Last Name", sortField: "LAST_NAME", value: fv!row.LAST_NAME, ), a!gridColumn( label: "Role", sortField: "Role", value:fv!row.Role ), a!gridColumn( label: "Email", sortField: "Email", value:fv!row.Email ), a!gridColumn( label: "Active", sortField: "Active", value:fv!row.Active ), a!gridColumn( label: "updateTime", sortField: "updateTime", value:fv!row.updateTime, ), }, pagesize: 5, initialsorts: a!sortInfo( field: "updateTime", ascending: false() ) ) } ,{}) ,{}) ,{}) ) ) ) ), } ) )
the problem appear around row:510 to row:730. I tried two ways of update, one way is shows up everything and I can update it directly, another is update username by searching then it can update the specific one which appears such annoy problem.
It's really hard for us to know where to look in 200 lines of code. Can you try to comment out small parts at a time to isolate what is causing the issue (i.e. which save is causing the problem)?
I don't know, during those two hundred lines of application,whenever i change something from one text blank and to switch to the next blank, this error report right after i switch.
By the way, you have good lecture, but i do think majority of material could be abbreviate to shorter one, and leave more section on real project practice teaching.
I think a!save part of issue from row of 712 to 730
I solved it! I should take the second forEach loop items as local!rule which i set in the header but not the rule!KONE_Development_.. in the items definition.
By the way,do you have any link discuss about the process model? I want let the interfaces interact between each other by link or button click in it and jump to the different interface.
Hi,
Please find the below link for interface wizard.
To invoke process model from the interface, a!startprocesslink can be used.
what's all this about?