I'm looking for a way to communicate shift assignments to hundreds of individuals who are not members of my base. I use Airtable to manage poll workers. For their work assignments, I integrate Airtable with Make.com. When a staff member offers an assignment to someone, Make.com compiles data from multiple tables into an email.
Each assignment has a set schedule. Schedule details have been included in the email in a bulleted list. The source for that list is a long text field with RTF enabled.
The schedule descriptions are often complicated and a list is not the best way to display the info. I'd like to incorporate a separate Shifts table that can be linked to the assignments. This would allow much more specificity in describing the work schedule.
Ideally, this is what I would like to get out of this, and I'm not sure the best way to go about it:
- In the initial offer email, clearly list all of the shifts that the person would be required to work
- I've been imagining a table in the email. Some assignments have MANY shifts. In those cases it would be nice if the table could be a PDF attachment, or a link to some other view, but it's not necessary. I'll make do with a lengthy email if necessary.
- Quickly re-communicate just the shifts to any poll worker as needed.
- E.g., after accepting the assignment, a poll worker says there is one day they won't be available. A staff member can make that change and click a button to share the shifts again. (or the shifts are visible in some other way?)
My searching has turned up options to create PDFs, but as best as I can tell that has to be done on a one-by-one basis, which won't work for hiring 800+ people. I've hit a wall and suspect someone else will have an idea that I'm missing!