On my Choices tab I need to have the labels a concatenation of two fields, the route name and routeID as this is what the user needs to see on the pulldown menu of the entry form. The name column consists of the routeID, which is what I would like submitted, not the label, as it is the unique ID. This is not usually the case however, since most of my values in the choices tab are better reflected in labels column as spaces are allowed. I got around this limitation on the survey tab by using the alias column. Do we have anything like that for the Choices tab?
Values in the master database for sky conditions are in the labels column
list_name | name | label |
endsky | Clear | Clear |
endsky | Foggy | Foggy |
endsky | PartCloudy | Part Cloudy |
Values in the master database are in the name column
RouteID | 3 | 3 - Wells to Jackpot |
RouteID | 4 | 4 - Wells to Spruce Mountain |
Do I have any control as to which column of data gets submitted or do I have to write python scripts to format my data after submission prior to importing into master database?
Hi Bonnie,
The name value is always submitted in a select_one or select_multiple question. There is an enhancement issue to to access the label of a choice as part of a calculation.