Getting airtable to suggest from an list of available employees, the one who has the lowest hours

Topic Labels: Automations Data Formulas
247 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I am building a schedule/time management base where employees can show their interests for shifts by adding their names to a (multiple select) shift calendar. Employees are unionized and have to be prioritized by the lowest monthly hours given and seniority order. 

The issue i have is the names are sorted by whom added their names first to the shift interest multiple select column. How can this box by sorted by 'lowest hours, seniority' instead.... OR could i get airtable to suggest the right employee from the list of avaiable employees on a shift?

0 Replies 0