Logical values


Badge +7

I need create a formula for hide a select controlos.
What is the best pratice
I do:

Formula Builder

There is other way  like if emailuser not in ('aaaa','bbbb','ccccc')


2 replies

Badge +8

Hi Jose,

I guess both the formula (the way you have used) are different ...

If(emailuser!="jose.fidalgo@coficab.com" || emailuser!="ricardo.almeida@coficab.com" || emailuser!="amelia.paulino@coficab.com" || emailuser!="cedric.soares@coficab.com" )

In the above example -

if emailuser = jose.fidalgo@coficab.com, then the condition emailuser!="ricardo.almeida@coficab.com" will be true and it will disable the control .. you might probably need && (and clause) to be sure that all the conditions are checked? 

Regards,

Shrini

Userlevel 4
Badge +12

Hi Jose,

are you trying to disable the control for specific users?

Another approach might be to add your users to a new SharePoint group. Afterwards you place a rule on your control which is:

fn-DoesMemberExistInAudience(current user, your new groups name)

The inline function will check if the current user is in the group specified. If true you can disable/hide the control. The method is an inline function. Rules will only show you runtime functions so you will have to copy/write the function's name itself but they do work flawless in rules and also mobile apps so you should give it a try.

Kind regards,
Enrico

Reply