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

    Is it possible to control inventory in form?

    Asked by HVACRich on May 16, 2017 at 10:47 AM

    Also, I would also like to know if there is a way to pull data from a table based on input from the person filling out the form. Such as have the person select themselves from a list. This would then display a choice specific to them. The dynamic drop down seems to be appropriate. But I want to display multiple choices and have additional input based on the selection made. It also needs to be repeatable until all selections have collected information.

    I am trying to use this for inventory control to have people count 4-10 items. Based on the person I want to present them with a list of items they need to count and have them input the number of items for each line item. I don't want to have to create a form for each person/count. I want to be able to update a source table for these weekly counts. (picture attached)

  • Profile Image
    JotForm Support

    Answered by Welvin on May 16, 2017 at 12:14 PM

    Unfortunately, we don't have a feature that allows you to pull data from an external database. A workaround would be to add the entire set of fields in the form then show them based on a condition. You can show multiple fields at once.

    https://www.jotform.com/help/196-Hide-or-Show-Multiple-Fields-at-Once

    However, this method is fixed which means that you cannot dynamically add fields. You also need to update the form if you wish to add options.

    As for the inventory, you can incorporate any of the following widgets:

    https://widgets.jotform.com/widget/ticket_purchases

    https://widgets.jotform.com/widget/inventory

    https://widgets.jotform.com/widget/appointment_slots

    https://widgets.jotform.com/widget/gift_registry

     

    I hope that helps. Let us know if you need any further assistance regarding this matter.