Get selected value

[#1]

Hi!

I have a table in the script:

T1:

load * inline [

f1, f2

1, a

2, b

3, c

];

In List Box I chose field 'f1'.

I can get the selected value of f1-field through getfieldselections('f1') function.

Question: how to get the corresponding value of the f2-field ?

Thanks!

[jonathandienst · Accepted solution]

Hi

If you have made a selection in f1, there is only one possible value of f2, one value will be white (possible) in a list box for f2. Or reference it directly:

     =f2

HTH

Jonathan

[MayilVahanan]

Hi

Try like this

=IF(GetSelectedCount(f1) > 1, Concat(DISTINCT f2,','))

[sunilkumarqv]

Create a listbox for f1 and make a selection

put this in you text box and check this

=IF(GetFieldSelections(f1) ,f2)

[#5]

Thank you all. It turns out it is very easy