Section Access NTNAME Conditional Show on Button

[#1]

Trying to implement section access so only certain users are able to see a button when logging into the access portal.

Here is what i have scripted so far and this works for granting USER1 and USER2 access to the portal.  For instance, a USER3 does not even see the access portal on the web.

SIACCESS:
LOAD * INLINE [
    SIACCESS
    Y
    N
];

Section Access;
LOAD * INLINE [
    ACCESS, NTNAME, SIACCESS
    ADMIN, USER1, Y
    USER, USER2, N
];
Section Application;

Now I have a button called (SI) with a conditional Show which looks like this:

if(SIACCESS='Y', 1, 0)

How do i get it so the "Y" or "N" from the section access user records tells the button to appear or not?  Am i missing something in the Section Access area?

[Nicole-Smith · Accepted solution]

Make sure you have the following option checked in Document Properties:

[tseebach]

The field SIACCESS would in many cases return more than 1 value. To check if this is the case, then create a textboject with the expression =SIACCESS

If thats the case, I would use if(Only(SIACCESS)='Y', 1, 0) instead. So there is a aggregation around the field.

[#4]

thanks for this tip...this solved my issue.

[Nicole-Smith]

Great!