One of the interesting new features Filemaker is the ability to show or hide objects based on a calculation.

 

Many examples are found on the internet, here is a possible application:

 

In a CRM solution that I just started and which I use as areas of exploration, I use this display or masking objects capacity particularly in external tables. 

Consider for example an external table which lists the addresses associated with a contact. 

These addresses can be own contact addresses (eg home) or those coming from his company. 

A second external table showing the addresses of the company, allows you to copy them to the table listing the contact addresses. But these addresses should not be changed while the own contact addresses can be modified directly in the portal.

 

 

 

 

So we can distinguish these two different kinds of address by using either a text label or editable fields which will be displayed or not depending on the nature of the address.

 

Here the blue text box displays an address from the company linked to the contact and unchangeable, while another address record displays some editable fields.

 

In the display area in the portal records, there is an overlay of the two address types (labels and fields).

 

 

The text label will be hidden when the field containing the identifier of the company is empty.

 

 

Conversely, editable fields will be hidden when the field containing the identifier of the company is not empty.