Stumped - script to trigger if any records are "open"

[Darren Emery]

This should be simple, but I don't know enough of the functions to find a quick solution.  I need to display a custom dialog box only when there are related records present, AND any of those records is stll listed as open (text field selected either open or closed by user).

 

So - if no related records, do nothing.

 

If related records exist, and any of those records are open, display dialog box.

 

I can do the first two conditions, but not sure how to test if any related records are open.

 

 

Suggestions?

 

 

 

 

[comment]

 (text field selected either open or closed by user)

 

Do you mean the text field contains the text "Open" or "Closed"? If so, you can test for:

 

not IsEmpty ( FilterValues ( "Open" ; List ( Related::Textfield ) ) )

 

If this return True, there is at least one related record whose Textfield value is "Open".

 

 

This could be easier if you used a Number field - with 1 for True (say Open) and 0 (or empty) for False.

[Darren Emery]

Thanks comment - your suggestions always save the day!