passing data from our site or retrieve data from our MySQL

  • Profile Image
    milbra
    Asked on August 23, 2013 at 12:26 PM

    A portion our website will be available only to register users. Is there any way to retrieve their login ID from our database or have it passed to our JotForm after they login?  Then maybe we could set this value as the default JotForm Unique ID for use with other forms.

  • Profile Image
    Welvin
    Answered on August 23, 2013 at 05:19 PM

    Hi,

    Good day and thanks for contacting us. So basically, the form is added to a page where user needs to login to access it? Unfortunately, I don't think that is possible. What I could suggest is to use our Unique ID field, you can check it here: Add Custom Unique IDs to your Form Submissions. The only downside for this method is that when the same user would submit to your form, that will create a new unique ID, whereas your method would only use one single Id which is their usernames/login ID.

    Thanks

  • Profile Image
    milbra
    Answered on August 23, 2013 at 05:57 PM

    Actually, the login is performed through a Joomla login form, not a JotForm. I would like to send their login ID from the Joomla form to a JotForm so the information collected from JotForm can be associated with that user. I'll then post the ID and JotForm information to our MySQL database.

  • Profile Image
    Tasha
    Answered on August 24, 2013 at 09:08 AM

    Hi,

    You can send data to your form by using url parameters. I would recommend that you add a hidden field to your form and then pre-populate it with the loginID that is coming from Joomla which you will then send to your database. Please review this guide on pre-populating field via url for more information. You might also be interested in reviewing this page, Form to MySQL.

    Please let us know if this solution will not work for you so that we can provide an alternative one.

    Thanks!

  • Profile Image
    milbra
    Answered on August 24, 2013 at 04:05 PM

    Thanks, I'll try this option.

  • Profile Image
    Tasha
    Answered on August 24, 2013 at 08:26 PM

    Thanks for letting us know. Please let us know if that doesn't work so that we can provide an alternate solution.