Hi, I’m loving Airtable and it’s already doing plenty for me that is good
I’d like to take my existing Base a step further. I have two key tables: Events (rows are unique bookings, with dates and times) and Staff (rows of unique persons). I allocate varying numbers of staff to each booking in the Events table. What I’d like to do is calculate how much is spent on staff costs per booking - the tricky thing is that each staff member will have a different cost per booking. This cost is given to me by a colleague and includes pay+expenses+bonuses.
How do I do this in the most simple/efficient way, using data that is already in existing tables (the booking by ID/date and the multiple staff linked to in the Staff table)?