Crew Rewards

Crew chat, tasks, points, and coverage — one store at a time.

1 Setup SQL

Run this in your Supabase project after the foundation scripts (base schema, Store Settings, schedule entry): open SQL Editor, start a New query, paste the script, tap Run, and wait for Success. It adds attendance marks, task claims, the read functions this app uses, and the starter templates: every store created after this runs starts with a generic pack of everyday tasks and three starter rewards, which the manager can edit or delete like any other task or reward. Stores created earlier don’t get the pack. The script is 907 lines. Safe to re-run — it drops nothing.


        


        

          
2 Connect your project

          
Your Supabase project URL and its publishable key (Project Settings → API). The key is public by design, stays in this browser only, and is only ever sent to your own Supabase project. Anonymous sign-in must be on in the project (Authentication → Providers → Anonymous) or sign-in below will say so.

          
          
          
          
          
          
          

        


        

          
3 Your store


          

          

            

              
Create a store

              
Makes the store and your manager (RGM) account in one go. You’ll get a store code at the end — your crew joins with it, so write it down.

              
              
              
              
              
              
              
              
              
              
              
            


            

              
Join a store

              
Crew and leads: use the store code your manager gave you. Joining on a new phone with the same phone number links you to your existing name on the roster.

              
              
              
              
              
              
              
              
              
              
              
            


            

              
Manager on a new phone?

              
Link this phone to the store you already created, with your store code, phone, and manager PIN.