Display saved value no longer in a lookup list

  • 10 March 2021
  • 2 replies
  • 36 views

Badge +2

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.


2 replies

Userlevel 2

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

Badge +2

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.

Reply