Question
I wish to update however it always became to be insert
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",
readOnly: true,
validations: {}
),
a!textField(
label: "First Name",
labelPosition: "ABOVE",
value:fv!item.FIRST_NAME,
saveInto: {
a!save(target:fv!item.FIRST_NAME,value:save!value),
a!save(target:ri!userinputsheet.FIRST_NAME,value:save!value)},
refreshAfter: "UNFOCUS",
validations: {}
),
a!textField(
label: "Last Name",
labelPosition: "ABOVE",
value:fv!item.LAST_NAME,
saveInto: {
a!save(target:fv!item.LAST_NAME,value:save!value),
a!save(target:ri!userinputsheet.LAST_NAME,value:save!value),
},
refreshAfter: "UNFOCUS",
validations: {}
),
a!textField(
label: "Email",
labelPosition: "ABOVE",
value:fv!item.Email,
saveInto: {
a!save(target:fv!item.Email,value:save!value),
a!save(target:ri!userinputsheet.Email,
value:save!value),
a!save(target:ri!userrole.EMAIL,value:save!value)},
refreshAfter: "UNFOCUS",
validations: {}
),
a!dropdownField(
label: "Role",
labelPosition: "ABOVE",
choiceLabels:reject(fn!isnull,local!allRole),
choiceValues:reject(fn!isnull,local!allRole),
value:if(isnull(fv!item.Role),"null",fv!item.Role),
saveInto:{
a!save(target:fv!item.Role,value:save!value),
a!save(target:ri!userinputsheet.Role,value:save!value),
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: save!value),
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,{})
))
},
validations: {}
),
a!dropdownField(
label: "Branch",
labelPosition: "ABOVE",
choiceLabels:reject(fn!isnull,local!allBranch),
choiceValues:reject(fn!isnull,local!allBranch),
value:if(isnull(fv!item.Branch),"null",fv!item.Branch),
saveInto:{
a!save(target:fv!item.Branch,value:save!value),
a!save(target:ri!userinputsheet.Branch,value:save!value),
a!save(target:ri!userrole.BRANCH,value:save!value),
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,{})
))
},
validations: {}
),
a!dropdownField(
label: "Region",
labelPosition: "ABOVE",
choiceLabels:reject(fn!isnull,local!allRegion),
choiceValues:reject(fn!isnull,local!allRegion),
value:fv!item.Region,
saveInto:{
a!save(target:fv!item.Region,value:save!value),
a!save(target:ri!userinputsheet.Region,value:save!value),
a!save(target:ri!userrole.REGION,value:save!value),
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,{})
))
},
validations: {}
),
a!dropdownField(
label: "Manager_role",
labelPosition: "ABOVE",
choiceLabels:reject(fn!isnull,local!allRole),
choiceValues:reject(fn!isnull,local!allRole),
value:if(isnull(fv!item.Manager_role),"null",fv!item.Manager_role),
saveInto:{
a!save(target:fv!item.Manager_role,value:save!value),
a!save(target:ri!userinputsheet.Manager_role,value:save!value)
},
validations: {}
),
a!dropdownField(
label: "Language",
labelPosition: "ABOVE",
choiceLabels:reject(fn!isnull,local!allLanguage),
choiceValues:reject(fn!isnull,local!allLanguage),
value:if(isnull(fv!item.Language),"null",fv!item.Language),
saveInto:{
a!save(target:fv!item.Language,value:save!value),
a!save(target:ri!userinputsheet.Language,value:save!value),
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,{})
))
},
validations: {}
),
a!textField(
label: "CE_LEVEL",
labelPosition: "ABOVE",
value:fv!item.CE_LEVEL,
saveInto: {
a!save(target:fv!item.CE_LEVEL,value:save!value),
a!save(target:ri!userinputsheet.CE_LEVEL,value:save!value),
a!save(target:ri!userrole.LEVEL,value:save!value)
},
refreshAfter: "UNFOCUS",
validations: {}
),
a!textField(
label: "Telephone Number",
labelPosition: "ABOVE",
value:fv!item.Telephone_number,
saveInto: {
a!save(target:fv!item.Telephone_number,value:save!value),
a!save(target:ri!userinputsheet.Telephone_number,value:save!value),
a!save(target:ri!userrole.TELEPHONE_NUMBER,value:save!value)
},
refreshAfter: "UNFOCUS",
validations: {}
),
a!textField(
label: "Exceptional Case Library View Right",
labelPosition: "ABOVE",
value:fv!item.Exceptional_case_library_view_right,
saveInto: {
a!save(target:fv!item.Exceptional_case_library_view_right,value:save!value),
a!save(target:ri!userinputsheet.Exceptional_case_library_view_right,value:save!value),
a!save(target:ri!userrole.IS_EXCEPTION,value:0),
a!save(target:ri!userrole.ACTIVE,value:1),
a!save(target:ri!userinputsheet.updateTime,value:now()),
},
refreshAfter: "UNFOCUS",
validations: {}
),
a!richTextDisplayField(
label:"Update",
labelPosition:"ABOVE",
value:{
a!richTextIcon(
icon:"check",
link:a!dynamicLink(
saveInto:{
a!writeToMultipleDataStoreEntities(
valuesToStore: {
a!entityData(entity: cons!KONE_Development_userinputsheet_Constant, data: ri!userinputsheet),
}
),
}
),
linkStyle:"STANDALONE",
color:"POSITIVE"
)
}
),Sorry, I used update arrow for icon"check" at end of each data row, I wish to update existing information, however, once i fill blank and click update, it always appear to be a new data row for the new information i fill in text blank which wish to be updated, someone tell me why?