Data flow or Database issue? How do I fix this?

Get Help
1

Hi team, I kindly need your help. I aim to build an App with three collections; County, School, and Student. I aim to display individual student records, firstly by hitting a desired county name and it should display all the names of the schools within that county. Secondly, a click on a desired school name should take me to a list of students within that school, and lastly, when I also click on a student name it should finally take me to that student’s records.

I have tried all alone but what comes after all of the clicks is: a list of all the counties’ names ‘That’s fine’ and it is what I expected but badly, when I click a county name I only get in return a list of all the schools name in all different counties instead of just the names of schools from within that county and it does that well for the list of students when I also click on a particular school, it returns a list of all the student’s names from all different schools from different counties, that which I don’t want.

I don’t know what I am getting wrong please help me:
I hope this explanation is clear and will help you understand the way out to assist me

Please see the attached video:

2

Hii @Zeahn ,

Are you filtering by CURRENT “Country” or CURRENT “School”?
And other Q, are you using RELATIONSHIPS between Databases?

In this case I think you need to create a relationship between the databases “Country” and “School”, indicating which SCHOOL belongs to one Country.

Then create another relationship in “School” and “Student” databases indicating which STUDENT belongs to one School.

And remember to apply FILTER on the lists used with CURRENT “Country” or CURRENT “School”.

Hope that helps!

4

Thanks so much dear, I have done all of what you talking about, the database and relationships aspects and have gone through lots of tutorials on that and did exactly all of what I got from the tutorials to get it work responsively, still it doesn’t. The frustrating thing is, it works at some point in time and suddenly stop working most especially when I set up the Admin and Users screens feature, that’s the time you will stop seeing current school and student, you will stop seeing anything that has to do with “Current” than you will notice that the data will stop flowing.

This is frustrating it has caused me to spend nearly 4weeks now on this one App, like this, how will I work on others Apps, I wish if Adolo suport team or experts can set up a day in a week to have zoom discussions for their users most especially new Adalo users to learn from them and share their concerns.

5

Can you send me a preview link to check out your app ?

Remember that relationships “broke” when you navigate to a number of different screens.

6

Ok, I will send you a preview link. I don’t really have many screens I think it something like 9 or 10 screens. However, I will do just as you said so you can take a look.

7

The problem you describe is related to the incorrect configuration of “relationships” or the application of filtering rules in the Adalo platform. Here are the steps you can take to fix it:

Root causes of the problem
Lack of proper relationships between collections:

The collections “County”, “School” and “Student” must be properly linked using Relationships. If the relationships are not configured correctly, the system will not be able to link the data properly.
Incorrect filtering criteria:

If the filter is not applied to the selected “County” or “School”, the system will return all results from all records.

How to configure the database and filters correctly

  1. Creating Relationships
    County collection:
    Create a Schools field with a One-to-Many relationship with the School collection.
    School collection:
    Create a “Students” field with a One-to-Many relationship with the “Student” collection.
    Also add a “County” field with a Many-to-One relationship to associate a school with a specific county.
    Student collection:
    Create a “School” field with a Many-to-One relationship to associate a student with a specific school.

  2. Filtering data by relationships
    Once you have the relationships configured correctly, make sure you have set up the right filters:

County screen:

Display a list of all counties from the County collection (no additional filters are required).
School screen (click on County):

Configure the filter to show only schools that belong to the selected county:
Filter the Schools collection by the “County” field:
County = [Selected county]
Student screen (by clicking School):

Filter the “Students” collection by the selected school:
School = [Selected School]
Individual Student (click Student):

Displays the individual student record that is directly related to the selected student.
3. Transfer of the Selection via screens
For filtering to work correctly, you must use the Magic Text or Logged Data function to transfer the selected item (e.g. county, school or student) to another screen. Here’s how to do it:

County screen → School screen:
When you click on a county, pass the selected County to the School screen as a context variable.
School screen → Student screen:
When you click on a school, pass the selected “School” to the “Student” screen.
Student screen → Student details screen:
When you click on a student, pass the selected Student to the Student details screen.

Typical error: unused links or missing filters
If the data filters are not properly set or the relationships are not configured, the system will return all records but not the related data. This explains why you see a list of all schools or students regardless of the selected county or school.
Conclusion
Solving this problem requires two things:

Properly configure the relationships between the County, School and Student collections.
Use filters and pass the selected items through the screens so that only related data is displayed.
If you are still experiencing problems after making these changes, it may be worth checking that all links and filters are properly combined and passed using the Magic Text function.

8

Data flow break or breach issue

Hi Sir,

Please I seriously need your help and support on the data break / breaches issue in building an App. I have consistantly been experiencing this during my App building process.

Because I am unable to sort out the problem or find out where the issue lies I have to delete all of my 50 to 65 screens that was working perfectly from the initial and start afresh after working for like 2 to 3 weeks or month.

This Problem is scaring me and rendering inconfident of my App, not want show it to people because it might shame me at any time or at the end.

The annoying part is that all of the screens will be connected, passing all the current data from screen to screen, with the App working as expected for like weeks, then out of sudden the data flow will break and you will stop seeing current data when you try to add new screen.

How do I know the cause in order to go straight when it happen any time to sort it out instead of deleting the entire App to start all over?

Please sir, this issue is really frustrating my efforts, your assistance is very cardinal in my case.

Thanks and hope my problem will sorted out.

9

The problem often starts from the school collection. The County screen which is the home screen can send the current county data to school screen but its the School screen that is not sending current school data to student screen and all current data from one screen to another with the same database setup and App was working perfectly before but out of the sudden it stopped sending current data. So then where does issue lies between County and school, can’t understand Adalo is really giving me tough time.

10

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