Need Help with Smart Geographic Filtering: Grouping Customers Not Just by Distance from Factory but Proximity to Each Other

Hello everyone,

I’m working on an app where I have to manage deliveries to customers. So far, I’ve been able to calculate the distance from our factory to each customer and group them based on their distance from the factory. However, I’ve run into a unique problem that I could use some help with.

Let’s say I have a customer in Barberton that’s 30kms away from the factory. My current setup will also group another customer in Whiteriver, who is also 30kms away but in the opposite direction from Barberton.

What I want to achieve is a smarter geographic filter. When I choose to deliver to the customer in Barberton, I want my app to suggest other customers who are nearby Barberton or en route from the factory to Barberton, instead of just showing all customers within a 30km radius from the factory.

Any suggestions on how to implement this would be greatly appreciated.

Thank you!

When you select a customer, use an action to set their location in a user specific column somewhere. Then use a single value column to apply that location to every row in your Customers table. You can then compare each customer’s location to the value in that single value column.


@Darren_Murphy Thank you boet, I appreciate the help. I will give it a go and report back.

Net my Suid-Afrikaanse vriende noem my boet
Sterkte, vra gerus as jy vashaak :slight_smile:

1 Like