How to auto populate a jotform for the over 100 attendees in one go

  • Profile Image
    convergenteventsdxb
    Asked on April 08, 2019 at 01:09 PM

    HI,


    I have a query, I have a 100 people confirmed to attend my event some through jot form and some through emails. However, I would like to send them an email campaign to activate their badges.


    I am trying to understand how can I create a unique link for each attendee, when they click on the link and it opens the jot form on my website, prefilled with the data they have shared with me. 


    Is this possible, I will be sending the email from my mail chimp with the activate your attendance link.


    I hope what I am asking makes sense. As I want to send it for multiple attendees in one go. I am trying understnd if there is way where I can create a 100 links in one go.


    I hope you can guide me.


    Thanks.

  • Profile Image
    david
    Answered on April 08, 2019 at 02:25 PM

    The easiest way I can think of to accomplish this would be to export the data to a spreadsheet:

    https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel

    Then add an additional column to the sheet to create the URL's.  The form can be populated using URL parameters:

    https://www.jotform.com/help/71-Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters

    Either that or writing a script that pulls the data via API and creates the URL's, but that would likely be quite a bit more complex:

    http://api.jotform.com/docs/