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

  • Profile Image
    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.

    1606823010_5fc62c62ce0f2_SingleChoice_Sc

    and here is the Jotform initial response to my original query:-

    1606822951_5fc62c2728399_SingleChoice_Sp

    Many thanks for your help.

  • Profile Image
    Girish
    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