Hey there! I run a party planning business and use Airtable to keep track of all my events.
I have a field called “TEAM” in my events table where I choose which employees worked at each celebration. Here’s what I’m trying to accomplish:
• How do I create a list showing team members with their work dates?
• I need to monitor their compensation by having:
A tick box to show payment status
A method to determine payment amounts
Options to organize and view unpaid workers
I’ve tried experimenting with various views and connecting different tables, but nothing seems to work properly. Anyone have experience with this type of setup or suggestions on how to approach it?
I dealt with something similar when we needed to track contractor payments across different projects at my company. The trick is setting up a junction table to handle the many-to-many relationship between events and employees.
Create a new table called “Event Assignments” or “Work Records”. This table should have these fields:
Event (linked to your Events table)
Employee (linked to your Team Members table)
Date Worked (auto-filled from the event date or manual entry)
Payment Amount (number field)
Paid (checkbox)
Payment Date (date field)
Then in your Events table, instead of linking directly to team members, link to the Event Assignments table. This way each work instance gets its own record where you can track payment details.
For views, create filtered views in the Event Assignments table like “Unpaid Work” (where Paid checkbox is empty) and “This Month’s Payments” (filter by date range).
This setup gives you way more flexibility than trying to cram everything into the events table. You can sort by employee, date, payment status, whatever you need.
That video shows a solid approach to building databases for business tracking that might give you some extra ideas for your setup.
