Skip to content
Thåst Docs

Quick start

Source: QUICKSTART.txt in the upstream repository.

═══════════════════════════════════════════════════════════════════
  🎬 GUDSTJÄNST PRODUCTION SYSTEM - QUICK START
═══════════════════════════════════════════════════════════════════


📦 FILES INCLUDED:


Apps Script (copy to Google Sheets Script Editor):
  ✓ Config.gs          - Configuration & constants
  ✓ Database.gs        - Database handling
  ✓ Views.gs           - View generation
  ✓ UI.gs              - Menus & dialogues
  ✓ Triggers.gs        - Event handlers & API


Documentation:
  ✓ README.md          - Full documentation
  ✓ DEPLOYMENT.md      - Deployment guide (read this first!)
  ✓ SUMMARY.md         - System overview
  ✓ LICENSE            - MIT licence


Support:
  ✓ .gitignore         - For Git repository


═══════════════════════════════════════════════════════════════════
  🚀 DEPLOYMENT (10 MINUTES)
═══════════════════════════════════════════════════════════════════


STEP 1: Create Google Sheet
  1. Go to https://sheets.google.com
  2. Create new spreadsheet
  3. Name it "Worship Service Production - Caroli Church 2025"


STEP 2: Open Apps Script Editor
  1. Extensions > Apps Script
  2. Delete default Code.gs


STEP 3: Copy code files
  1. Create 5 new script files (.gs)
  2. Copy content from:
     - Config.gs
     - Database.gs
     - Views.gs
     - UI.gs
     - Triggers.gs
  3. Save (Ctrl+S)


STEP 4: Bootstrap
  1. Close Script Editor, return to Sheet
  2. Reload (F5)
  3. System > Bootstrap Database
  4. Confirm
  5. Wait 10-20 seconds


STEP 5: Generate views
  1. System > Generate All Views
  2. Wait 5-10 seconds


✅ DONE! You now have:
  • 6 hidden database sheets (_DB_*)
  • 4 programme views (Programme 1-4)
  • 1 recording schedule
  • 1 overview dashboard
  • 1 credits list


═══════════════════════════════════════════════════════════════════
  📖 FURTHER READING
═══════════════════════════════════════════════════════════════════


DEPLOYMENT.md    - Step-by-step installation with screenshots
SUMMARY.md       - System overview, architecture, comparisons
README.md        - Full user guide and documentation


═══════════════════════════════════════════════════════════════════
  🎯 NEXT STEPS
═══════════════════════════════════════════════════════════════════


1. Configure programme metadata:
   Settings > Edit programme metadata


2. Add people:
   People > Add person


3. Create first post:
   Posts > Add new post


4. Test the workflow!


═══════════════════════════════════════════════════════════════════
  💡 TIPS
═══════════════════════════════════════════════════════════════════


• Database sheets are hidden (but not locked)
• ALWAYS edit via views, not directly in database
• Running time is calculated automatically
• Status colour-coded: yellow = recording, green = complete
• Back up regularly: System > Backup to JSON


═══════════════════════════════════════════════════════════════════
  🆘 PROBLEMS?
═══════════════════════════════════════════════════════════════════


Read DEPLOYMENT.md section "Troubleshooting"


Common issues:
  • Menu doesn't appear → Reload (F5)
  • Bootstrap fails → Check all 5 .gs files exist
  • Views empty → Run Bootstrap again


═══════════════════════════════════════════════════════════════════
  📞 SUPPORT
═══════════════════════════════════════════════════════════════════


GitHub: https://github.com/FiLORUX/the-public-service
Email: david@thast.se


═══════════════════════════════════════════════════════════════════


Built with ❤️ for broadcast excellence
David Thåst • 2025