Select in Field not Working

[sivarajs]

Hi,

My requirement is, when i select a field in list box it should values greater than field1 in field2.

I am using select in field in triggers for a field1.

Data:

Load* inline [

field1

10

20

30

40

50

]

Load* inline [

field2

10

25

33

45

50

]

When i select 10 in field1 the field2 should select 25,33,45,50.

In triggers i have used field1='=field2>=field1'. This is not working and am using qv11.

Thanks,

Sivaraj

[alexandros17]

At the end of Fields list there is an item "Expression", select it and write:

=If(field2>GetFieldSelections(field1), field2, null())

let me know

[chrismarlow]

Try;

=if(field2>field1,field2,null())

[kuba_michalik]

Use just:

='=field2>field1'

as the search string (and field2 as field name, of course)

I'm attaching an example.

[Clever_Anjos · Accepted solution]

try

= ">" & only(field1)

[sunny_talwar]

Try the following Trigger

='>' & Max(field1)

Best,

S

[Anonymous]

Hi,

For the list box of 'Field 2', you can use the expression mentioned by Alessandro Saccone.

Then you can check the list box of 'Field 1' as "Always One Selected Value", so that Field2 displays some value always.

Hope this helps!

[rwunderlich]

For your select in field Search String parameter, use:

='>' & min(field1)

-Rob

http://masterssummit.com

http://robwunderlich.com