Hmm, I can’t think of a way to prevent the assignee column from showing the user I’m afraid
To solve the problem of not assigning work to people who are on PTO, the main issue would be having to loop through all the PTO that worker has and checking it against the task’s due date, which is difficult to do with Airtable’s native functionality
A workaround would be to create another link from the Work Order table to the Users table, and in the Users table, and add a lookup field to the due date.
This would allow you to pull over just the due date of the latest task, and you could then pull that into the Time Off Requests table to check it against all of that person’s PTO via a formula field, does that make sense?
With that, you would have a workflow of:
- Assign person to task
- An automation puts that person into that linked field I mentioned above
- The formula field in the
Work Orders table reflects whether this person’s available or not
- If they’re not available, you assign someone else
This would use an automation run each time you assigned a person though
If you don’t want to use any automation runs, you’d just put the person into the linked field I mentioned above manually, which would cause the formula field to update as well
