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

    What's the best way to build a sub form for a field?

    Asked by firesafetyman on October 24, 2013 at 07:35 AM

    I'm trying to set up a JotForm to be used for building firesafety inspections. Annually, I want to track the fire extinguisher location, type, model, and condition. There are several date fields we use for items on our check list.

    We currently use Microsoft Access and insert each fire extinguisher into a new row and each has a sub form to track the specific information. We don't know if there will be 1 or 100 fire extinguishers so I can't just pre-build enough fields.

     

    I have four questions:

     

    #1) How do you suggest I layout my form to add my count for my dynamic item list?

     

    #2) Is there a way to auto-fill a form field with the data from the previous years inspection report as a recommendation like your smart fields do?

     

    #3) Can I feed a form field drop down list from a Google spreadsheet? 

     

    #4) Can I populate one field from a Google spreadsheet that would then fill-inn associated fields. For instance, fill-in Model: A123 and get Color: Blue and Size: Large.

     

    Thanks in advance for your help!

     

     

     

    Page URL:
    http://www.evernote.com/shard/s319/sh/629ce915-80d5-43a8-9754-6897ab6c<br/>8d07/fa8e85118d7f604e8c92e731c37527ef

    JotForm size layout form field
  • Profile Image
    JotForm Support

    Answered by guilledutra on October 24, 2013 at 08:22 AM

    Hi,

    As far as I can see your set of questions have something in common: Feeding form fields from an external data source.

    i'm afraid that we don't have a built in tool in order to populate form field from an external database, however you can download your form's source code and achieve what you are looking for by adding custom programming to your code. 

    As it is not a simple task, you will need to have programming knowledges in order to get this done, you can contract a freelance programmer trough odesk.com

    Thanks