Conditional Show Based on OSUser

[Anonymous]

Trying to add a conditional statement to a button based on OSUser

Currently, I have the following syntax in the SHOW/Conditional dialouge box of the button:

OSUser () = '*melillo*, *userlastname*'

This does not seem to be working, even when I try it with just my last name.

Any suggestions? Thank you.

[petter · Accepted solution]

You should be able to use the WildMatch() function like this:

WildMatch( OsUser() , '*melillo*', '*userlastname*' )

[Anonymous]

Thanks Petter.

[cbaqir]

Petter,

On my Sheet Properties for Validation, I have Show Sheet Conditional:

=WildMatch( OsUser() , '*cbaqir*', '*jbrowning002*', '*clondono*','*draffensperger*' )

However, as you can see in the screenshot, this user can see this sheet but should not be able to. Any idea why? Does the type of license or distribution make a difference?

Thanks,

Cassandra