Dec 07, 2022 04:46 PM
So I have the following tables:
Teachers (can have many students)
Students (have only have teacher for each student)
I'd like to create a form where if I choose a teacher (or multiple teachers), it shows only their relevant students in a dropdown.
Is this possible?
Dec 07, 2022 06:10 PM
This isn't currently possible with Airtable forms because the form only provides a limited live look at the underlying data. I believe this can be done with some third-party form systems (JotForm and On2Air:Forms come to mind).
However, I believe this could be done using a custom interface. The method that comes to mind most readily is to use the "Record review" interface style, with the student records driving the contents. A filter could then be added that would limit the displayed students based on the link field that points to the selected teacher.
Dec 08, 2022 09:30 AM
Can you elaborate on the custom interface? or have accompanying links to further read that approach?
Dec 09, 2022 08:22 AM
Here's the support page where you can learn more about using the Interface Designer feature to create a custom interface: