Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
At the end of Fields list there is an item "Expression", select it and write:
=If(field2>GetFieldSelections(field1), field2, null())
let me know
Try;
=if(field2>field1,field2,null())
Use just:
='=field2>field1'
as the search string (and field2 as field name, of course)
I'm attaching an example.
try
= ">" & only(field1)
Try the following Trigger
='>' & Max(field1)
Best,
S
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!
For your select in field Search String parameter, use:
='>' & min(field1)
-Rob