Spreadsheet to Form - Connect Field Headers From Spreadsheet to Single Choice Radio Buttons

assets55ltd
Asked on December 01, 2020 at 06:45 AM

Hi and thanks for a speedy response. I've attached a screenshot of what I'm trying to achieve.
I’m trying to get the values from columns L, M and N to populate the single choice radio buttons within the “Replacement Cost” field. I cannot see how I should connect the field headers from the spreadsheet to the radio buttons on my form.
and here is the Jotform initial response to my original query:-
Many thanks for your help.

Page URL:
https://eu.jotform.com/build/203325737145352
Girish

Jotform Support

Answered on December 01, 2020 at 06:53 AM

Hello,
Please note that the Spreadsheet to Form widget cannot assign a value to the options in the Radio button field. It can only auto select that option in the field.
As explained by my colleague, the field name should match the column name. In your excel sheet, the column name is shown as the field options.
The widget can only be used to auto select any of the options in the form - i.e. Cost Low, Cost medium, and Cost high.
Please check this guide on how the widget works for the Radio button field: https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget