Active Campaign: use data to prefill Jotform

  • Lopay Marketing
    Asked on March 12, 2023 at 10:02 PM

    I use ActiveCampaign to send emails and would love to be able to pre-populate JotForms with data from ActiveCampaign, so that our users don't have to do the heavy-lifting of form filling. But is that possible with this new feature or would this require a future integration?

  • Girish JotForm Support
    Replied on March 13, 2023 at 2:32 AM

    Hi {username},

    Thanks for reaching out to Jotform Support. Unfortunately, the feature you're looking for isn't available at Jotform right now. We've gone ahead and escalated your request to our developers, but when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll circle back to this thread and let you know.

    Thanks for your patience and understanding, we appreciate it.

  • samanthah
    Replied on March 17, 2023 at 11:12 AM

    Hi Girish -

    On this same note - if we have a spreadsheet that has all the information that needs to be pre-populated is there a zapier integration or something that could help us generate the link adjustments needed for the form to be pre-filled?

    Our use case is for our delivery team. We have a delivery tracker sheet and want them to have an online form they can use to submit photos from the delivery, sign off things were done OK, QC checklist, etc. So, I need the form to pre-populate with the delivery information, special instructions, contact info, and other items that would come from the spreadsheet.

    Thanks for any insights you can share!

  • Victorino_S JotForm Support
    Replied on March 17, 2023 at 12:01 PM

    Hi samanthah,

    Thanks for reaching out to Jotform Support. As for your question, I've moved that to a new thread. You can check that out here.


  • Lopay
    Replied on March 27, 2023 at 6:32 AM

    Just a heads up, I managed to figure out a way to prepopulate my JotForm with information from ActiveCampaign by using the URL to map the required data.

    Example URL:
    https://eu.jotform.com/123456789098765?firstName=%FIRSTNAME%&lastName=%LASTNAME%&email=%EMAIL%&UserID=%ACCOUNT_IDENTIFIER%

    These are the field IDs of the JotForm found in the advanced settings at the bottom1679912905 64216fc9d3f99  Screenshot 10



    These are the personalisation tags for fields in ActiveCampaign found in field set up settings

    1679913040 642170500b182  Screenshot 21

  • Rahul JotForm Support
    Replied on March 27, 2023 at 7:01 AM

    Hi samanthah,

    Thanks for getting back to us. We have escalated your request to our development team as Feature request so that they can build a proper way for this instead of using a workaround. Once I receive any update I’ll circle back to this thread and let you know.