Hello,

I would like to restrict access for a specific user group to records based on a specific value in a field. For example, the field is called Category in the database table Catalogue, and the value is Canadian and is part of a value list. I've gotten to the step of a limited records access which brings me to a boolean condition screen. I'm not sure how to write the Boolean condition. Any suggestions? 

 

Thanks!

I deleted your other posts as a duplicate to this one.

 

Please do NOT double post your questions.

If the result of the calculation is true, the user is allowed to do whatever the restriction would otherwise inhibit.  If the result is false, the restriction is enforced.

 

Steven

Boolean true might be ( if only single value is allowed in field ):

Catalogue = "Canadian"

If there are multiple values in the field then:

not IsEmpty ( FilterValues ( Catalogue ; "Canadian" ) )

Thanks everyone, it worked! 

 

Another question on the same topic. I now have a user account that only shows records that contain category=canadian. However it also shows hundreds of records without the category that are blanked out and say "no access". Is there any way to get rid of the blank "no access" records? I do not want the user to see how many records they are not allowed access to... it also does not look very presentable.

 

Thanks again!

You can remove the <<No Access>> badge from the UI with conditional formatting of the field.  If you want to remove the records from the found set, do a find for some value always present in every record.  The resulting found set will not contain the records the user cannot access.

 

Steven