Support hiding data for certain records at the field level in a query

[bronwyncombs]

What I want to do...

Hide data in certain fields for certain records in a query.

• Hide latitude and longitude if a "Hide Coordinates" checkbox field on Locality equals true
• Hide latitude and longitude if the "ESA Status" pick list field on Taxon equals one or more values

This is possible through a conditional table format, but that means all the data for that table must be contained to the one (formatted) column.

How I want to do it...

Add an unless / except if operator or an add condition option for fields in queries.
If the unless operator is selected, another field mapper will appear below the field and indented.
There, you map a second field to base the condition on, and set the operator to define the condition (e.g., Empty or True)

The field mapper is on the next line because it should reset to allow for mapping from the chosen base table (for cases like basing a Locality field condition on a field in the Taxon table)

Why I want to do it...

This is important for exporting data from Specify to aggregators or a web portal

Requested by...
Auburn Inverts
Paleo collections