Hey all! I was wondering if there’s a way to trigger a new row in a google sheet when a form is filled out via Formidable (a new entry created)… *but* the catch is, the form entry must have a certain field populated appropriately.
My overall goal is to only send “approved” data to this google sheet…. so my plan is to have someone fill out the form (create a new entry). Then the “approver” (myself) will go in and check the data. If I approve it, I would duplicate the entry and while doing so, type into a hidden field of the form, viewable only to me, “approve”. This would create a new entry, but with that special field “approve” populated.
Is there any way to do this? Or a cleaner way to send only approved form entires to a google sheet?
Thank you!