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

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

  • Profile Image
    NeilVicente
    Answered 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
    Rory
    Answered 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
    fxr
    Answered 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.