Hello everyone! I am trying to send data from a submitted form entry to a google sheet…. but I want to approve it before it gets sent. Neither of the methods I have thus far tried have worked… Would love any ideas!
I’ve tried:
- I created a hidden field called status, and set up a zap with a filtering action to only send new entries to the google sheet *if the status field has the word ‘approve’ in it*. It gets triggered when I modify the entry by typing approve in the status field, then duplicate it to create a ‘new entry’. No dice. I think duplicating an entry is not enough to trigger. It has to be a completely new entry…?
- I created a hidden field called status, with the word ‘undefined’ in it. Then I send all new form entries to a google sheet. I set a zap up to get triggered when I edit the status column in the google sheet, changing ‘undefined’ to ‘approve’. A cascade of other zaps are triggered when I do this (including sending to a new sheet containing only approved entries (my main goal), creating a WP user, creating a mailchimp user, etc). This seems to work fabulously most of the time, but sometimes it doesn’t. It seems to matter how much time passes between when the new entry gets sent to the first google sheet, and when I change the word ‘undefined’ to ‘approve’. Also, if I ‘approve’ entries too close together, one of them sometimes doesn’t work.
Do you have any other suggestions/work arounds for my goal of getting only ‘approved’ data from Formidable into a google sheet (and then doing a few zaps along the way, like mailchimp, WP user, etc).
I’m willing to upgrade!
Thank you!!
Best answer by jesse
View original
