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

    Google Spreadsheet integration breaks if you add data validation for column

    Asked by lemonkool on November 29, 2012 at 08:18 PM

    I tried adding in data validation into my destination google spreadsheet. I have a status field, that on the form (a membership application form) is hidden and pre-populated with "PENDING".  Jotform initially populates our spreadsheet, but we'll have actual people updating information in some fields. Since we'll be driving emails in Mailchimp off these fields, it would be best to validate the data.

    I tried adding data validation to the status field, with "PENDING" as an option.  I also selected to accept invalid data.

    Once I did this, jotform would no longer update the google spreadsheet.  Even after I removed the data validation, it would still not update the spreadsheet. Removing and re-adding the integration itself creates a NEW spreadsheet (without data validation) that will show all past submissions and will update correctly.

    Any chance for a fix for this?  Our only other option right now is to have someone manually type in the values we want and hope for the best (some of them are phrases)

    Thank you!

  • Profile Image
    JotForm Support

    Answered by idarktech on November 29, 2012 at 09:52 PM


    Can you provide a screen as to how you've setuped the data validation? Please note that our Google Spreadsheet doesn't support auto-validations or formulas after the form is submitted, currently. The data will be be submitted to spreadsheet but validations will be skipped. Which means the submissions submitted to spreadsheet starts on the row from where the validation ends. Screen. http://pasteboard.co/1cHZH7Zv.png

    However, I'll forwarded this issue to our developers so they can check on it. We'll update you here once we have something to report. Unfortunately we can not provide any ETA, rest assured they'll be notified about this.