Hi all,
I’m building a food delivery app, and I’m trying to create a way for this to automatically assign the nearest courier from a restaurant to receive an order.
I’ve managed to use distance columns and an array column to sort different couriers based on their distance from nearest to farthest from the restaurant. Then, I used a rollup column to find the nearest (shortest) distance.
The next step is to create a column which would write the name of the courier who matches this nearest distance from the restaurant, so he can be assigned the order of the restaurant.
Any help or leads would be really appreciated.
Thanks!
Adam