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

    Can i pull data and display it depending on the person logging in

    Asked by Rory on March 26, 2012 at 05:57 PM

    Using Jot form currently and sends email which is then info is manually kept track of would like to create user logins with an email (username) and password stored on jotform? is the possible? Then when you user logs in with that email (username) display the who has made donations to that person only "referred by" (see donation form).  So essentially the referred by will be an email and be the relation between each donation and the person logging in.

    Would this be possible using your services or am i going to have to write my own PHP script and then save to our own database?  If that is the case is it possible to pull stuff from your form into our own database?

    Please let me know

    Thanks

    Page URL:
    http://www.eliminatingpoverty.org/eliminatingpoverty/Donate.html

    Screenshot
  • Profile Image
    JotForm Support

    Answered by NeilVicente on March 26, 2012 at 06:31 PM

    Rory,

    Sorry but that is far more complicated than what JotForm can handle. Our form builder does not have a user log in or membership feature and does not allow for saved data to be accessed and manipulated.

    Would this be possible using your services or am i going to have to write my own PHP script and then save to our own database?  If that is the case is it possible to pull stuff from your form into our own database?

    I am not exactly sure what you mean by pulling stuff from a JotForm into your database. Would you care to elaborate on this one?

  • Profile Image

    Answered by Rory on March 26, 2012 at 07:18 PM

    well i read this forum post and thought it might be possible... with agrid listing report i do not need it to be editable just for that person to see info realated to them.

    So is there a way for me to intercept the text from your form or get all of the code for the form so that i can change it to send to my own database or do i have to write my own form?

    http://www.jotform.com/answers/17032-Can-I-pull-submission-data-into-my-database

    How long will submissions last in JotForm Database?

    We don't delete records.  It stays there until you delete them yourself. 

    Reports

    There are seven (7) different types of reports that can be created in JotForm

    1. Excel report
    2. CSV report
    3. Grid listing report (web browser based excel-like function that cannot be edited)
    4. HTML table listing report (with sorting functions)
    5. Calendar Listing report (this only shows up when a form has a calendar field)
    6. RSS listing report
    7. Visual Builder report (If you wish your report to have graphs, you can have your statistical reports here)

  • Profile Image

    Answered by fxr on March 27, 2012 at 03:55 AM

    You can access form post data on a custom URL thankyou page which you can then use to populate a mysql database. 

    This guide will give you an overview of the process:

    http://www.jotform.com/help/126-How-to-Insert-or-update-form-submissions-to-your-MySQL-database-using-PHP

    Creating 'login' forms however could become a problem as our automated malicious form detection algorithms will probably flag them and disable them. 

    Ultimately, I think you are probably better doing the login stuff seperately from JotForm with your own HTML & php scripts.