Skip to content

Latest commit

 

History

History
240 lines (184 loc) · 7.07 KB

File metadata and controls

240 lines (184 loc) · 7.07 KB

Frequently Asked Questions

General Questions

What exactly is this system?

It's a collection of Google Forms, Sheets, and Sites that work together to manage school events. Think of it as a free alternative to expensive event management software, built using tools your school already has.

How much does it cost?

$0 - completely free. It uses Google Workspace for Education which schools get free. No hidden fees, subscriptions, or purchases required.

How long does setup take?

2-3 hours for initial setup if you follow the Quick Start Checklist. After that, about 1-2 hours per week during event season.

Do I need to be technical?

No coding required. If you can use Google Docs and follow a checklist, you can set this up. The most "technical" part is copying and pasting one email script.


Technical Questions

Can we use personal Gmail accounts?

For coordinators: Yes, but school accounts work better (higher email limits)
For vendors/volunteers: Yes, any email address works

What are the email limits?

  • Personal Gmail: 100 emails per day
  • School Google Workspace: 1,500 emails per day
  • The system sends maybe 5-20 emails per day typically

Can multiple people manage it?

Yes! Add as many coordinators as needed. Everyone can access the dashboard and help manage the event.

Does it work on phones?

Yes, everything is mobile-friendly. Vendors, volunteers, and coordinators can all use phones.

What if Google is down?

Google has 99.9% uptime. In the extremely rare case of downtime, you can:

  • Access cached data on phones
  • Use printed backups (which you should have anyway)
  • Wait a few minutes - outages are typically very brief

Setup Questions

We don't have Google Workspace. Can we still use this?

You need Google Workspace for Education (free for schools). If your school doesn't have it:

  1. Apply at edu.google.com - it's free
  2. Or use personal Gmail accounts (with some limitations)
  3. Or adapt the templates for Microsoft 365

Can we customize everything?

Yes! Every form, email, and page can be modified. Common customizations:

  • Different stall prices
  • Modified shift times
  • Additional form fields
  • Custom branding
  • Different event types

Can we use it for events other than markets?

Absolutely! It works for:

  • School fairs
  • Sports days
  • Concerts
  • Fundraising events
  • Any event needing vendor/volunteer coordination

What if we already use another system?

You can:

  • Run both in parallel initially
  • Import existing vendor lists to Google Sheets
  • Gradually transition volunteers
  • Export data anytime if you want to switch back

Privacy & Security Questions

Where is our data stored?

All data stays in your school's Google Drive. Google stores it securely with encryption and automatic backups.

Who can see the information?

  • Public site: Anyone can see (just event info)
  • Parent portal: Only people with the link
  • Admin dashboard: Only designated coordinators
  • Form responses: Only coordinators you authorize

Is it GDPR compliant?

Google Workspace for Education is GDPR compliant. You should:

  • Only collect necessary information
  • Inform people how data is used
  • Delete old data regularly
  • Follow your school's privacy policy

Can vendors/volunteers delete their data?

Yes, they can request removal. You can delete individual form responses and spreadsheet rows. See the Troubleshooting Guide for detailed instructions on:

  • Removing single or multiple entries
  • Archiving before deletion
  • Complete data removal for privacy compliance

Event Management Questions

How many vendors/volunteers can it handle?

No practical limit. Google Sheets can handle 10 million cells. That's thousands of vendors and volunteers.

Can vendors pay online?

Not built-in, but you can:

  • Add payment instructions to confirmation emails
  • Link to your school's payment system
  • Track payment status manually
  • Integration with payment systems is possible but requires extra setup

What about recurring events?

Perfect for them! After the first event:

  • Copy the sites for next event
  • Clear old data from sheets
  • Previous volunteers/vendors can sign up again easily
  • Each event takes less time to set up

Can we have multiple events running at once?

Yes, create separate sets of forms/sites for each event. Use clear naming:

  • "Term 1 Market"
  • "Term 2 Fair"
  • "End of Year Concert"

Troubleshooting Questions

What if something breaks?

  1. Check the Troubleshooting Guide
  2. Most issues are permission/authorization related
  3. Everything has a fix documented
  4. Google's tools are very reliable

Who provides support?

This is open-source software, so:

  • Use the comprehensive documentation
  • Check the troubleshooting guide
  • Ask your school's IT support
  • Google Workspace has its own support

What if emails aren't sending?

Most common issue! Solutions:

  • Check spam folders
  • Verify email address in script
  • Re-authorize the script
  • Check daily email limits

Can we test before going live?

Yes! Recommended testing:

  1. Submit test forms yourself
  2. Check emails arrive
  3. Verify data in spreadsheets
  4. Test on different devices
  5. Have a colleague test everything

Advanced Questions

Can we add features?

Yes, common additions:

  • QR codes for check-in
  • Automated shift reminders
  • Vendor ratings/feedback
  • Social media integration
  • Advanced reporting

Can we white-label it?

Yes, you can:

  • Add school branding everywhere
  • Use custom domain for sites
  • Remove all references to this system
  • Make it completely your own

Is there a mobile app?

Not a dedicated app, but:

  • All sites work perfectly on mobile browsers
  • Google Classroom app available for volunteers
  • Can add sites to phone home screen
  • Works offline with cached data

Can we migrate away later?

Yes, you own all your data:

  • Export everything to Excel/CSV
  • Download all form responses
  • Copy all email lists
  • No vendor lock-in

Getting Started Questions

What's the first step?

  1. Print the Quick Start Checklist
  2. Set aside 3 hours
  3. Follow the checklist step by step
  4. Test everything
  5. Launch!

When should we start setup?

  • Ideal: 4-6 weeks before your event
  • Minimum: 2 weeks before
  • Better to start early and test thoroughly

Who should set it up?

Best candidates:

  • Tech-comfortable parent volunteer
  • School admin staff
  • IT support person
  • Anyone who uses Google Docs regularly

What could go wrong?

Common first-time mistakes:

  • Not testing before launch
  • Forgetting to authorize scripts
  • Wrong sharing permissions
  • Not checking spam folders

All are easily fixed!


Still Have Questions?

  1. Check the documentation:

  2. Remember: If you can use Google Docs, you can set this up!

  3. The system is very forgiving - you can't break anything permanently.


Last updated: 2024