Sheet Visible is Acess = Admin

[#1]

Hi All,

What must my conditional expression be if Ionly want a sheet visible if the user access level is ADMIN.

I have tried if(ACCESS = "ADMIN") but that does not work.

Regards

Jimmy

[richard_chilvers]

Hi Jimmy

I have never used the ACCESS field. But as a general rule within your Calculation Condition, I don't think you need the IF statement. Simply an expression which returns either 'true' or 'false'.

So in your case, ACCESS = "ADMIN" should be all you need.

Hope it works !

Richard

[Miguel_Angel_Baeyens · Accepted solution]

Hi there,

The Access field shouldn't work, but you have a function QVUser() that returns the user logged into the file. Assuming the following section access:

SECTION ACCESS;
LOAD * INLINE [
ACCESS, USERID
ADMIN, A1
USER, U1
];
SECTION APPLICATION;
// Your script here

You can create a condition to show only when the user A1 (admin) has logged in

QVUser() = 'A1'

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#4]

Hi Richard,

Thanks for the answer but no, it did not work.

Regards

Jimmy

[richard_chilvers]

Hi Jimmy

As I mentioned, I did not understand the use of the ACCESS field, but good to see you now have a correct answer!

Regards