What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Can I have a user generated auto complete box?

    Asked by IanRm on February 17, 2017 at 12:22 PM

    Hello,

    I would like to have the functionality of the

    User Generated Dropdown Widget 

    and the

    Auto Complete Widget

    in one!

     

    Is this possible?

     

    If it does not exist, is there a way of integrating a google sheet with the auto complete widget so that the options change as more items are added to the google sheet? Or anything like this?

     

    Thank you

    Page URL:
    https://form.jotform.com/70473583049966

  • Profile Image
    JotForm Support

    Answered by Nik_C on February 17, 2017 at 01:43 PM

    Unfortunately, I don't see the way to combine those two.

    But you can integrate the Auto complete widget with Spreadsheet. When you integrate the form with Spreadsheet, all fields in it will pass to Excel sheet automatically with each submission. But if you meant to get the data from the Spreadsheet to the Auto complete widget, unfortunately, it is not possible. 

    So probably a User contributed dropdown widget would be the best option for you since all previously entered data will show.

    If I somehow misunderstood your questions please let us know.

    Thank you!

  • Profile Image

    Answered by IanRm on February 24, 2017 at 01:46 PM
    Thank you that's helpful - yes I'm afraid it's the second option I was
    hoping for. I may stick with the dropdown for now.
    Kind Regards
    Ian
    Ian Mullen
    Ross Print Services, 5 Applewood Drive
    Greystones, Co. Wicklow
    *T: +353 1 287 6612*
    M: +353 87 255 4216
    ...