I have a zap that should send recent submissions from a Formidable form to a Google sheet. It is sending the data just fine but the problem is, it is always sending the first record received and not the newest record submitted. What have I setup incorrectly?
Please post screenshtos with how your Zap steps are configured, thanks.
Make sure you are mapping the variables between Zap steps as indicated here: https://zapier.com/help/create/basics/set-up-your-zap-action#set-up-your-action
Here are screenshots of the setup, spreadsheet, and form entries.
This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
Are you testing the Zap steps manually?
If yes, you can change the trigger test data: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger
Otherwise turn the Zap ON and test live, then check your GSheet and Zap Runs: https://zapier.com/app/history
I have been testing live (that’s why there are two rows for Jennifer Wylie) on the form. I keep getting Ray Barnett as the entry in the google sheet. The Zap data history also shows Ray as the data in and out. I’m stumped as to why I keep getting his data and not Jennifer’s data.
I also tried deleting the zap and restarting with a new one but that didn’t change anything.
Probably best to open a ticket with Zapier Support so they can troubleshoot further: https://zapier.com/app/get-help