Retrieving data entered in one jotform in dropdown of another

  • Profile Image
    MydigitalAthlete
    Asked on January 13, 2015 at 02:45 PM
  • Profile Image
    Welvin
    Answered on January 13, 2015 at 03:59 PM

    Hi,

    That is possible in Jotform. Here's an old thread with the full steps on how you can do it:

    http://www.jotform.com/answers/417250-Link-Forms-Pass-value-from-one-form-to-another

    Please let us know if you require any further assistance.

    Thanks

  • Profile Image
    MydigitalAthlete
    Answered on January 13, 2015 at 04:29 PM

    i seen this before i asked this question but i doesn't do exactly what I'm needing.  here is an example of what Im needing.

     

    I have form 1. One of the fields in form one is "name".  I want every time someone fills out form 1's name field it is added to every other user that inputted in that field.  Then in turn when I go to form 2 which also has a dropdown called "name" which when selected it gives all the submissions from form 1 in form 2 dropdown.  I hope I was clear.  Is this possible?

  • Profile Image
    Ben
    Answered on January 13, 2015 at 05:43 PM

    Hi,

    Thank you for further details, but the only way that would be possible is if in the middle we include your database as well.

    It could either work by redirecting the jotform to a page on your website which would gather the data and then pass the values onto form 2 (if they should go to form 2), or by having the jotform 2 on your website and making a source code customization to fetch the data from the database every time someone accesses the page with the jotform.

    In both cases you would need to save data from your jotform into your database and then retrieve it.

    To accomplish this you could use Webhooks and POST data option (for saving data) and would need to get someone to handle the calls that would collect data from DB and pre-populate the dropdown on form 2.

    Hope this helps.

    Best Regards,
    Ben

  • Profile Image
    MydigitalAthlete
    Answered on January 13, 2015 at 06:26 PM

    Thanks i appreciate your help. One last thing.  Do you think I could use a Google spreadsheet to accomplish this?

  • Profile Image
    Shadae
    Answered on January 13, 2015 at 08:12 PM

    Hi MydigitalAthlete,

    On behalf of my colleagues you are most welcome. We are happy to assist you.

    Unfortunately the Google Spreadsheet integration is just for the spreadsheet to capture the information provided on the form.

    It is not possible for that information to influence the information on another form as Google doesn't pass information to JotForm.

    As suggested by Ben, the best option would be to gather the information on your website in a database.

    Please feel free to contact us if we can assist you with anything further.