Google Forms – Send Different Data from Displayed Value on Select Option

google-forms

Is there a way to have a Google Form list-type question pass different values on the backend (e.g., to its linked Google Spreadsheet) than what are displayed?

For example, under Provinces at

https://docs.google.com/forms/d/1r-Lab6FPRSWP69ihPEZ0SPLJoQzsf3C1S1XjLDT8Zuc/viewform

It would be great if the HTML <select ...> option of

<option value="Quebec">Quebec</option>

would instead get rendered as:

<option value="QC">Quebec</option>

Best Answer

You can write a script that changes the names in abbreviations after all forms have been submitted. It has been done for the States of USA. See for the code on Github: https://github.com/davegaeddert/google-sheets-us-states/blob/master/Code.gs