Virtual Columns, Formulas & Theming
IN THIS LESSON
We polish up the look and feel of our tarot app.
You’ll learn how to make your app visually engaging by theming colours, adjusting icons, and displaying images dynamically using virtual columns. We’ll also add a timestamp column to track when each reading is created, and discuss when to use virtual vs. real columns in your Google Sheet. By the end, your app will not only work—it will look and feel like a professional, custom-built tool.
What you’ll learn in this episode:
• How to add and configure virtual columns to pull dynamic content (like the first card’s image)
• Using dot notation to reference related data (e.g. [FirstCard].[Image])
• The difference between virtual columns and spreadsheet columns (and when to use each)
• Adding a timestamp column with the NOW() function to log readings
• Sorting readings by newest first
• Customising the app’s look with themes, logos, and colour schemes
• Updating icons and positions in the navigation bar for a more polished UI
• Troubleshooting common issues (like list formatting causing sync errors)
Want to skip a few steps?
Jump straight into a working version of the app.
By purchasing access, you’ll unlock the current AppSheet project template + full project folder contents—including the tarot deck spreadsheet, card images, descriptions, and other assets.
⚡️ Live updates included
This isn’t a static file—the template is updated every time a new lesson is released. You’ll have ongoing access, so you can come back any time, clone the latest version, and see the new features in action.
🎨 Yours to customise
You’re free to modify, expand, and experiment with the template however you like. The idea isn’t just to hand you a finished app, but to give you a live playground where you can learn by doing and build confidence in your own no-code skills.
💡 Pro tip: Start with a simple goal. Maybe it’s adding your own custom card deck, building a new button, or creating a new layout view. Use the template as your foundation, and let each step spark ideas for what else is possible.
