Good question, @Blake! Newly-created spreadsheets— whether started from empty sheets or from the new Foundation template— have a few key differences from legacy sheets:
- They are fed by the Tiller Feeds add-on (rather than the feedbot)
- The sheets contain metadata to identify templates and track versioning (for dependency & upgrade/restore management)
- The Balance History is keyed on
Account Idrather than
The fact that your legacy spreadsheet runs on the feedbot (1) isn’t a showstopper for integrating with Tiller Labs… but the other two issues (2 & 3) do need to be addressed.
The second issue is easy to resolve by “adopting” your existing core sheets—
Balance History and
Categories. The Tiller Labs adoption process allows the user to identify sheets with these names as approved substitutes for the versioned masters that the add-on typically inserts. When you open the Tiller Labs add-on, if these core sheets haven’t been heavily modified, you will be prompted to adopt them.
The third issue is the clumsy one. Architecturally, we have moved away from using
Index as the unique account identifier. Where many older templates used the
Index column to uniquely identify accounts, the new templates available within Tiller Labs expect to find the
Account Id with unique keys for each account.
The biggest challenge in migrating your feedbot spreadsheet to Tiller Labs will be retroactively creating a viable
Account Id column in your Balance History sheet. @heather has provided a help article with the steps here:
As for the timeline, I’m confident we will get to it, but right now we can’t offer a firm commitment.
Before committing to a migration, consider creating a temporary new spreadsheet with Tiller Feeds and Tiller Labs to give the new platform a try. I think you will like it.