Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a query...
Suppose i have taken a fiscal year field in a list box. If i select more
than 2 selections on fiscal year its should be auto cleared..what logic can
i apply to this???
Can you elaborate more?
For example:
Fiscal years (2011,2012,2013,2014,2015)
If i select 2012, 2013,2014 then selection should be auto cleared it should
allow only 2 selections at a time not more than that.
If you want users not to allow more than one value to select, you can check for 'Always One Selected Value' option. Select a value in the list box->General tab->enable 'always one selected value'.
Please reply if there is any solution..
You can use trigger, like in sample qvw attached.
Clear field trigger:
=If(GetSelectedCount(YourField)>1, 'YourField')
see attachment
there is a trigger in menù --> settings --> document properties