The way I did it parses the split string to calculate the difference amount. By putting the number first, I’m able to get the string to number converter to work. This way, I can split the transaction by any amount I’d like and not just in half.
A quick note for Appsheet users, if you change a category name, merge categories or add categories in Tiller (using the Merge tool or otherwise), you’ll need to regenerate the structure of the Transactions table in your Appsheet application to view these Tiller changes appropriately in any AppSheet views based on that table.
I have a view in Appsheet based on my Tiller Transaction table that offers a roster of my Tiller transactions by category, and until I regenerated the structure of this table in AppSheet, the new or changed categories coming from Tiller appeared wrongly at the bottom of the alphabetized list in that Appsheet view.
Regenerating the Transactions table in Appsheet after the category changes are made in Tiller refreshes the changes and corrects this error.
In Appsheet: Data | [Transactions (table name)] | View Columns | Regenerate Structure
(Note: Regenerating the structure of a table in Appsheet overwrights any customizing you may have done to column headings…)
1 Like
Like I suspect is the case with most Tiller users, I’m not completely unsophisticated. But I continue to look for a seriously user-friendly Mobile tool. (Way more so than this cool effort.) Thanks for all folks (and Tiller’s review of its own sponsored) exploring development of such a mobile version/option/viewer.
2 Likes
Hi @richardpeng! I tried to demo this app, but (unsurprisingly) 2 years looks to have broken the link. Would you be willing to try to share again? Thanks!
Which link is broken for you? I was able to load both the AppSheet link and the Spreadsheet links
This is cool. I just did something similar with streamlit and python scripts. The app pulls the data from the tiller sheet through a secure google sheets api and visualizes the expenses etc.
1 Like
Do you sell this platform? What would be the difference when compared to Google Looker Studio?
The platform is free and is called streamlit. I think the big difference is that steamlit is fully compatible with python. Note sure about the one you mentioned.
Inspired by this posting, I have created a Medium Create an AppSheet Budget Tool Tutorial.
1 Like
This is a great tutorial series. Looking forward to the Tiller-compatible split transaction details.
Thanks! Is your interest in the Tiller Split compatibility simply curiosity, an intention to use both, or just the desire to one-time convert tiller splits to AppSheet splits?
If it is the last, a couple spreadsheet formulas could extract a split ID and Split Sum pretty quickly and then you can use the API going forward.
It’s mostly curiosity. I have an Appsheet front end but haven’t dug into using it to split transactions. I regularly split them via the Tiller sidebar on desktop.
I have updated the tutorial with instructions on how to have a split compatible with appsheet.
This is great but when will Tiller start creating a “template” within AppSheet and then allow addons to it similar to how they do with google sheet? This could be game-changing