Lesson 10: User Experience (UX) Improvements (AppSheet Tutorial)

Full Course Outline and Materials Available Here: https://www.firesofalchemy.com/appsheet-tarot-app In this lesson, we focus on user experience. First, we update the Reading view so that the main image always shows the last card pulled, making readings feel more dynamic as you add cards. Next, we refine the Pull Reading button: instead of always overwriting cards without warning, we design two versions—one that runs instantly on a blank reading, and another that asks for confirmation if cards already exist. We also polish the layout by making buttons prominent, customizing confirmation messages, and ensuring the Quick Pull button is accessible from anywhere in the app. Finally, we improve consistency by renaming actions (e.g. “New Reading,” “Pull Cards”) and re-ordering fields so the card list displays more clearly at the top of each reading. 00:00 Intro 00:13 Virtual column for last pulled card 00:48 INDEX + COUNT formula explained 01:36 Updating the image column to dereference last card 03:06 Making Pull Reading button prominent 04:19 Problem: overwriting existing cards 04:36 Using Google Sheets version history as backup 05:32 Adding confirmation to Pull Reading button 06:10 Show If with ISBLANK / ISNOTBLANK) 10:01 Adjusting view actions & button placement 11:34 Custom confirmation message text 12:45 Adding Quick Pull button to all views 14:19 Hiding helper columns & cleaning layout 15:00 Renaming buttons: “New Reading” & “Pull Cards” 16:41 Reordering Reading detail view for clarity 17:27 Wrap up – UX polish complete 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 What’s Covered in Lesson 10 • Build a virtual column that displays the last pulled card’s image. • Use INDEX([Cards], COUNT([Cards])) with dereferencing to always show the latest card. • Make the Pull Reading button prominent and user-friendly. • Duplicate and conditionally display buttons with ISBLANK([Cards]) / ISNOTBLANK([Cards])). • Write a custom confirmation message warning users about overwriting cards. • Add the Quick Pull button to multiple views for easy access. • Clean up display names (“New Reading,” “Pull Cards”) for consistency. • Adjust the Reading detail layout so the cards list is the main focus. 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