I am helping my HR team transfer their processes from Excel to Monday. A recurring theme is how we store references to employees. For example, an item might represent a hire, with a column for their manager. Currently, the best we can do is store their name, possibly with a second column for their email. The problem with this approach is it is cumbersome and hard to automate (if I only have a manager’s name, I can’t send an email to them).
What I would love is the ability to create a custom column type with a custom autocomplete that pulls from our employee database. I tested creating a custom item view that added an employee autocomplete (which bound back to a name and employee id) field but this forces them to edit this data from the item view.
My best option right now is a separate board storing employee data, synced from our employee db, with references to this board in other boards. How are others solving this problem?