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
Use Action Select in Field on field: Country
Search String:
=if(SubStringCount(GetFieldSelections(Country),'All')>0
,'*'
,'(' & GetFieldSelections(Country,'|') & ')'
)
-Rob
Use Action Select in Field on field: Country
Search String:
=if(SubStringCount(GetFieldSelections(Country),'All')>0
,'*'
,'(' & GetFieldSelections(Country,'|') & ')'
)
-Rob
Hi Rob!!
Thanks for quick response!
I implement as you said, but i am unable to get the result? Can you please see the attachments.
Can you please advice!
Thanks,
Raju
simply you can use * in search string
In the expression, I think you need to specify all as "ALL" to match the case of your value. If you have further questions, can you post a qvw?
-Rob
You are great troubleshooter!! Thank you very much it is working!!!
Raju
* is not working! solution got by ROB!
Glad it's working. Please mark something as correct to close the thread.
-Rob
Sure Rob!
Hi Rob,
Greetings!
We found one bug after using the
=if(SubStringCount(GetFieldSelections(Country),'All')>0
,'*'
,'(' & GetFieldSelections(Country,'|') & ')'
)
in trigger.
Now we are unable to find the data related to particular country names (two string countries) in listbox
Hong Kong
United Arab Emirates
United Kingdom
But we are getting correct values for one string countries like india, us, austaila.
Can you please advice me to get the data related to two string countries also?
Thanks,
Raju