Spreadsheet to Form fetaures

  • Profile Image
    SCP_Forms
    Asked on October 12, 2018 at 03:42 PM

    I am currently using the spreadsheet to form widget.  I have a couple of questions about user submission.  When the user types the name to populate the email address, is there a way for it to act like the auto complete widget, where they would only have to type a few letters then show the choices based off that?  Currently, the user has to type the name exactly as it is on the spreadsheet, otherwise, they get an "invalid" notification.  

    My spreadsheet only has 2 columns- Name & Email address.  I have about 20 lines. 

  • Profile Image
    AshtonP
    Answered on October 12, 2018 at 04:36 PM

    Unfortunately, Spreadsheet to form widget does not support the AutoComplete feature, nor it allows the browser to autocomplete the value if it was filled previously. 

    As an alternative, you can use something like ID, or phone number to populate the values from the spreadsheet. These numbers are easier to type and they can be unique too.

    I hope that helps.