Skip to main content

Best way to display records for others

  • July 25, 2023
  • 3 replies
  • 12 views
J
Forum|alt.badge.img+3

I have a database of students in various "home rooms" each assigned a teacher.  I can easily create a view that shows the students in that homeroom that I can send to the teachers, however, there is one more record in another table that is linked to the teacher that shows their budget of what they can spend each month and how much they get for each class.  How can I send them a "dashboard" that has the records of their students, AND the one record for each teacher that has their budget?

 

Thanks,

Jeff

3 replies

TheTimeSavingCo
Forum|alt.badge.img+31

What if we used a List view? We'd create one view per teacher, filtered to display the appropriate teacher's name

 



Link to base

Adam, Airtable Consultant - thetimesaving.company
V
Forum|alt.badge.img+2
  • VentureOff
  • New Participant
  • 1 reply
  • July 25, 2023

What if we used a List view? We'd create one view per teacher, filtered to display the appropriate teacher's name

 



Link to base


The issue with that, is I need to be able to send this "view" to individual teachers such that they only see theirs and nobody else's.  Plus I need to link that other record from another table.  

 

TheTimeSavingCo
Forum|alt.badge.img+31

The issue with that, is I need to be able to send this "view" to individual teachers such that they only see theirs and nobody else's.  Plus I need to link that other record from another table.  

 


re: The issue with that, is I need to be able to send this "view" to individual teachers such that they only see theirs and nobody else's.

Yeah, we'd create one view per teacher, filtered to display the appropriate teacher's name and send that link?  Apologies, I feel like I'm missing something


---
re: Plus I need to link that other record from another table. 

Are you saying that, besides the "Teachers" and "Students" table, you have a "Budgets" table?  If so, you'd just link the appropriate budget record to the appropriate teacher record, then use a lookup for it, and then display that lookup in the list view

Adam, Airtable Consultant - thetimesaving.company


Terms & ConditionsAccessibility statement