Jump to content
Sign in to follow this  

Allow access based on a calculation within a portal's records

Recommended Posts

Hi All,


I've got two records. The parent record has a 1 to many relationship with the child.


The parent is for clients

The child is for people


I want to only allow someone access to the parent records, when there is at least one child records which has Are_They_Green = "Yes"


So if any of the client's people are green, then access will be allowed to the parent.


I'm using a calculation within the privilege set, view limited: Are_They_Green = "Yes"


The problem that i've got, it seems to me, is that i'm only getting one or a couple of layers down in the portal. How can i calculate it to show that there is at least one occurrence of Are_They_Green = "Yes" (assuming this is the best way to go).


Thanks for any help - been searching but to no avail!





Share this post

Link to post
Share on other sites


not IsEmpty ( FilterValues ( "Yes" ; List ( Child::Are_They_Green ) ) )

Share this post

Link to post
Share on other sites

What a great suggestion - thank you so much. I'll be able to try it tomorrow.

Best wishes :)

  • Like 1

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.