mwan001
Canvas Initiate

Display saved value no longer in a lookup list

On Nintex form, I have an Exam Name field which is tied a view in a look up list: All active Exam Names. At the end of each year, some Exam Names will be retired to inactive.  So when user goes back to old Nintex form items, Exam Name field is blank for some items since the Exam Name is inactive.  User still wants to see those saved Exam names. 

 

Is it possible to use custom JavaScript to achieve it? 

 

When the item is a new, display all active Exam Name only;

When the item is already saved, check if it has inactive Exam Name. If yes, load the inactive  Exam Name and the all active exam names in Exam Name field.

0 Kudos
Reply
2 Replies
ghaiashish
Cloud Wanderer

Re: Display saved value no longer in a lookup list

Hi Mwan001

Unfortunately not on the universal form, for a similar requirement for changing project managers on a project,t he way I did this is to store the lookup value in a text field called PMxxxxxNew .

When the values are incative I used hide and show rule to surface the text value(PMxxxxxNew) when the original lookup field(PM) goes blank.

See screenshots

regards

Ashish

0 Kudos
Reply
mwan001
Canvas Initiate

Re: Display saved value no longer in a lookup list

Thanks for looking.

 

I am thinking about appending the saved value to the active Exam names to have a good user experience. Not sure if it will work with Nintex form. 

 

I am able to achieve this with JavaScript if I use a custom form.

0 Kudos
Reply