Formula Calculations on Demand

Ask the agent to compute rollups, averages, or cross-table lookups from your Airtable data without setting up a formula field. Results come back as a WhatsApp message.

WhatsApp DMformulascalculationsrollups

Conversation example

In the Orders base, what's our average order value this month by region, and how does it compare to last month?

http_request → Airtable records.list (2 queries)

Computing the rollup across Orders → grouping by Region for April vs March...

Average order value by region April (to date, 412 orders): - South: ₹8,240 (142 orders) - West: ₹9,110 (126 orders) - North: ₹7,850 (98 orders) - East: ₹6,420 (46 orders) All regions: ₹8,310 March (full month, 1,087 orders): - South: ₹7,920 (↑ 4% MoM) - West: ₹9,240 (↓ 1% MoM) - North: ₹7,540 (↑ 4% MoM) - East: ₹5,890 (↑ 9% MoM) All regions: ₹8,060 Trend: 3 out of 4 regions growing AOV MoM. East jumped the most (likely the new enterprise deal we closed with Fabrikam Kolkata). West dipped slightly — probably the Mumbai warehouse outage on April 2. Want me to drop this as a rollup view in Airtable too?

More Airtable use cases

Deploy this in minutes

Create a LunoGen agent, connect Airtable, and start running this workflow from WhatsApp today.

Back to Airtable