Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 10, 2022 02:02 PM
I have several linking records that involve student teachers, what school they are working in, and what times they are teaching. What I want to do is compare one student’s availability with another student’s availability.
I started with this:
But I would like it to look something like :
I thought about using a formula on my first table to create the information :
`
IF(Student=“Student 1”, “Yes”, “No”)
However, that returns “No” for everything. How do I set this up so that I can compare two or three students’ availability while eliminating all the extra information? For instance, if want to compare student 1 or student 3, I don’t want to see student 2’s information. (I am actually dealing with 12 students on 5 different days.)
Solved! Go to Solution.
Aug 12, 2022 07:51 PM
Aug 10, 2022 02:27 PM
Hi @Seana_Evelyn,
You can do this without any formulas. What you need is a junction table, take a look at this explanation as it is very similar to what you are doing: How to Use a Junction Table in your database | Airtable Tutorial - YouTube
Aug 12, 2022 02:05 PM
That was interesting, but it didn’t really meet my needs. When I did a junction table, it just added every student to every time, which wasn’t helpful. It might have been useful if I started the database with that intent. I am not sure. I may just have to redo the whole thing. But I was hoping there would be a better way to organize the information I already have vs. reentering all over it again.
Aug 12, 2022 07:51 PM
IF(FIND(“Student 1”,Student), “Yes”, “No”)