Need help with Section Access (multiple value from one field)

[pathompong_vm]

I need your help about section access,

I have one field that I would like to control all section as follow (field called 'TEST');

TEST

-A1

-A2

-B

-C

I would like to make section access something like this;

USER               TEST
MIKE                *
SARAH            B
JOHN              C
BEN                 A1,A2
TOM                A1,C

Now I can do control section access for MIKE, SARAH and JOHN.

But what should I do section access for BEN and TOM???

Thanks.

[Vegar · Accepted solution]

In your example the SA will look for an value equal to "A1,A2" and "A1,C". You need to split them up like I've done below.

MIKE *
SARAH B
JOHN C
BEN A1

BEN, A2
TOM A1

TOM C2

[pathompong_vm]

It's working very fine, Thank you so much

[abhi1693r]

Hi, I had a similar complication. So I have made a multi-box with a field 'A' having three levels 1, 2 and 3. Now as multi-box works, I can filter the data by selecting 1,2 or 3 or a combination of these levels. My requirement is that if someone selects 2, 1 should automatically be selected and if someone selects 3, 1 and 2 should be auto selected.

Is this possible?

PS: Also, I have multiple fields from A to Z@Vegar