susch_at
Nintex Observer

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

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?

0 Kudos
Reply
3 Replies
lasertracs
Nintex Newbie

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

I have same issue. Did you figure out what was the Issue?

0 Kudos
Reply
lcha
Workflow Hero

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

I have the same issue. I don't want list lookup recalculate.  Is there an easy way to do it?

0 Kudos
Reply
lcha
Workflow Hero

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

I can think of creating 2 controls. One is the cascading list lookup dropdown. The other is a plain text.

In the new mode the text field is hidden. After a new form is submitted, the workflow copy value from the drop down to the text field. When in Edit or Display mode, the dropdown list lookup will be hidden  and the text field will be present.

0 Kudos
Reply