)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Salesforce’s standard interfaces only show fields visible to the current user and included in page layouts, making it impossible to get complete field inventories that include hidden fields, system fields, and restricted fields.
You’ll discover how to access complete field inventories including hidden and system fields using metadata queries that bypass visibility restrictions.
Access complete field inventories with Coefficient
Native Salesforce reporting is limited by user permissions and page layout configurations. Hidden fields, system fields, and fields restricted by field-level security remain invisible through standard tools.
Coefficient overcomes these limitations through Custom SOQL queries against metadata objects, which can access complete field definitions regardless of visibility settings or user permissions.
How to make it work
Step 1. Connect to Salesforce metadata objects.
Launch Coefficient in your spreadsheet and connect to Salesforce. Select “Custom SOQL Query” to access metadata objects directly. This bypasses standard visibility restrictions and gives you complete field access.
Step 2. Query complete field inventory.
Use this comprehensive field extraction query:
This returns all field types including hidden, calculated, and system fields with complete metadata properties.
Step 3. Focus on hidden and system fields.
Run this query to specifically identify custom and system fields:
This helps you identify fields that might be hidden from standard interfaces but are still part of your object schema.
Step 4. Export complete documentation.
Export your complete field inventory to your preferred format. Set up scheduled refreshes to maintain current inventory documentation, ensuring you have complete field audits that include all field types regardless of visibility settings.
Maintain comprehensive field documentation
This method provides complete field audits essential for data migration planning, system documentation, and compliance requirements. Your inventory includes fields not visible in standard interfaces, giving you the complete picture of your object schema. Start building your complete field inventory today.
