I'm trying to update an electronic form to be used by biological field surveyors. I have a list of species that I would like to have as checkboxes. I need to have these in a custom (taxonomic) order and also have them displayed as common names, but export as species codes . I have an external table linked to the form with all of the Common names and codes, but using the values from field option exports the selections as species codes but only results in an alphabetical list. Using the custom list allows me to have the correct order, but I can only get it to export as common names (as displayed on the form).
Is there a way to have both of these things happen? Either by rearrangin the from field value list or script to export codes from the custom list?