I read @ianhyzy’s post about how you can use Glide to make editing transactions in your Tiller sheets on mobile really nice and easy:
Ian provided some general information here, but I thought I’d share my experience.
Overall, working with Gilde was great. Within 15 minutes, I had my own Tiller Mobile friendly app. But there are some things you should know.
I was able to quickly create a free account at Glide here. With a free account, you can have unlimited apps, but there is some Glide branding. For $19 a month, there is no Glide branding, there are more component options and some other features.
It was helpful to watch the 90 second video on the home page. I also looked around the Introduction to Glide page.
When I felt ready to create my own app, I selected the + New app box. It presented me with a list of my Google Sheets. I then selected my main Tiller spreadsheet.
The first thing you should do is set the Privacy
setting. Click the Settings
link on the left then the Privacy
tab on the right. Privacy options include Public, Public with email, Password and Email whitelist. I chose Password. There’s more info in the documentation here about what each one does.
My next step was to look at the Tabs
settings, clicking on Tabs
on the left. Glide works best on sheets when Row 1 contains Column Headers and the rest of the rows have column data. So, the Transactions sheet and the Categories sheet worked well. But other sheets, like Insights, Monthly Budget and many others don’t work.
You can decide which sheets to display in the Tabs
sections. If you put a sheet under Tabs
on the right side, it will show up at the bottom of the screen. Other sheets can be put under the Menu
section. They show up under the hamburger icon on the upper left corner in the app. Other sheets can be Hidden
. You can drag and drop each sheet into the section and order you want.
Once I decided on my Tabs
, I got to work on the Layout
section. You can choose from 8 different Layout styles. The Calendar
option worked great for Transactions. You can also add Features
like a search bar or sorting order under the Features
tab. The Add
tab lets you add data, such as new Transactions.
If you click on a single transaction, you can see options to adjust the Layout
and decide whether to allow users to edit or delete data.
I wanted to add the ability to categorize my transactions. When I first looked at the Edit Layout
, it let me edit the text in the Category field, but it didn’t give me a dropdown list of all the category choices.
I was able to add this feature by selecting the blue plus sign
in the upper right of the Components
section on the Edit item page and adding a Choice
component. That let me select the Categories sheet
as the Option sheet
and Category
as the Options column
. Since the Categories sheet Category column lists all my categories, all those categories became available in the dropdown list in the edit mode.
Once I got the app designed the way I wanted, I went to the Share app
link on the left. Using my iPhone’s camera, I aimed it at the QR code on the screen. This opened a link in Safari and let me add the App to my iPhone Home Screen.
There is no SAVE app button. Glide seems to automatically save the settings and any setup you create for the app. If you make changes, you need to download a new version of the app and delete the old one.
As new data comes into your Tiller sheets, that data will automatically be fed into your new Glide Tiller mobile app.
Give it a spin. It turns Tiller into a very useful mobile app. Let us know how it works for you.