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

[NewBoard]

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!

[comment]

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.

[NewBoard]

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!