Jump to content

Checking if all related records in a portal have a specific value


This topic is 2499 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I currently have a form that contains a portal. In the portal there is a value that will either be "Accepted" or "Rejected". I'm wondering if there's a way to parse through this table to check if any related values have a "Rejected" or if they are all "Accepted". Then using that outcome, decide if the form should display Rejected or Accepted.

Please let me know if I need to provide any more information and/or images.

Thanks in advance for any assistance you can offer!

Link to comment
Share on other sites

1 hour ago, NewBoard said:

I'm wondering if there's a way to parse through this table to check if any related values have a "Rejected" or if they are all "Accepted".

You can check if any of the related values is "Rejected" by testing for:

IsEmpty ( FilterValues ( "Rejected" ; List ( Related::Field ) ) )

 

Note that the portal has nothing to do with this. A portal is a layout object that shows related records - and it can be filtered to show only some of the related records. The calculation works at the data level and looks at the entire related set.

Link to comment
Share on other sites

56 minutes ago, comment said:

You can check if any of the related values is "Rejected" by testing for:


IsEmpty ( FilterValues ( "Rejected" ; List ( Related::Field ) ) )

 

Note that the portal has nothing to do with this. A portal is a layout object that shows related records - and it can be filtered to show only some of the related records. The calculation works at the data level and looks at the entire related set.

Thank you comment this did the trick!

Link to comment
Share on other sites

This topic is 2499 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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