I’d like to display all employees within 3 miles distance from a customer location and display this as list on the customers page?
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.
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.
Thanks, I’ll give this a try and let you know how I get on!