How to set up the DB structure to capture participant-level ratings when they are part of a team in a specific meeting
(I am not a technical person, upside_down_face:)
Background:
My app captures team members’ individual ratings for a specific meeting part of a project structure. I need to capture individual ratings to aggregate them further at both the Meeting and Project levels.
The Things I created so far:
Projects (called Project Board) – name, start/end date, description, status, project participants list (team), relates to meetings list
Meetings (called Interplay) – name, due date, descriptions, categories, status, meeting participants list (team), relates to the Project Thing, to the Participant Ratings Thing (list of)
Participant Ratings (called Player Ratings) – meeting name, participant ratings (6 fields), rating status, relates to the Project things and the Meetings Thing (list of)
The path for the User actions:
create Project → create Meetings for the Project → create Participant Ratings for each Meeting.
What I can do successfully:
- Create, save, and modify a Project
- Create, save, and modify a Meeting
- A mechanism to enter the ratings (6 different number values)
Where I have a significant problem is that I am unable to save the Participant Ratings to have an individual DB record representing the relationship:
One Meeting – one Participant – One set of ratings
- The form Type of Content to capture the ratings is Participant Ratings. I can save the ratings in the DB.
- When I save the ratings, I cannot understand the unique Meeting rated link to the unique Participant from the team.
- I cannot save the Meeting name+date even though I have no error presented by Bubble.
I miss something in this structure and cannot figure it out.
One Meeting – one Participant – One set of ratings
Help, please Any thoughts are very much appreciated!
Thank you!