What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Pre-populate field with existing submission data to send emails?

    Asked by diedrich on September 06, 2016 at 04:19 PM

    I would like to send an email to all clients who filed a (insurance) claim to find out how we did handling their claim.  How can I pre-populate either a visible or hidden field in a Jotform with their account number?

    Presumably this would mean I would need to automatically create individual links for each client and email their specific link to them?

    If I depend on clients to know their account number they won't fill in this data.  We could make the name and email address fields mandatory, but there could be some people who may not have had a perfect experience who would not fill the form out if they have to "sign" it.  A hidden field containing an account code would be perfect.

    Is it possible with any level account you offer?

    Thanks for your help!

    Jeff

    populate field pre-populate field client JotForm name hidden create
  • Profile Image
    JotForm Support

    Answered by Kiran on September 06, 2016 at 06:29 PM

    We have an app email newsletters to send emails to the submissions that are already received. However, it is not supported to have custom links or to read the form fields to the email content with this app. You may consider exporting the form submission data to Excel and then using Mail merge feature if you have Microsoft office installed on your PC. This way, you can also generate the individual links either in the spreadsheet or in the email content.

    Please refer to the Microsoft article that can help you with using Mail merge.

    https://support.office.com/en-us/article/Mail-merge-using-an-Excel-spreadsheet-858c7d7f-5cc0-4ba1-9a7b-0a948fa3d7d3

    Hope this information helps!