0

Hide Related Table When There is No Related Data To Show

Hi. I have a main table with a related table attached to it. The attached table does not have a record for every field the main table does have. So for a lot of records on the main table, the related table is just an empty table. Was wondering when there are no fields to show on the related table that it could be hidden (to make space for the other filled tables) and when there is a record to show in the related table - it can reappear again?

 

Many thanks
as always

2 replies

null
    • Sean
    • 4 yrs ago
    • Reported - view

    You can use a formula in "Display field only, if:". I used count(ReferenceFieldName) != 0 and got the effect you're looking for.

    • peter_ajohnson
    • 4 yrs ago
    • Reported - view

    Good evening Sean. Thank you so much for your reply! This is exactly what I wanted and frees up so much more space on the form thanks just displaying empty tables. Thank you so much for your support.

     Peter