User-to-User Invitations?

I'm currently learning supabase and am working on a project where I want users to be able to invite others to join their organisation.

A user can only belong to one organisation for now.

Haven't started coding it yet, just thinking it through and looking at the docs. Current thinking is something like:

  • Capture user details (name, email, role).
  • Use Supabase Edge Functions to send invites.
  • Store invites in an invitations table for tracking.
  • Redirect invitees to a sign-up page pre-filled with their details.
  • Assign the role and organization upon successful sign-up.

Am I along the right lines here or way off. Any feedback would be appreciated.