Hi, new to airtable. So I have three tables, A. Subjects, B. Teachers, C. Activities.
In table A there’s ‘taught by’ column linked to the teachers’ name from table B (there might be more than one teachers per subject) and ‘length’ column of the lesson taught (in minutes per week simple number e.g. 15, 60, 75 etc.).
In table C is form submitted by teachers. Linked to the Subject records and contains things like “playing blocks”, “drawing family”, “playing games with family”
I’m trying to
- Show all subjects taught by a teacher in the B table
- Count the total subjects taught by a teacher in the B table
- Count the total hours per week a teacher is teaching in the B table
- Show the count of unique terms/words from table C from the example to get ‘playing: 2’, ‘family: 2’, ‘drawing: 1’ etc. or a word cloud
I tried roll up but it always shows 0 and I can’t find the search term of what I’m trying to do.