Lesson 6: Related Lists, Smarter Image Formula, Debugging Pull Card Button (AppSheet Tutorial)

Full Course Outline and Materials Available Here: https://www.firesofalchemy.com/appsheet-tarot-app 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. This episode is all about tightening your build, learning to troubleshoot, and polishing your user experience. 00:00 Intro 00:37 Refining Virtual Columns 02:10 Interactive Related References 02:35 Future Dashboard w/ Clickable Bar Charts 03:14 Updating Image Virtual Column 05:11 Fool-proofing Pull Card Button Formula 08:11 Adding IF() evaluation to formula 11:33 Improving code efficiency 13:00 Pull Card Button Fixed! 13:34 Tidying Up Card View and Titles You may purchase direct access to the project to support future lessons. Access enables you to clone the entire Appsheet project and modify it as you wish. You will maintain access as the template is updated in future lessons, you can clone as many times as needed. Purchase here: https://buymeacoffee.com/firesofalchemy/e/448459 Appsheet Consulting and Troubleshooting https://buymeacoffee.com/firesofalchemy/e/449624 What’s Covered in Lesson 6 • 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 Resources mentioned: • https://appsheet.com • https://sheets.new CC0 - Creative Commons Copyright Free High Quality Tarot Deck Scans Available here: • https://archive.org/details/rider-waite-tarot/ Follow Fires of Alchemy https://www.firesofalchemy.com ~ For more insight into my style of readings, the history of tarot and more - see my website below: --- https://www.firesofalchemy.com/blog/tarot 🃏 --- Support future readings and expanded content 🤝 https://buymeacoffee.com/firesofalchemy #TarotApp #AppSheet #NoCode #TarotTutorial #PocketTarot #DIYApp #FiresOfAlchemy