Check one field for multiple conditions

Hey there! I am almost certain this has been asked before, but I have been searching for hours and can't find anything. I am building an app that tracks flight delays and auto assigns a manager for...

formulas

MarkShnier__You
2 months ago
You should have a table where the key field is the airport code and another field for the Manager's Userrid.
Then make a relationship between your flights table and your airports table and look up the manager down to Flights.

HannahEngelson

Qrew Trainee

2 months ago

It's late in the day, so my brain has lost a couple cylinders, but I'm pretty sure this makes sense. The two tables will be connected based on airport code, and then the manager will be a lookup field based on that connection? Am I seeing that right in my brain?

Thank you so much for your quick reply!

MarkShnier__You
Qrew Legend
2 months ago
Exactly,
That's a classical normal Use Case for a Relationship.

Forum Discussion

Check one field for multiple conditions