Help creating a database for a social group app

Hey Adalo Forum.

I am trying to create an app with groups and members. I for the life of me can’t figure out how to structure my database so any help would be truly appreciated!

Some people get together and they create a group. Basically only one person can create the group (and becomes group leader) but others can search for it and join it. For simplicity’s sake, let’s say the group can only have 5 members.

You press the join button and you get to a page where you can choose your ‘position’ or ‘rank’ in the group which is used to determine a schedule (not relevant at this stage how this works and I haven’t really figured it out yet).

(Also, don’t know if this helps in answering but once someone decides to join, they select a rank and then that information is sent to the group leader, who decides if they want to let this user in or not - would probably need help figuring this out so feel free to share tips if you’re in a generous knowledge sharing mood).

Once a person is approved as a member, that rank is no longer available and this is reflected in the list of ranks the next potential member can choose from.

Once someone visits the group’s page, they can see people who are members of this group as well as their rank in the group. This way, the person can see the available ranks and decide if they want to join the group or not.

What I am trying to figure out is how to structure the database to accomplish this.

I tried making empty columns in the table for the different ranks and simply updating via form when someone selects a rank. But then I don’t know what to do when I want this to be reflected in the group page (I want it to be a list so its dynamically updated).

I also tried creating a collection of members and creating a new record every time someone joins a group. This member collection is linked to users and groups collections. In this case, I don’t know how to make the occupied ranks unavailable to the next potential members.

I can try to share some screenshots of how I’m trying to work but I don’t know if that would help much.

Please let me know if you have any tips, suggestions, comments or anything that would help me get past this. I don’t want to come across as thick but I’ve been on this for a couple of weeks but I still can’t figure it out. I’ve seen lots of helpful posts on here so thought I’d try asking you guys.

I’ve already made an app with Adalo that is on the playstore so I get the core concepts but still completely lost. HELP PLEASE!

Thanks in advance!!

Hi AJ,

Welcome to the Community! :partying_face:

I would suggest watching this video to help.

1 Like

Hi James,

Thanks for answering. I’ve already seen that but I think I might need to redo everything with my current app idea in mind.

I’ll give that a shot!

/AJ