Virtual Columns, Formulas & Theming
THIS LESSON
Is all about tightening your build, learning to troubleshoot, and polishing your user experience..
In this lesson, we refine the tarot app by introducing related lists and improving how images display. You’ll see how to build interactive references between readings and cards, making your app clickable, connected, and future-proof for analytics like card frequency graphs. We’ll also revisit the “Pull Cards” action button, fix the comma bug with an IF expression, and adjust the layout so your app always displays cleanly.
What you’ll learn in this episode:
• How to create a Related Cards list (manual reference column) for interactive navigation
• Using the ANY() function to display images from a list dynamically
• Why related lists unlock dashboards & graphs for card frequency tracking
• Cleaning up the “Pull Cards” button with an IF/ISBLANK expression to prevent errors
• Tips for debugging AppSheet formulas (brackets, logical values, expression tester)
• Adjusting your view layout when a virtual column is removed
• How to make your app more fail-safe and future-ready by improving the code step by step
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.
