How to make the users require to click on the button on the Spreadsheet to Form widget to prefill the form

  • TREF_forms
    Asked on October 30, 2020 at 11:17 PM

    Hello,

    The Spreadsheet to Form widget can be set as a required field, but it doesn't operate as a required if successfully validated. Is there a way to require the user to hit the button before moving submitting the form? Presently a user can simply type anything without pressing the button to satisfy the required condition.

  • KrisLei Jotform Support
    Replied on October 30, 2020 at 11:31 PM

    Hi,

    I assumed that you are referring to this form, 202584966420055, correct? I can see that you have a required field that will populate from the Spreadsheet to the Form widget. It seems that this is the only way to require the users to hit the "validate" button of the widget:

    1604114907 5f9cd9dbcf3e4 Screenshot 1031 Screenshot 10

    Or you can instruct your users by changing the Fill button text similar below:

    1604115001 5f9cda396bbc3 Screenshot 1031 Screenshot 21

    Please do let us know if you need further assistance.