Course Roster form

[Luis_Jimenez]

Hello,

I organise classes and I am building the base to manage them. I created several tables:
students
instructors
Course catalogue
locations

all those tables are joint in another one called “groups” that is where I create the class that is going to be held on a certain date, by certain instructors and with x students. Sometimes the students are going to be enrolled by me, and everything seems to be ok: if a student is not in the students table already, I can add it.

But I want to be able to send to the instructor a form so that, at the end of the course, he can add:
name, ID card number, if the student passed or not the exam, and the roster scanned.
I don’t want him to see all the fields that I have populated already.

Sometimes the instructor is going to have several classes forms on hold. He has to know which is he fulfilling.

But, if I create a form, it is as if I pretended the instructor to create a whole new group. I don’t know how to send a form of a group that I have created already, so he can add the pending data, and I don’t know how is he going to add the students checking if they are in the Base from a previous class.

I don’t know if I managed to explain well my needs and troubles. :frowning:
Thank you in advance!
Luis

[Elias_Gomez_Sai]

Why do you don’t create a form on the Students table, so the data goes directly to the correct table? You don’t need an extra table, when you share a form, the user does not see any data.

Por cierto, si quieres hablamos en castellano jeje.

[Luis_Jimenez]

Hola Elías! you are right, but: how am I going to be able to know which students are the ones that the instructor has introduced through the form? what happens if a student was in the table already? it seems that will be duplicated.

[Elias_Gomez_Sai]

I think that AirTable simply doesn’t have the deep permissions control that you need. I think the appropiate is to create a form for the Groups table (I would call that table ‘Classes’), so the Instructor could create his class and add the existing students. He should create the missing students in the previuos Students form. The “problem” is that in the search results some fields of the Students are shown, and could be a lack of privacy.

Anyway, I’ve just realized that if you need to have a evaluation of every Student for every Class, you need another table called for example Attendants, with two relations with them. I would create the Class for the Instructor (forgetting the Class form), and then I would let him to create the attendances in that last table with a form. Again, if the Student does not exist, he could create it with the Students form.

How do you know which students have been added? I think the Instructer would be able to link them to the correct Class. If not, you have a previous big problem haha. About the duplicates, I think it is easier the filter duplicates having them in the same table: sort by ID (or even name and surname), group by ID (so you can detect with ones are repeated), and delete what you want.

By the way, the shared links is no longer valid. Could you share it again so I can explore and understand better?

Bueno, he ido haciendo una base para hacer pruebas y te la dejo para que le eches un vistazo si quieres. Pongo esto en castellano porque es el idioma de la base. https://airtable.com/invite/l?inviteId=invFbdfBq8B3eMODE&inviteToken=aefd0a7a8084066dc7e66ce13fc00e7...

[Luis_Jimenez]

https://airtable.com/shrbP2OKMcSkBtHek