Question

How do I dynamically update a row in Excel from Formsite?

  • 8 September 2022
  • 3 replies
  • 27 views

How do I make a updated or new result on Formsite update a corresponding row in Excel.

I have successfully found a row and updated it, but when running the zap, the same row is always updated, not the matching row that is in Excel.

Can anyone help?


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +12

Hi @Chris.Giles!

The most common reason for what you’re describing is not using a custom value in the Excel step for the Row field. 

Could you share a screenshot of how the Excel step is set up? Don’t forget to remove or obscure any personal or private information in any screenshot you share in the community (eg full name, email address, etc).

 

Thanks!

 

This is the trigger
This is the “Find”
….and this is the action
Excel sheet

Forsite form (edit mode):

 

Userlevel 7
Badge +9

Hey @Chris.Giles thanks for sending us some screenshots of your workflow! If you edit the “Update Row” step, can you then send a screenshot of how you have the “Row” field set up? I am fairly certain that is the field with the issue but we can only confirm once we see the configuration in “Edit” mode. 

Let us know - we definitely want to get this sorted out for you!