Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
aveeeeeee7en
Specialist III
Specialist III

Create 2 Groups out of 1 FieldName (List Box)

Hi Experts

I have 1 Question??

Suppose there is 1 List Box Country which contains 4 values  USA, England, Russia, China

I want to make 2 Groups - "Group1" & "Group2" from Country Field such that on "Group1" selection it can select All Field Values

and on "Group2" Selection it can Select only Russia & China excluding USA & England.

I want to make only one field which contains "Group1" & "Group2"

Regards

Aviral Nag

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Since Group1 and Group2 are not mutually exclusive, you can't opt for calculated expression in the list box. you can try:

Option1: Create an inline field with two values, Group1 and Group1, and then use trigger to select values from your target field on 'on selection' event in this new field.

Option2: Again in the script, create a generic association between these fields.

Hope this gives you an idea.

View solution in original post

6 Replies
tresesco
MVP
MVP

Since Group1 and Group2 are not mutually exclusive, you can't opt for calculated expression in the list box. you can try:

Option1: Create an inline field with two values, Group1 and Group1, and then use trigger to select values from your target field on 'on selection' event in this new field.

Option2: Again in the script, create a generic association between these fields.

Hope this gives you an idea.

Not applicable

through a bookmark?

sujeetsingh
Master III
Master III

See this sample it as per you need

sujeetsingh
Master III
Master III

Just select in the List box Group

aveeeeeee7en
Specialist III
Specialist III
Author

Thank You Sujeet. It worked like a Charm.

Awesome Stuff.

Regards

Aviral Nag

aveeeeeee7en
Specialist III
Specialist III
Author

Thank You Tresesco.

Loved your Suggestions. Very Useful.

Regards

Aviral Nag