Jump to content
Sign in to follow this  
Slater

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

Try:

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

Worked a treat - many thanks for your imagination and help!

:king:

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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