Select greater than field selected in ListBox

[Anonymous]

Hi All

I currently have a List box with values

Example 1 2 3 4 5 6 7 8 9 10

I want, if someone selects 8 it selects 8 and greater than 8

If someone selects 1 it selects all available greater than and including 1

How is this possible?

Thanks

[swuehl · Accepted solution]

You can use an OnSelect field trigger action (from settings - document properties - trigger) with an

Selection - Select in field action on the same field and using a search expression like

='>=' & Max(FIELDNAME)

[Anonymous]

This is great Stefan and works when a field name exists

I have a variable in my Dashboard to get date diff as below

Script:

SET MonthDiff = Num(((year($2) * 12) + month($2)) - (((year($1) * 12) + month($1))) + 1);

Listbox:

$(MonthDiff(Createdate, Today()-1))-1

At the moment i can select example 0 1 2 3

I thought it would work with this but it hasn't,Any ideas? Thanks

[swuehl]

If you select in this list box, you basically make a selection in field Createdate, right?

You could try to use this field as field in the action and modify the search appropriately.

[Anonymous]

Yep Managed to Work Thanks Stefan