Aletrnative of MAXSTRING

[Anonymous]

Hi,

I am using below section access script, where A and B are the group names created.

We have a sheet, with show condition as -

=if(MAXSTRING({<GName=$(NTNAME)>}HGFlag)='Y',1,0)

For both the user group, the sheet is still visible, as the MAXSTRING is resulting in Y each time.

Can anyone please suggest, what is wrong with this.

Regards,

MK

[sushil353]

Try:

=if(MAXSTRING({<GName={'$(NTNAME)'}>}HGFlag)='Y',1,0)

HTH

sushil

[Anonymous]

no luck...returns null.

[tresesco]

Section Access NTNAME doesn't exists post load. You could rather try like:

=if(MAXSTRING({<GName={"=qvuser()"}>}HGFlag)='Y',1,0)

[Anonymous]

I have used NTNAME, as we have users assigned to Groups, and we have around 900 users.

[tresesco]

Do you get a field NTNAME at the front end ? Or any variable defined in that name?

[Anonymous]

i have not tried, but when i tried to reduce the data using NTNAME, I am able to do same.

[tresesco]

That's okay. What you have to understand is - whatever way you are using to capture user information in section access, that(NTNAME or any such user identifier) remains limited to the script only and that users can only be referened using qvuser() in the front-end. For your case, perhaps the expression suggested above would work. Give a try and let know.

[Anonymous]

i tried, MAXSTRING({<GName={"=qvuser()"}>}HGFlag), but still no luck.

The reason is MAXSTRING is givig value as Y everytime, for any user.

[sasiparupudi1]

=if (MAXSTRING({<GName={$(=NTNAME)}>}HGFlag)='Y',1,0)