+1I currently have a lookup column with an additional field to display as shown below:
How can I display the additional field in a nintex form? I would like to display the text from the associated additional field ("Title") once the user selects the "Start Time". I want to display it where the red arrow is.
Thanks!!
Best answer by bgarvey
Add a calculated value control to your form using a formula like:
lookup(“Training Date”, “Start Time”, StartTime, “Title”) where the second Start Time value is associated to the Named Control in your form (if done correctly, this value should be red and underlined). Do not choose the Item Property StartTime as that will not be dynamic (it reads the saved value in the list item).
Lookup function has the four parts:
lookup (list title of lookup list, column in that list to filter on, filter value - usually a Named Control from the active form, value to return)
In the Calculated Value control you can also add a suffix and prefix like
Prefix: Course Title:'
Suffix: '
So if the calculated value brings back Nintex Workflow 101, the value shown will be: Course Title 'Nintex Workflow 101'
+2I haven't tried to show the additional fields, but you can throw in a calculated value control and use the lookup inline function to lookup the start time based on the selection in the dropdown.
Add a calculated value control to your form using a formula like:
lookup(“Training Date”, “Start Time”, StartTime, “Title”) where the second Start Time value is associated to the Named Control in your form (if done correctly, this value should be red and underlined). Do not choose the Item Property StartTime as that will not be dynamic (it reads the saved value in the list item).
Lookup function has the four parts:
lookup (list title of lookup list, column in that list to filter on, filter value - usually a Named Control from the active form, value to return)
In the Calculated Value control you can also add a suffix and prefix like
Prefix: Course Title:'
Suffix: '
So if the calculated value brings back Nintex Workflow 101, the value shown will be: Course Title 'Nintex Workflow 101'
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
