I am facing an issue with the repeating group as it’s showing duplicate items although I have put clear constraints. I have even tried to use the filter, which is slower, but it gives the same results.
In summary, I have built an attendance taking tool for a school. The web app shows a list of the students of a class and then the teacher starting marking the status of each student. That tool is good enough, it works well and serves the job.
My issue now is with reporting the attendance to the school management. I have built a tool that reads the data in the submitted attendance data and displays it in the form of repeating group. I have made sure to filter it by date (which is selected by the user). The problem I’m facing now is the following:
If student XYZ is recorded absent on 2/3/2020 and again recorded absent in 3/3/2020 the name of the student appears twice in the repeating group with the same records in terms of periods. screenshot below.
I hope someone can assist.
I wasn’t able to utilize this. The repeating group data is linked to data source and if I change it to “text” the fields stop showing.
That’s a bit odd. Can you share screen shots of your current data source. That night assist with the trouble shooting.
1 Like
here it is. I can share a link of the app with you if required.
I don’t see why you can’t use the unique elements on students?
Share the app if you like, maybe that will help.
1 Like
here’s the app: https://bubble.io/page?version=test&type=page&name=attendance_daily&id=attendance-testing&tab=tabs-1
It’s really weird behaviour. Sometimes it shows duplicates, other times it does not for some records. I know that the “Unique elements” will fix it, but I am not able to figure how to implement it.
if you want to preview, please use the attendance report for date 2/3/2020 not for 3/3/2020 as that has so many records it will crash your browser.
Thank you for your assist!
Here’s what shows when I try using unique elements
Ok, there is a bit of database clean up that I think will REALLY help you.
I suggest the following:
In your Student Type, make “Student ESIS” the primary field (I assume that you can use as your unique identifier).
Then in your Attendance Report data type, change the Student ESIS field from text to type Student. This way you “link” the attendance type to the student type.
Then you won’t have to do a search for in the first text field in your RG. What you are currently doing will REALLY slow things down and is just generally poor db structure.
Instead, in your text field you will then be able to say something like “Current Cell’s Student ESIS’s Student Name” as you will have access to the student data from your student data type.
And then I am confident you will be able to use the unique elements.
1 Like
I will try that and update you. Thank you so much for the time spent. I’m quiet new to these things and still learning.
I have noticed the difference in loading speed, thank you for your suggestion. I have just tried what you’ve asked me to do, but still unable to use the unique element due to the same issue. Can you please assist? I’m sorry to be bugging you with this.
Also, the student status under the period number stopped appearing.
[edited] ok forget about this one, i fixed it.
I believe that is the right behavior. The type of content will need to change to student, and then you can search for attendance report’s Student’s ESIS2:unique elements.
1 Like
MAAAAAN!! You’re an angel I swear. THANK YOU SO SO SO SO SO SO MUCH. it’s perfectly working as intended. You’re a legend.
1 Like
My pleasure to help. So glad it worked out.
