I would like that the app shows the choice of states for the user, but it should register the region name on the file instead.
The issue that I am facing is that the repeated values are only showing one of each state instead of all of them.
Idea 1: Could you display the states, write the states, and then use an if-then-else column to display the region?
Idea 2: If you already have a table with the state-region association, does it matter if you write the region? You could write the state and then lookup the region with a relation+lookup.