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

    I'm forwarding multiple form submissions to same MySQL database via Zapier but it's not working because of Unique ID

    Asked by seaserpent on May 26, 2016 at 07:06 AM

    I have a jotform with a uniquie ID for each record and use Zapier to send results to a mysql database. I have a duplicate of that form, but have changed some layout items and use Zapier to send results to the same mysql database as the original form. This isn't working because a unique ID in form two is duplicates in the mysql database. I would like to additionally clone the form multiple times with different layouts and continue to send results to the same mysql db. Any suggestion how I can resolve this?

  • Profile Image
    JotForm Support

    Answered by Welvin on May 26, 2016 at 09:35 AM

    I would suggest utilizing the Prefix option in the Unique ID widget: 

    You can say Form1 then Form2 on the second and so on. This would keep every submissions unique and won't create any error in your MySQL Database.