Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if your field is new_field
go to list box -> click on the dropr down -> at the last row there is expression ->
=if(new_field >= $(vStart) and new_field <= $(vEnd) ,new_field ,null())
if your field is new_field
go to list box -> click on the dropr down -> at the last row there is expression ->
=if(new_field >= $(vStart) and new_field <= $(vEnd) ,new_field ,null())
Oh .. I guess i misread
use your field in list box
go to setting -> triggers-> variables-> on change
select your variables and use this to select the fields
=concat(distinct if(new_field >= $(vStart) and new_field <= $(vEnd) ,new_field ,null()),'|')
or
='(' & concat(distinct if(new_field >= $(vStart) and new_field <= $(vEnd) ,new_field ,null()),'|') & ')'