I have a build form in which I have several select_one types with multiple choices. In the choices field, I have used numerical values for the "name" field and text values for the "label" field. I realize now once I receive the results and download the excel, the values under the columns are all numerical. This doesn't make a lot of sense unless I do a join later.
I would like to ask what is the recommended way to deal with this. As of now I see two choices:
- I use text values instead of numbers or
- I keep the number and join the results later with the text values (which will add one additional step in the process.
Is there another way that I am not aware?