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?

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data