I am migrating my company booking system into Airtable. Long story short, I provide freelancers to clients on a day basis.
I have > 200 clients, and over 100 freelancers.
My challenge is that some freelancers are charged a different price depending of the client. Right now, I have a pricing matrix on a Sheet, as for exemple :
I can"t find an easy solution to get the same result in Airtable.
Let’s say I have 3 tables : Clients , Freelancers , Prestations.
In the table Prestations, if I create a new record with Client B and Freelancer 2, i’d like the price to be automatically inserted as $200.
If a Prestation record is Client C and Freelancer 5, that’d be $250.
Would you have some suggestions?
Thank you very much!