I created a company calendar for a client a while back and now they want to have it at all their campuses, but they want “global” events and “local” events to come from the same asset. I added a field in airtable with a dropdown that defaults to “global” and a few other options to choose in the case that the record is specific to a certain campus. All of the campuses will always display the records with “global” but if a record is set to “campus 3”, I want that to be ADDED to the “global” records and show up in the same collection. Is this possible?
Would it be something like:
{campus} = “global”,“campus3”
or {campus} = “global”+“campus3” ?
Oh, then maybe the experts like Seb can help you, I prefer to keep stuff simple, easier to manage because my experience so far - the client ends up making a mess and then you wish it were simpler.
The field on the left is where the user can select “global” or “campus” from a dropdown menu that contains all the options, the field in the middle is the result of that selection, in text form so it can be evaluated by the formula in the field to the right. So if “campus 1 API”'s field is true, it includes in the collection, any items marked global or campus 1.