Hopefully this will help.
Step 1. You would need at least the following collections
Where people sign up / login.
#2 Collection B - I will refer to this as Posts
This is the database you should point to when user submit their post.
This collection should have the following properties:
- Post ID
- Post (for text they write)
- Image or some media they upload
Step 2. Go to Collection B and create a relationship property with the Users collection.
This relationship indicates the owner of the post - let’s call this property Posted by.
Users can have multiple Posts, but a Post can have one user.
Everytime you create a record for the Posts collection, you should also update the Posted by with the current logged in user’s user id.
Step 3. Go to Collection B and create another relationship property with the Users collection.
Users can have multiple Posts, and a Post can have multiple users.
This relationship indicates who liked the post - let’s call this property Likes.
You can have a Like button that have action which will update the Post collection to add the logged in user to this Likes column. To show how many likes a post can have, you can use the formula to Count the number of users in the Likes property.