Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to use the formula

Topic Labels: Formulas
254 2
Showing results for 
Search instead for 
Did you mean: 

Thank you for your help.
I’m sorry for the beginner’s question, but please tell me.
I want to make a cash register. I made it based on the idea of Excel, but could you tell me if it is feasible?

■ 入金 - 出金 = 残高
→This was achieved with the formula

■ 残高(upper record) + 入金 - 出金 = 残高
→ How should this formula be realized?
Or could you please tell me if you need to review the table design?

Thank you.

2 Replies 2

Hello @111231,

Adam from Airtable here.

Please note formulas in Airtable are slightly different from formulas in a traditional spreadsheet program. In a spreadsheet, you can put a formula in any cell, and have it reference any other cell in the sheet. Airtable is a relational database so formulas are applied for the entire field (what Airtable calls a column) so that the same formula applies to every record in that field. For more information on building formulas in Airtable, I’d suggest looking over the following:

Sorry to not have a more direct answer/solution for you at this time.

Good evening
Thank you for telling me various things.
As you say, it’s not the same as spreadsheets.
I want to study little by little so that I can realize what I want to do.

This case was realized by referring to the following. It’s not perfect, but the minimum requirements have been met.