Set values different from label in Google Forms
<p>Is there a way using either Google Forms Apps Script or Google Sheets formulas to set the value different from the label in multiple choice selections on Google Forms?</p>

<p>What I am looking for is something similar to this in html:</p>

<pre><code>&lt;select name="cartype" form="myform"&gt;
  &lt;option value="33"&gt;Volvo - $33&lt;/option&gt;
  &lt;option value="34"&gt;Saab - $34&lt;/option&gt;
  &lt;option value="35"&gt;Opel - $35&lt;/option&gt;
  &lt;option value="36"&gt;Audi - $36&lt;/option&gt;
&lt;/select&gt;
</code></pre>

<p>In Apps Script (<a href="https://developers.google.com/apps-script/reference/forms/" rel="nofollow noreferrer">docs</a>) I can set the multiple choice values using <code>setChoiceValues(values)</code> but this gives the same string for the input value and display text.</p>

<blockquote>
  <p><code>values   String[]</code>   the array of choice values, which respondents see as
  labels when viewing the form</p>
</blockquote>

<p>Alternatively, it would be fine if it was possible to strip the currency values only from the cell in Google Sheets and use in a sum formula.</p>

<p>The end result I am looking for is a Google Form that lists options with prices, then outputs to a spreadsheet that can sum the price totals automatically.</p>

<p><strong>Edit:</strong></p>

<p>Is it possible to do a reference to a list in sheets to get the number value?</p>

<p>Sheet 1 - Results from Google Form spreadsheet:</p>

<pre><code>| Name | Car        | Days |
| Foo  | Saab - $34 | 4    |
| Bar  | Volvo - $33| 2    |
</code></pre>

<p>Sheet 2 - Reference lists:</p>

<pre><code>| Car         | Price |
| Volvo - $33 | 33    |
| Saab - $34  | 34    |
| Opel - $35  | 35    |
| Audi - $36  | 36    |
</code></pre>

<p>Sheet 3 - Totals:</p>

<pre><code>| Name | Car                         | Days | Total |
| Foo  | {price from reference list} | 4    | B1*C1 |
</code></pre>