Can I prefill a new jotform with existing data

  • Renee
    Asked on February 6, 2018 at 7:45 AM

    HI there,

    We created a lengthy jotform to capture data from our clients.

    I want to now go back to those clients with a smaller jotform and ask them if any of the details that they had provided has changed.

    Can I prefill a new jotform with existing data (that has already been captured with an original jotform)?

    If not, what would your recommendation be?

    I look forward to hearing from you soon.


    Many thanks, Renee


  • burak JotForm Developer
    Replied on February 6, 2018 at 8:43 AM

    Hello, 

    Actually you can do it via our Prepopulate Tool, but unfortunately you can't power it with submission data. It means you should do it yourself for each user.

    If you are willing to do that i can suggest you that export your data into an excel sheet. Create an additional column and formulate it to generate urls. Thus you can generate different urls for different submissions by dragging the formula to below cells. Here is a screen shot that you can inspire.

     1517924334Screen Shot 2018 02 06 at 16 Screenshot 10

    Hope this helps.


  • Renee
    Replied on February 7, 2018 at 1:43 AM
    Hi Burak,
    I really appreciate you getting back to me. Thank you. I don’t know if that is the path I wish to take as it would mean a lot of data entry each time..
    Is there a form I can create that gets them to tick a box next to a question if something has changed? I would then like to get an alert in my CRM software Ontraport if something has. I use zapier to integrate Ontraport and jotform. Do you know if I can do this?
    Thanks for your help,
    Renee
    ...
  • Ardian_L
    Replied on February 7, 2018 at 5:35 AM

    Unfortunately no. What you are trying to achieve the fastest way to do that is only as suggested by my colleague earlier.

    Let us know if you have any other question.