How do we return a “name” plus corresponding “value” on a form drop down selction?
You can either return just the value, and then set up a relation/lookup in the table to retrieve the name.
Or you can create a template column in your choices table that joins the name and the value separated by a comma. Then have that template column set as your choice value. Then in the form response table, use a Split Text column to split the value based on the comma delimiter, then create two single value columns the pull the first and last values from the split array.
2 Likes
The approaches Jeff recommended are ideal, I would still “display” the name on the front end but actually write a unique value on the back end, either the rowID or a template column that joins all needed values.
1 Like