I created a set of custom questions that are of the type multiple choice. I entered the labels like "Blue", "Green", "Orange", and left the values at 1,2,3
When I run a report in civiCRM, the column for my multiple choice question shows the label.
But, when I export the data, I see the corresponding values (1,2,3) instead of the labels.
But I need the label in my report, not the values.
Thought maybe I could just edit the multiple choice answers and copy the label text to the value column, but realized that the values 1,2,3 were being stored in the database in the custom data set civicrm_value_ table, so when I run the report in civiCRM, the column for the multiple choice question was blank (and no value was exported).
Trying to resolve this, I thought maybe I could update the column in the civicrm_value_ to store the value (replacing 1 with "Blue", 2 with "Green", 3 with "Orange").
But same result -- blank column in the report.
So question is -- how can I fix my problem? I need to update the multiple choice and copy the label to the value field, and update the existing data submitted so that it has the new text value instead of the old numeric value...