Skip to main content

How to deal with previous rows?

  • June 21, 2017
  • 2 replies
  • 47 views

Forum|alt.badge.img+10

Hey there,

I’m doing some kind of logging in Airtable, Each row gets its manual entry from time to time. I use a formular to have the date a row was created and enter some values.

Now I’d like to have another column that takes values from the previous row and does some calculation – sums and differences compared to the actual row.

Is this possible?

Cheers,
Frank

This topic has been closed for replies.

2 replies

  • Known Participant
  • June 21, 2017

I think the rollup field type may have what you seek


Forum|alt.badge.img+17
  • Inspiring
  • June 28, 2017

AirTable doesn’t really have a concept of “previous row”; row order can change when you sort or group entries. It’s probably better to create another column to perform the calculation in the “previous row” and then manually copy and paste the result into the “current row”.