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

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



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

  • Profile Image
    KrisLei
    Answered 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

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

    1604115001_5f9cda396bbc3_Screenshot_1031

    Please do let us know if you need further assistance.