Virtual Columns, Formulas & Theming
IN THIS LESSON
Learn how to reference cards from your deck, add a new view, and create an action button to pull random cards.
In this lesson, we upgrade our tarot app by replacing image links with a high-quality Rider-Waite-Smith deck from the Internet Archive, fix missing court cards, and then build a brand-new Readings table. You’ll learn how to reference cards from your deck, set up a readings view, and start creating an action button that pulls random cards. This is the foundation for making your app actually give readings.
What you’ll learn in this episode:
• Finding and downloading a Creative Commons Rider-Waite-Smith deck (public domain)
• Replacing your old card image links with the new high-res scans
• Troubleshooting missing Page, Knight, Queen, King entries left out of the spreadsheet
• Using Google Sheets formulas (JOIN, CONCATENATE) to clean up file names
• Creating a new Readings table with ID, title, cards, and interpretation columns
• Setting up an enum list reference so readings can pull cards from your deck
• Adding a Readings view in AppSheet navigation
• Writing expressions for suggested values (linking to Deck IDs)
• Introduction to Actions: adding a “Pull Cards” button that randomly selects cards
• First steps towards using user input (“How many cards?”) to generate multiple random pulls
• Troubleshooting formulas and seeing how iteration + trial/error shapes the build
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.
