One reliable approach I'm aware of is to use php scripts and cron running on a Linux server. That really sucks to have to deal with so much overhead outside of QuickBase, but it works well and reliably.
I have spent a lot of time over the last month trying to get the new connected table hourly refresh mechanism working reliably, along with some related actions and webhooks. This would save a ton of time and complex scripting if I could get it to work reliably, but alas. There is one known bug with connected Gmail tables that QB development is going to fix within the next week (just heard this piece of information this morning), but the other issue/limitation I have is the arbitrary limit of a maximum of 10 per second for actions firing. When a connected Gmail table refreshes hourly, in our app's case there will be about 100 records that get instantly created. Actions tied to this just choke and give webhook errors (some of the time and somewhat randomly). So I am having to resort to scripting to overcome the Actions/Webhooks limitations, and hopefully when they fix the connected table bug with Gmail, at least I can get it to refresh hourly. Otherwise, about $3000 of additional scripting to reinvent the wheel on that plumbing.
In my opinion, this is a big weak area right now in Quickbase, and my hope is that they will come up with a more robust native solution that doesn't require scripting and php servers.
