Create a field to show a value IF there is a connected record


I am trying to create a field to show if there is a connected record or not.

For example, I have a list of sites (Parent), each site (Parent) can have multiple photos (childs). I want to show a specific value if there is NO photos connected to that site.

Like there should be a way to indicate if there is any connected record or not.

Any help ?

Works perfectly. Thank you very much

What you could do is have a count field in the parent record which counts the number of child records and then use a Rule in the Scene or View to hide / show stuff if the value is zero.

Hope this helps?