AnsweredAssumed Answered

List lookup control (cascading): selected drop-down value lost in edit or view mode

Question asked by susch_at on Nov 23, 2017

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: [LookCompany] (binding: yes) 

selects "Companies", column: CompanyShortName
 

  • Lookup: [LookDepartment] (binding: yes)

selects "Departments", column: DepartmentShortName, filter: CompanyShortName=[LookCompany]
 

  • Formula:  [XassignTypeDept] (binding: no)

"B022"+parseLookup(LookDepartment)
recalculate in view: no, in new&edit: yes
 

  • Lookup: [LookITcontactName] (binding: no)

selects: "Contacts", column: AssigneeName, filter: AssignTypeDept=[XassignTypeDept], multiple values: no
 

  • People: [inputITcontactName] (binding: no)
     
  • Formula: [LookITcontactUserID] (binding: no)

lookup("Contacts","AssigneeName",parseLookup([LookITcontactName]),"AssigneeUserID")

recalculate in view: no, in new&edit: yes
 

  • Formula: [ITcontactUserID] (binding: yes)

if((isNullOrEmpty([inputITcontactName])),
[LookITcontactUserID],userProfileLookup([inputITcontactName],"UserName")))
recalculate in view: no, in new&edit: yes

 

This works all just fine in new mode, the value of [ITcontactUserID] 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.

 

[Nintex Forms 2013 Version 2.10.0.2]

 

Any ideas?

Outcomes