Display value without drop down selection

  • 25 February 2022
  • 1 reply
  • 10 views

Hello Nintex Gurus--

The user selects the item and I would like it to cross reference to show the numeric value assigned.

I have a time list in a different location that is down to the minute level with a numeric value associated with it.  (5:00am =300) 

 

To pull in this list for reference I a list look up then created another field to show (parse lookup) just the value with out the drop down selection. This only works if someone selects an item from the drop down. 

 

There must be an easier way to cross reference a list to show the value.  How can I get there without a selection in the list look up?  


1 reply

Userlevel 1
Badge +6

Do you have a drop-down field on your form that is pulling data from a list on your site? And then do you want to includes data from other fields in your list based on the drop-down selected? For example, you have a drop-down on your form that use the title column in a list and then you want to pull in a corresponding description:



If so, you want to format your formula like:


 


lookup("IT User Types","ID",parseLookup([Form].[IT User Bundle],false),"Description")


 


lookup(List Name, Filter Column Name, Filter Value, Output Column Name)

Reply