get response value from selected field, and list out

[alex_lin]

if I have a table as followed,

city	latitude	longitude
HYDERABAD	17.39	78.47
GUWAHATI	26.18	91.76
AURANGABAD	24.75	84.38

I want to know how to get the pair values of latitude and longitude when I select any city.

I only know I can get selected value of city by using GetFieldSelections(city)

example :

if I select HYDERABAD and GUWAHATI,

and I wanna get the value 17.39, 78.47 | 26.18, 91.76

Thanks

[sushil353 · Accepted solution]

Hi,,

Try below:

=Concat(latitude&','&longitude,'|')

HTH

Sushil