I have this website set up with different collections that cross-reference each other. The Events collection shows events that are taught by different teachers, so it pulls data from the Teachers collection (teacher photo, name, location, etc.) and now I want the teachers list to be able to tell if they have an event that’s posted and show that on their teacher card on the teachers page — basically I would just selectively show/hide a box to show whether or not they have an event posted, like so: https://www.screencast.com/t/D6chuycZE
But when I try to use conditional visibility to show the “events posted” div only for those teachers who have an event set, I don’t see that as an option (since there’s not a direct reference from the teachers list to the events, I suppose). It doesn’t look like it’s a 2-way street in this way. The only database items I can access in that dropdown are in the Teachers collection, not the events collection.
So in short, I’m trying to figure out how I can make it so I can pull event data into a teachers collection list.
Any ideas on how I can accomplish this? Thanks so much!
Here’s the share link: