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

    How to sync lists from a DB to a list.

    Asked by tom  on February 13, 2016 at 05:19 PM

    Hi, As above, I read through some of your documentation and cannot find a clear answer.

    Example, sales person 1 goes into the field with a long list of unique products, he is using form on a mobile app and agrees a sale to a consumer of product No. 9 based on that list.

    Meanwhile sales person 2 is in the field and just by chance a few minutes later he too agrees the sale of product No. 9, as product No. 9 is unique (say an item of antique furniture) one of the two sales has to fall through.

     

    Q. Is it possible, instead of uploading an excel spreadsheet to create a list of say, products. To have that list automaticity updated i.e synchronised to a cloud database.

     

    Thanks

     

    Tom

    how a using form excel Mobile app
  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 14, 2016 at 12:31 AM

    You can use your own database, for example, get the products from a table in your database and then update it in your form.

    To do it, you will need to get the full source code and then customize it to accomplish what you need, this guide will help you to get the code of your form: http://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form

    Then, you can execute the query, get the records and add them to a drop down or other field in your form.

    Hope this helps.