Formula based on whether field is hidden or not

Is it possible to have a formula take into account whether or not a given field is hidden in the current view?

For example, I have a Name (“Bob Smith”) field and a Role field (“Developer”). I want the formula to show the Name if it’s not hidden and just the Role if the Name is hidden. This allows me to share an anonymized version of the record on a publicly shared view, while using the Name field internally when managing data.

Unfortunately field visibility can’t be accessed by formulas. To create the kind of anonymized view you seek, you can pull Airtable data via the API and build a custom interface. It’ll require more work, but you can then customize the view/report any way you want.

2 Likes