Mar 26, 2020 04:15 AM
Hello, I’m also new to Airtable. I’m wrestling with one thing that is very easy in Excel (or Google Sheets), but I haven’t be able to find how it can be implemented in Airtable.
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?
Any help would be very much appreciated.
Mar 26, 2020 06:01 AM
This cannot be done in Airtable as Airtable does not recognize Records in the Formula, it recognizes Fields.
Im not sure if it can be done using the Scripting Block though.
Mar 26, 2020 08:33 PM
thanks for your reply. So, Airtable is really more RDBMS and Spreadsheet. I’ll explore Scripting Blocks.
Apr 06, 2020 05:28 PM
Here’s a possibility:
I tried to post a screenshot, but the forum won’t let me.
Apr 06, 2020 06:54 PM
Hello again @Peter_Schindler,
Now that I’m no longer a brand-new user, the forum will let me post the screenshot mentioned above.