I think there are a couple of ways to approach this so I wanted to check in with the experts here first.
I have a social app where a user can add a group. The
Groups sheet contains important info about the group and a separate
Members sheet contains a list of people, the groups they belong to, if they are an admin of said group, etc. (Groups can have multiple admins).
When a new group is created, I want to also create a new row in the MEMBERS database for the creator / admin.
What do you think would be the best way to pull this off? The group will get “orphaned” if it does not have a member, so the row in
Members needs to be created immediately.