Spreadsheet to widget dropdown and autofill

  • Profile Image
    jill5000
    Asked on July 22, 2021 at 11:09 PM

    Spreadsheet to form Widget is so close to what I need.

    Is there a way to make the unique code a drop down select from the values in the specified column?

    If there is, can it auto fill when selected instead of having to push a button?



    This is a re-post of a comment on How to Use the Spreadsheet to Form Widget

  • Profile Image
    Billy_G
    Answered on July 23, 2021 at 06:27 AM

    Hi there!

    I hope you're doing well and thanks for reaching out. Please find my answers to your inquiry below:

    Is there a way to make the unique code a drop down select from the values in the specified column?

    Unfortunately, no. It'll always be a text input. What you can do though is to use the form's condition to pre-populate the Spreadsheet to the form's widget value. Please refer to the screencast below:

    1627035974_60fa99462c463_

    This will result to:

    1627035872_60fa98e04f84d_

    If there is, can it auto fill when selected instead of having to push a button?

    As mentioned above, there's none. Additionally, the Spreadsheet to form widget would always require your respondents to click it for it to work.

    Let us know if you need further assistance.

    Best regards,