I have a very basic learning management system using a google sheet with several tabs.
I want students to be able to access their personal data without accessing the whole sheet - and being able to see all the personal data of other students.
I think that could be achieved if I merge the relevant data from the sheet tabs into one google doc per student, and just share that one personal page with the relevant student.
The merge needs to be live, and to be two-way. Some fields need to be accessed by students. If a field is changed in the personal page, that change goes back into the main database. That is, if they mark something 'complete' on their personal page, it updates the main table. and also the opposite - if I mark something complete on the main table, it changes their personal page.
I don't really know if such a thing is possible!