Tab Access

[#1]

I want to make a specific tab viewable by certain users only.

In my load script, I have the following:

Section Access;

Load * inline [

USERID, PASSWORD, ACCESS, GROUPNAME

bloggsj jb,USER,G1

smithj,js,USER,G2

admin,1,ADMIN,*

];

Section Application;

Star is *;

Groups:

load * inline [

GROUPNAME

G1

G2

];

Then in the tab property, I have the following condition

=FieldIndex('GROUPNAME', 'G1')

I would therefore only expect bloggsj and Admin to be able to view the tab but all 3 can.

What am I doing wrong?

[#2]

Hi, have you ticked the option in document  properties >opening...

'Initial data reduction based on section access'

?

If this isnt ticked then no data will be restricted.

[Anonymous]

I'm not sure it's a relaible approach to use fieldindex().  Try this:
match(concat({1} distinct GROUPNAME),'G1')

Regards,
Michael

[Anonymous]

With reference to Michael's comment "I'm not sure it's a relaible approach to use fieldindex().  Try this:

match(concat({1} distinct GROUPNAME),'G1') "

You are VERY right. fieldindex does not work (for me). I get different results on the Web than I do on my server copy when using fieldindex. How that can be I will never know!

I am happy to say that "match(concat({1} distinct GROUPNAME),'G1')" works perfectly!

Thanks for that, I was really stuck.

Regards

David

[alexpanjhc]

if they all have a windows login, I'd list them in the propety ->general->condition.

=upper(osuser())='domain\user'

will that help?