Tracking Work with Lookup Records

Topic Labels: Formulas
764 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m not quite sure how to do this but feel like there is a way in AirTable so I wanted to ask…

I have a Base with three different tables filled with people. In Table C, I have a list of teachers that I have linked to a school leader, Table B, and in Table A, I have a list of District People that are linked to Teachers in Table C.

Records are created in each table based on specific conditions.

How can I help my team track their work?
For example, if they go to Table A and lookup all the teachers associated with a district record on Monday and then a teacher that should be linked with the district record gets added on Tuesday, how can my team when they check on Wednesday distinguish between the teachers they saw on Monday verse the Teacher needing to be added on Tuesday?

Hope this makes sense.

0 Replies 0