Hi folks,
The value selected in a lookup drop-down control (cascading is involved) does not show when the form is re-opened in view or edit mode.
Use Case:
An IT Service Request Form, where the assigned IT person must either be selected from a list of persons responsible for the department of the requester, or (in case the list of IT personnel is not up-to-date) entered via a people control. Either way, the UserId of the selected IT person needs to be stored in an existing column of the form's SP list.
My setup is as follows:
SP Lists:
- "Companies":
Columns: CompanyShortName, CompanyLongName - "Departments":
Columns: CompanyShortNameLook, (lookup-column, displays also CompanyLongName), DepartmentShortName - "Contacts":
Columns: AssignTypeDept, AssigneeName, AssigneeUserID
Form Controls:
- Lookup: oLookCompany] (binding: yes)
selects "Companies", column: CompanyShortName
- Lookup: LLookDepartment] (binding: yes)
selects "Departments", column: DepartmentShortName, filter: CompanyShortName=aLookCompany]
- Formula: FXassignTypeDept] (binding: no)
"B022"+parseLookup(LookDepartment)
recalculate in view: no, in new&edit: yes
- Lookup: pLookITcontactName] (binding: no)
selects: "Contacts", column: AssigneeName, filter: AssignTypeDept=pXassignTypeDept], multiple values: no
- People: sinputITcontactName] (binding: no)
- Formula: sLookITcontactUserID] (binding: no)
lookup("Contacts","AssigneeName",parseLookup("LookITcontactName]),"AssigneeUserID")
recalculate in view: no, in new&edit: yes
- Formula:
if((isNullOrEmpty((inputITcontactName])),
tLookITcontactUserID],userProfileLookup(rinputITcontactName],"UserName")))
recalculate in view: no, in new&edit: yes
This works all just fine in new mode, the value of eITcontactUserID] is properly stored in the respective SP list column. However, in case the IT person was selected via the Lookup LookITcontactName], the Lookup Control does not show the previously selected person when re-opening the form view or edit mode.
pNintex Forms 2013 Version 2.10.0.2]
Any ideas?
