Hello: I have a table of CLIENTS and a table...

(Cambia Tu Techo) #1


I have a table of CLIENTS and a table of CONTRACTORS, each one of them have Coordinates of their location. I have a formula that calculates the DISTANCE between each one.

How can i show in the dropdown list of CONTRACTORS in a form the ones that are closer to the CLIENT based on the distance?

(Suvrutt Gurjar) #2

Hi @Cambia_Tu_Techo, You may wish to create a slice on CONTRACTOR table wherein the slice’s row filter condition is

[Distance]<=100 or whatever distance you wish to have. to select the contractors.

You can then refer this slice in Customer table instead of the entire contractor table.

(Aleksi Alkio) #3

If you can use a ref field, you have a way to use ORDERBY expression.

(Suvrutt Gurjar) #4

Hi @Aleksi_Alkio’ , Yes that is a much better way. Your solution is much sleeker and compact as usual.

(Cambia Tu Techo) #5

@Suvrutt_Gurjar Thank you for the advice.

(Cambia Tu Techo) #6

@Aleksi_Alkio Where should i use the ref field? I have an ORDER table where i indicate the CLIENT and CONTRACTOR fields to calculate.

(Aleksi Alkio) #7

You should have it in the Client table.