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

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


    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.

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

  • Profile Image
    Answered on October 30, 2020 at 11:31 PM


    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:


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


    Please do let us know if you need further assistance.