Hi, I’m new to Bubble. Its fantastic, but struggling a bit with the database side of things. I hoping one of you lovely people may be able to help me, or point me in the direction of relevant resources.
I’m creating a basic marks app for a school.
The teacher needs to be able to input marks for each student, for different subjects, for different weeks. Here is how it looks so far. Basically the teacher selects the week and then clicks the arrows to assign marks.
What I can’t figure out is how to structure the data. I want each week’s mark to have an individual entry for each subject, so that the teacher can track how a student did in an individual week. So ‘Marta’ might get 2 in Math in week 1, 3 in Math in Week 2, etc.
I thought I might be able to store the marks as a list of numbers, e.g. Marta’s ‘Math marks’ might be: 2, 3, 1 etc. When I do that I can display marks entered into the data tab, but I can find a way to edit existing data (or example if Marta does something great in science and the teacher wants to give her an extra mark, on top of two marks she received earlier that same week). I can add new marks, but not edit a specific #item that is determined by the week dropdown.
I’m sure there must be a alternative way to do this, but I can’t figure it out.
Can anyone help me structure this data? It would be much appreciated.