Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one field as Country with below field values
Country
All
India
uk
hongkong
china
brazil
Now i want to implement trigger on field value " All " to "select all" the field values in country field?
So that i can view the complete data related all countries.
Thanks in advance!
Raju
You will need double quotes around the values. Try:
=if(SubStringCount(GetFieldSelections(Country),'All')>0
,'*'
,'("' & GetFieldSelections(Country, '"|"') & '")'
)
-Rob
Rob, Its working! Thanks a ton!
Raju
very nice post sir,,,i have same requirement like this,,,,that is now we are select 'All' fieldvalue in country field then all fieldvalues will be selected right,,,now my requirment is when you select 'ALL' all selections will be clear like 'clearall button' is it possible...
Just select a value that isn't there. That should clear the field.
-Rob