I don’t completely understand your current problem, so responding to your title with some concept explanations. Hope these help.
Excel vs Airtable Code
Referencing Other Fields
A formula field/column can reference other fields like this:
many thanks for your reply. After I posted this question, I realised it was too complicated. So, I posted another one with the title " [Calculation to track % Change in a Table]. Here it is again:
I’ve created a Table. I add a record ever day to track the number of occurrences such as: Visitors to an establishment.
Date Day Visits % Change
23.3. Mo 27 NA
25.3. Tu 28 = (28/27)-1 (in formula in Excel (C2/C1) - 1
26.3. We 30 = (30/28)-1 (in formula in Excel (C3/C2) - 1
27.3 Th 35 = (35/30)-1 (in formula in Excel (C4/C3) - 1
Where the % Change Column (or Field in Airtable speak) is, of course, calculated by a Formula.
How can I achieve this with Airtable? With Scripting Block?
Thanks for the explanation - that makes sense now.
Yeah, the Scripting Block would be the only way to accomplish that. The reason being, Airtable formulas aren’t really meant to reference other rows’ data (outside of linked records, but that’s not relevant here).