Skip to main content
Nintex Community Menu Bar
Solved

Mapping 2 form fields to one column

  • July 18, 2023
  • 2 replies
  • 247 views

Forum|alt.badge.img+8

I have a lookup column that I use on a Nintex Mobile form. The list of values is fairly long, and occassionally the field personnel cannot find the value they are looking for,  I want to add an additional field - like an “Other” on a normal choice field.  This is not an option on a lookup, so I thought I would add a checkbox - “enter value” - which would disable and hide the lookup, and make available a free form entry field.

 

Both the lookup and the text field would be mapped to the same SharePoint column.  Is this possible?  I know I have done in the past, and it seemed like an issue, and I don’t recall ever figuring out the “trick” to make it work.

Thanks in advance!

Best answer by bamaeric

I would not recommend mapping two controls to the same list column. That could definitely cause some issues,

Try creating a third control (maybe a hidden text control) that maps back to the list column. You can use rules on the form to populate that third control based on if the dropdown or other field is populated.

2 replies

bamaeric
Forum|alt.badge.img+14
  • Apprentice
  • Answer
  • July 18, 2023

I would not recommend mapping two controls to the same list column. That could definitely cause some issues,

Try creating a third control (maybe a hidden text control) that maps back to the list column. You can use rules on the form to populate that third control based on if the dropdown or other field is populated.


Forum|alt.badge.img+8
  • Author
  • Scholar
  • July 18, 2023

I like it!  Use a calculated value mapped back to the form.  Thanks!