New Improvements to Tiller Money Feeds Key Feature
We’ve been working hard to address some issues with the fill process in Tiller Money Feeds. The biggest one being timeouts for some customers using Google Sheets when trying to fill a very large amount of data combined with an already large data set and complex dashboards. This “fill crash” has been a challenging bug for many of our long time customers for a while and we’re excited to announce that we believe we have pushed a change that should address this issue going forward.
Please let us know if you run into new issues or odd behavior with the Google Sheets fill. We did our best to test rigorously before pushing this change, but there’s always a chance some edge case slips through.
As a part of this initiative we also increased the frequency of the Auto Fill for Google Sheets from once per day to about every 6 hours. Keep in mind that some accounts still require you to manually refresh before the data is available in our system to fill, but this should make the data we can fill more timely.
If you already have Auto Fill enabled the next time you Launch Tiller Money Feeds it should automatically switch your Auto Fill from the once a day to four times a day fill. You do need to launch the add-on or manually toggle Auto Fill off/on in order to access this update. You can read more about how Auto Fill works on our Help Center.
As a part of this initiative we also made changes to the Microsoft Excel fill so that behind the scenes both platforms are using as much shared technology as possible. This makes it faster and easier for our engineers to iterate on one of our most crucial features. For most this change was not noticeable.
While we hope to one day offer Auto Fill for workbooks stored on Excel Online, we don’t have that as a near term priority and we are unable to automatically fill data into workbooks only stored locally on a customer’s computer.
If you have any feedback or questions about this update, feel free to reply below.
Start Your Free Trial
Keep a clear, confident view of all your money in one place, with flexible templates, powerful privacy, and top-rated support
This is great news, i was considering splitting my sheets for the new year and starting fresh due to this constant timeout issue not allowing fills to complete. Thank you for this work.
Thanks @bentyre1 ! Please let me know if you find it’s still crashing on you with large datasets as our intent with this was to fix that specifically!
Hmmm, I’m not sure how I feel about auto-fill every 6 hours. I kinda liked knowing the auto-fill happened at a predictable time when I wasn’t interactively using the sheet. I’m not sure I’d want auto-fill kicking off randomly while I’m in the middle of doing something with the sheet. How about adding some user control options?
Also, will
Date Added
be the user spreadsheet time zone or UTC? i.e. will a USA nighttime auto-fill have a tomorrowDate Added
.Thanks for your feedback @Mark.S - I also was curious what might happen if the Auto Fill kicks off and someone’s actively in their sheet doing things. I know if the sidebar is open it will block certain operations. I’ll add a feature request for a user control around this. I do know that the 6 hour timing is decided by when you toggle on the Auto Fill so you could sort of control when it’s going to happen (and know/predict) by toggling the Auto Fill off then on at a time where the 6 hour intervals are less likely to disrupt your work in the sheet. E.g. If I toggle it on at 10:30 AM I’d expect it to run around 4:30PM, 10:30PM, then 4:30AM.
I don’t believe we changed anything with the dates/Date Added so I expect it will continue to work the way it has been working, but I’ll double check.
Thanks for the work on this, @heather. While we’re discussing improvements to Tiller features, any chance we’ll get a Refresh All button at any point? Will Yodlee just not allow it? I’d actually have more use for that than auto-fills every six hours.