upload data and radio button
I have a form with several text fields and a radio button. The radio button has two choices (Open & Closed) with a default of Open. I upload data from a spreadsheet for the text fields but dont have a column for the radio button.
After uploading the data the view shows all the data accurately except the radio buttons field is blank. When I edit a record the radio button is marked Open as I would expect.
Is there a way to force the radio button to use the default value specified on the form? The spreadsheet is coming from an external source so it is difficult to add a column for the radio button field.
Herb Wexler