I have 2 tables
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?
I do not think you can achieve what you are trying to do through simple automations or third party solutions like Integromat/Zapier. This is because every time you assign the new enquiry you need to find the lead with the longest date out of all. I think the best solution to achieve this is to build an Airtable script.