I have 2 tables
- which gets populated when there is a new web enquiry.
- a list of advisers
I want to assign one adviser to an enquiry on a round-robin basis.
I’m assuming creating a column for the date/time they last had a lead then finding the adviser record with the longest date would be fairly straight forward but I can’t seem to work it out.
Is there an automation to find a record based on the furthest date from today?