List box question

[#1]

hello,

i have created a list box from expression (can use only object id),

now i need to write a macro that peek all selected value from list box.

how can i do that?

thanks,

avi

[jagan]

Hi,

You can get selected field values by using the function

Ex: GetFieldSelections ( Year, '; '  )  - Returns the selected values of years separated by ;

Is there any specific reason to write macro?  If need assign the function to a variable, and get the variable value in macro.

Regards,

Jagan.

[#3]

hi,

the only problem is that is have used an expression and not a field in the list box,

and as i know GetFieldSelections  get a field.

avi

[jagan · Accepted solution]

Hi,

Use this expression below and assign it to a variable

=CONCAT(AGGR(Sum(COUNTER), F1), ';')

where

- AGGR(Sum(COUNTER), F1) - Expression used in listbox

- COUNTER and F1 are columns

now you will have the selected values in the list box separated by '";"

Now you can get the value in the variable in macro.

Hope this helps you.

Regards,

Jagan.

[#5]

thank you!!!