I stumbled upon a conceptual roadblock and before I start building the website I would like to know if it’s possible with the Webflow CMS.
Let’s assume that teachers and students can log on a website - the teachers see the tests and the students that took part in them. Next to the students’ names the teachers could see their score in % points (see jpg below). The test answers and the scores would be stored in Google Sheets, therefore an Integromat integration would be essential.
In terms of the CMS, I would have following collections:
- Users - for storing both students and teachers
- Tests - for storing the test info + multi-reference field for the students that took the test
But here comes the question - how to assign the score to the user (student) who is already a reference to another collection? How would you go about that idea?
I’d be super grateful for suggestions