I am looking to have information pulled from new submissions to go into the row that matches the date on the submission. If something was submitted on 10/13/2024 in JotForm, is there a way for Zapier to then connect it to the 10/13/2024 row in an excel document. Adding in the data that is in the JotForm into the corresponding excel columns? Then if something is submitted the day after, it fills in the appropriate row?
Question
How to add Jotform submissions to matching date rows in Microsoft Excel using Zapier?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Try using these Zap steps:
- Trigger: Jotform - New Submission
- Action: Excel - Find Row
- Action: Excel - Update Row
- Map the Row ID from Step 2
+11- Community Manager
Hi there
Did Troy's suggestion of using a Find Row search action before an Update Row action do the trick?
If you're having any trouble in setting that up or have any questions we’d be happy to assist further - just let us know! 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.