I need some help with an employee staffing database. We use it to track employees, shifts, open shift trade request, pay, vacation etc
I need make a way that the people in the database can check a box to indicate they want to post a shift as open to trade. The following tables are setup: staff, shift, shift posting, shift posting response.
This was my idea for a workflow.
- Staff member uses a form to select the shift they need to trade. They indicate this via a checkbox called “Trade Needed”
- Staff member uses a second form to post this to our available shifts.
- Other users use a third form to indicate their interest in the shift.
I can’t figure out a way to allow the staff members to select that checkbox.
The restriction is that we don’t have airtable user account for each member of the staff. There are currently 40 contractor we have and the price doesn’t scale.
Can anyone point me in the right direction?