We pushed an update to the Tiller Money Feeds add-on today that addresses some slowness with updates when you have a very large transaction or balance history data set and a high volume of accounts connected. In some cases, Tiller Money Feeds was not able to complete the update at all due to the way we were processing writes to the sheet and trying to deal with the potential for data validation errors.
We’ve revised the way the update operation works so that it tries without worrying about data validation issues, and if it fails the failure is captured and then the previous slower process is used to address the data validation issues.
Data validation rules are set up via the Data menu in your Google Sheet and are what creates the dropdown menu in a cell. Most Google Sheets powered by Tiller Money have data validation in the Category column on the Transactions sheet. It’s your list of categories and is populated by a rule for the entire column that references the Categories sheet.
If you’re unfamiliar with data validation errors, they present themselves as little red triangles in the upper right corner of a cell in your sheet. Usually these are introduced when you have a category assigned in the Category column on the Transactions sheet that no longer exists on the Categories sheet.
There can also be data validation issues when the reference sheet for the data validation rule is missing, in which case you just get a “loading…” message when you try to use the dropdown in a cell. In this case, the Tiller Money Feeds update will fail and present and an update error in the sidebar that there is a problem with the data validation in one of the cells with a link to a troubleshooting article.
If you’re still experiencing slowness or failures while updating and have a large data set try correcting these errors and you should find that the updates happen much faster and complete.
Feel free to share any feedback or issues that arise that you believe are related to this release or whether you’re still seeing latency after fixing the data validation issues.