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

    Creating a relational database form?

    Asked by Richard on September 15, 2013 at 08:52 AM

    Hello, I am considering moving my forms over to jotform due to my frustrations with zoho creator, but I had a couple of questions:

    1 .Can data be exported to Excel, CSV or some such?

    2. Can sub-forms be created that refer to a main form? In zoho, I can create a lookup field which can be linked to another field in another form...like a relational database.

    I have a survey-like form that i need to deploy; There are Objects, that belong to Collections, that are housed in Sites. Can I use jotform to create such a database?


    Thank you! Richard

    My Forms survey JotForm style size
  • Profile Image

    Answered by pinoytech on September 15, 2013 at 10:13 AM

    Hi Richard,

    Welcome to JotForm and thank you for contacting us with regards on this matter.

    1. Can data be exported to Excel, CSV or some such?

    - Yes, you can export Form Data to Excel and CSV. For more information, please take a look at this article: http://www.jotform.me/help/44-How-to-Export-Form-Data-to-Excel

    2. Can sub-forms be created that refer to a main form? In zoho, I can create a lookup field which can be linked to another field in another form...like a relational database.

    - Using Custom URL feature of our Thank you page, you can redirect users to a different page. For more information, please take a look at this article: http://www.jotform.me/help/38-Redirecting-Users-to-a-Different-Page

    If you need further assistnce, please feel free to contact us at anytime.

    Have a nice day!

  • Profile Image

    Answered by rarles on September 15, 2013 at 01:34 PM

    Thank you pinoytech

     

    1. Excellent, I did some dummy submissions and exported. Great!

    2. I have been trying to understand how jotform deals with relational databases...how can a user type in many objects/products/items for many sites/places/collections? If a user types in a site, and lists several objects that belong to that site, and then types in another site, and then objects belonging to THAT site, how can that work with jotform?  

    I thought that a work-around would be to create 2 forms, one for sites, and one for objects, and then to prepopulate the objects form with just one field: the site name. That way, I could look up sites and see their objects. But I cannot get this to work right.

    I followed this advice

    I went to the Thank You note for the first form (the "sites") and put in the URL as follows -- so when user submits it, they go to the "objects" form, the 2nd form, with the "site name" prepopulated -- 

    http://[site name]?input_55={whatIs3} (my fields)

    That is,

    http://[site name] + ? + field ID that comes from Properties of Field from Form 2 + = + field name in brackets from Form 1

    Is my "input_55" the correct field "ID" to prepopulate?

    It just doesn't work. I KNOW I am doing something wrong :)

    Is there a solution for those of us who would use this as a relational database? Is there a simple template available that acts like a relational database? Thank you, R.

  • Profile Image

    Answered by jedcadorna on September 15, 2013 at 03:12 PM

    Can you try this field name "q55_whatIs55" instead, take a look at this screenshot. I'm still trying to recreate the issue on my end. Where would the URL populate on form2 is it the "What is the name of your Institution?" field?