Answers.Body: <p>This is definitely bug in report. You can either fix the code so that it is exported as label or use the same text for label and value for the options when creating. </p>
  
  <p>Eg For Blue use Label - Blue and value - Blue.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-05-10T07:39:31.247Z
Answers.Text: Overwriting field value risks losing existing data- or it did a couple of years ago when I did it.
  Labels can be renamed safely
Answers.UserDisplayName: Craig Almond
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-05-09T21:56:12.607Z
Answers.LastActivityDate: 2019-05-09T21:56:12.607Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>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</p>
  
  <p>When I run a report in civiCRM, the column for my multiple choice question shows the label.</p>
  
  <p>But, when I export the data, I see the corresponding values (1,2,3) instead of the labels.</p>
  
  <p>But I need the label in my report, not the values. </p>
  
  <p>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).</p>
  
  <p>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").</p>
  
  <p>But same result -- blank column in the report. </p>
  
  <p>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...</p>
  
Tags: <custom-fields>
Title: Help! Multiple choice value vs lable
ThreadText: # Help! Multiple choice value vs lable
  
  (Asked by: username_0 on 2019-05-09)
  
  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...
  
  **Tags:** custom-fields
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-05-09. Score: 1
  
  This is definitely bug in report. You can either fix the code so that it is exported as label or use the same text for label and value for the options when creating.
  
  Eg For Blue use Label - Blue and value - Blue.
  
  > **Comments:**
  > **username_2**: Overwriting field value risks losing existing data- or it did a couple of years ago when I did it. Labels can be renamed safely  
  
  ---
  
  