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:23 AM

    Please check my answer to your question following this link:

    http://www.jotform.com/answers/283157

    Thanks