Slow row-based automation

When I test an automation, based on a row change, it runs instantly. But if I then activate it and edit a row, it can take 10-15 seconds or so to run. Shouldn’t it run quickly/in real time?

1 Like

Hey @Bruce_Lieberthal, welcome to the Community!

It runs like this because Coda is built that way. Automations run on the server side, not in your browser. This is because automations need to run even if nobody has a working PC with the doc opened in a browser. But changes are not saved immediately to the server. To apply the changes, the server has to basically “open” the Coda doc and calculate all of it. Doing that on each change would very quickly overload the server — imagine having to refresh your Coda tab every time you change a cell value. So instead changes are bundled into batches and applied whenever a server becomes free, using a “fair use” scenario . For smaller docs it could be 10-15 seconds as you said, and for larger docs it could be 3-5 minutes.

When you’re testing an automation, it’s run immediately in your browser, not on the server. Keep that in mind btw because certain things that work well during testing won’t work in a real automation run (most notably the User() function)

I totally support the request to have immediate in-browser automation or recalculation rules. Actually here’s my vision for it:

2 Likes

Hi Paul,
Thanks for your kind reply. This all makes perfect sense and your “On Change” event trigger would go a long way to solving this, I agree.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.