Staff distance from customer locations

Ask for Help
1

I’d like to display all employees within 3 miles distance from a customer location and display this as list on the customers page?

2
3

I’m looking to compare a single address from one tab with a list of staff addresses in another to find all staff within three mile radius.

Thanks

4

You should be able to select a customer, have a button action or an action before viewing the customer details that will write the customer address to a user specific column somewhere (such as the user profile row), then pull that address into the the staff table using a single value column. Then you can create a distance column that will determine the distance between the staff address and the customer address. Then just display an inline list of staff with a filter to only show those within a distance of 3 miles.

2 Likes
5

Thanks, I’ll give this a try and let you know how I get on!

1 Like