I am working on registration system for a small music school. We have music teachers and sections, a teacher being able to teach different sections (various instruments and workshops) and sections can have several teachers. And we have our users that can choose a section and a teacher.
I have 3 tables : a ‘teachers’ and a ‘sections’ tables that have a link to each other and the ‘registration’ table that gathers all the users choices and has links to the ‘teachers’ and ‘sections’ tables.
I would like to have a fourth table that lists all the users for each teacher/section pair more or less automatically. I am not sure how I can setup this table:
- the first two rows are respectively the teacher and the section. Ideally, an automatic fill of each possible pairs would be nice but it can be made by hand
- more important, I would like to list all the users of the registration table matching each pair teacher/section. Is it possible to filter the whole registration table against the value of the teacher and the section values? I put a link to the registration table but it is expecting a manual selection. Would it be possible to automatically fill the link with the whole table that I could filter in another formula column?
An automation system like n8n could do the processing but I would like to keep things inside baserow as much as possible.