Collections question - maybe a little deeper

Get Help
1

Take the following idea:

Have a school (collection)
It has students (users collection)
Each student has a grade (within the users collection)
Within each grade there topics (Math, Sciene, English, Physical Education, etc) assigned to everyone in that grade.
Within the topics, some classes have a mandatory class (Math 101) and are assigned by the school and those are the same for everyone in that grade.
Some classes have classes they student can choose from…For example, Physical education can have soccer, tennis, volleyball, etc…but they have to choose at least one or it shows no class selected
They can also sometimes have two classes in one topic (Math 101, Math 102)

When I want to view the user, I want to see their class schedule in one form where it lists the by topics and then lists the classes within that topic regardless if the student picked it or it was assigned by the school (ideally it would show school picked (required) versus student picked (optional)).

Collections I have:
School - One School, Many users - One School, Many Grades - Many topics, many users, One class, Many users
Grade - One Grade, Many Users - One school, many grades - , many grades, many topics
Topics - One Topic, Many Classes - Many Topics, Many Users - Many grades, many users
Class - One Topic, Many Classes - One Grade, Many classes - One class, Many users

What I can’t figure out is if a student selects a class is for it to put it where I think I want it to be able to display it correctly and basically fill the box.

I am sure it is something simple but I am just not seeing it. Thanks in advance

2

can i see the way you set th database collection ?

the flow is not something too ambigous to achieve just relationships

4

To solve this problem, follow these steps:

  1. Check Database Relationships

Go to Adalo Database and check if the relationships between collections are correctly set up.

Ensure that fields like User ID or related record IDs are properly linked.

If you’re using one-to-many relationships, ensure the correct reference is set in the child collection.

  1. Verify Form Submission Settings

Check if the form is correctly linked to the database collection.

Make sure all required fields are correctly mapped to database properties.

Test submitting data with a test user to confirm if the issue persists.

  1. Use the Correct Data Source in Screens

When displaying data, ensure you are pulling from the correct collection.

If showing user-specific data, use Logged-In User → Related Collection in dynamic data.

  1. Debug with a Test Entry

Try manually adding a record in the database and see if it appears in the app.

If manually added data appears but form submissions do not, the issue is with the form setup.

  1. Test in Preview Mode & Check Console Logs

Run your app in Preview Mode and check for errors.

Open Developer Console (F12 > Console in Chrome) and look for any API request failures.

  1. Ask for Help with Database Structure

If the problem persists, share a screenshot of your database collections and relationships in the Adalo community.

Mention how your data flows (e.g., “User submits a form → Data should be stored in Collection X → Displayed in Screen Y”).

If you provide more details about your database setup, I can help you write a more precise solution!

5

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.