A new row is created with the responses of my Typeform, so far so good. However, I have a data validation in a column that is not being filled automatically and it keeps disappearing when the row is created. Is there any way I can keep the data validation in that specific column cell when creating a row from the form responses?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+9
- Certified Zapier Expert
- 617 replies
-
31 May 2021
Hi
When you use Google Sheet integration, the automation inserts a new row, it doesn’t update the row. That might cause your data validation to not work. You can use “Find row” and “Update Row” function to set up a system where there is row filled in spreadsheet it marks a cell True and the next rows stays False and this way you can setup Zapier to update a row instead of inserting.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.