The status bar at the bottom of each table shows the total of each field. So we have X records and X sum. What I need is to use those values in formulas.
How can I call the total records of the table 1?
How can I call the sum of a field in the table 2?
Could you help me with that?
Do you come from a spreadsheet background? Welcome to the database world.
It is not possible to use values from the summary bar in a formula field in Airtable.
You can sometimes use linked record fields and rollups to the sum of a value in linked records. It isn’t the same and it requires a different way of thinking, but it might get you closer to what you need.