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

  • Profile Image
    firesafetyman
    Asked 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!

     

     

     

  • Profile Image
    guilledutra
    Answered 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