I am successfully adding new rows to an Excel spreadsheet for each new Jotform submission…. each field maps over just fine. The trouble I’m having is that each submission on the Excel spreadsheet skips roughly 10 rows before it writes the next record. So I have an entry on row 3...then on row 13...23...etc. How can I have Excel just go to the next row without any blanks? Is that something with Jotform? Zapier? Excel? I don’t know where to start debugging that.
Best answer by christina.dView original
Make sure there is no prefilled data in the “blank” rows that would cause the Zap to skip 10 rows before finding the next completely empty row to add data.
Please post screenshots with how your Zap steps are configured in order for us to have more context.
Make sure to reference the available help articles for using Excel in Zaps: https://zapier.com/apps/excel/help
Hmmm so I do have a page break after the Driver Name field in the Jotform you see in the screenshot. Could that be a problem?
Can you post screenshots with how the top rows of your Excel are configured?
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.
Still skipping 10 rows. See attached.
Might be best to open a ticket with Zapier Support for further troubleshooting: https://zapier.com/app/get-help
Thanks for reaching out. I can see you were able to open a ticket with my friends in support. They recommended giving this a shot:
If that doesn’t do the trick, I’d recommend continuing to troubleshoot support to get to the bottom of this!
Keep us posted. 🙂