Editable_If Admin if not use the conditions

Eoj_VT · 08-28-2021 02:21 AM

I would like to put a constraint in Editable_if columns.What I want to achieve is.,it can be editable only if the userrole is “Admin”

Then if the user role is “User” editable only if the date is equal to today in [Date Out] column.

Aurelien

You may want to have a look to these documentation articles:

and set your expression here:

So, that:

would be:

OR(USERROLE()="Admin",
   AND(USERROLE()="User",
      [Date Out]=TODAY()
)
)

Eoj_VT

You’re the best! Thanks

Aurelien

You are welcome