Spreadsheet to Form Widget: How to autopopulate fields based on user's answer?

  • James_Horne
    Asked on December 22, 2020 at 10:00 AM

    I'm new to Jotforms, and I am kicking the tires on my first form now. 

    On the conditional logic. I have two fields on my baseball registration. Graduation Year and Tryout dates, both of which are dropdowns. Is there a conditional logic where if they pick, say, 2022 for the grad year, the form will select the tryout date for them?

    thanks again, and happy holidays

  • Zahra_S
    Replied on December 22, 2020 at 10:32 AM

    Hi there,

    Thank you for contacting us, and Happy Holidays to you too :)

    You can use our Spreadsheet to Form Widget to implement this.

    You can add Graduation Year as a unique id and add a column of Tryout date.

    Guide: https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget

    I hope this helps. Let us know if you need further assistance.