Formula queries allow you to build flexible, complex workflows and data flows without using code. Most formulas reference information in a single record.
Formulas can use queries to query information across multiple records and unrelated tables in the same app.
What can I do with formula queries?
Formula queries let you do things like:
Find duplicate records in a table
Keep track of running totals
Auto number records (learn more in our example in Community)
Create advanced calculations and report filters
Create fields with outputs similar to lookup summary fields (without creating additional table relationships)
How do I add a formula query to my app?
You can add a formula query to:
To make sure users can see formula results
Enable permissions to all fields when building or editing an app that leverages formula queries.
Users without permission to view the fields that a formula query uses cannot see the formula results
This is true even if you check the Override sub-field access setting in the formula field properties