Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
i have a following requirement:
i have a Fiscal Year Selection and Current Year selection
if user selects one of them then other should be disabled and user should not be able to select
For Ex:
If user selects Current year then fiscal year selection should be disabled same vice versa
Thanks
Kushal Thakral
Use the below expression":
In Fiscal Year conditional:
if(getselectedcount(CurrentYear)>0,0,1);
In Current Year conditional:
if(getselectedcount(FiscalYear)>0,0,1);
Hope this will help you..!
Can u post ur sample application??
Hi Kushal,
You can use conditional show for this.
I am assuming you have 2 list boxes each for Fiscal year and Current Year.
If so, then you can make them conditionally visible on:
Fiscal Year:
GetFieldSelection([Current Year]) =0
Currennt Year:
GetFieldSelection([Fiscal Year]) =0
This way, as soon as you will select anything in one list box, other will disappear.
Hope this helps!
EDIT: Alternatively, you can use Actions/Triggers as well.
Check this Disable a listbox when ...
Hi Shyam
I m tried it but when i apply the formula it disappear immediately without any selection
Please help.
Regards
Kushal
Can you try using "GetSelectedCount" instead of "GetFieldSelection"?
Use the below expression":
In Fiscal Year conditional:
if(getselectedcount(CurrentYear)>0,0,1);
In Current Year conditional:
if(getselectedcount(FiscalYear)>0,0,1);
Hope this will help you..!
Use the below expression":
In Fiscal Year conditional:
if(getselectedcount(CurrentYear)>0,0,1);
In Current Year conditional:
if(getselectedcount(FiscalYear)>0,0,1);
Hope this will help you..!
Thanks Priya
It works
Regards
Kushal Thakral
Using GetFieldSelections()
In Fiscal Year conditional:
if(IsNull(GetFieldSelections(CurrentYear)),1,0)
In Current Year conditional:
if(IsNull(GetFieldSelections(FiscalYear)),1,0)