Forms and values

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.


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