Over the past few months we've rebuilt how formula and equation fields are processed and updated. We're excited about the improvements and have rolled this out to limited users. We've heard raving feedback and we are now eager and ready to push the update to more users. If you'd like to test this, please let our support team know along with the URL in your builder of the app.
- Cascading Updates - any field that depends on an updated field will be updated, regardless of how many tables away it is from the table being updated. For example, if you have a basic formula that gets updated by a basic formula in the parent table, which in turn also gets updated by its parent, the updates will always be accurate.
- Speed Improvements - in some cases with complex relationships and formulas we've seen speed improvements from 60 seconds to less than half a second! That's not an exaggeration.
- Update Tables - as you can see in the image below, any field that updates an equation and any equation that is updated by another field can be easily seen inside the field settings.
In the coming weeks we intend to also add ability to add custom indexing. This is often required when your tables get into the hundreds of thousands of records. For now, please contact support if you have many records and you're seeing a lag.