Help

Accessing Previous Records

4125 6
cancel
Showing results for 
Search instead for 
Did you mean: 
KEN_BURENGA
4 - Data Explorer
4 - Data Explorer

Is there a way to add the contents of a field in a record from the same field of the previous record. For example, if the date in the new record is the same as the date in the previous record I want to change the formula field in the new record — i.e, If (Current Record {Date}=Previous Record {Date}, {Field 1}=“ABC”, {Field 2}=“DEF”).

6 Replies 6

You can’t.

bdelanghe
7 - App Architect
7 - App Architect

@Elias_Gomez_Sainz what @Jeremy_Oglesby is saying isn’t that it can’t. But that it’s a lot of work. @KEN_BURENGA definitely read into the linked post. Essentially what you end up doing is defining what the previous record is by adding a linked field.

@KEN_BURENGA @Elias_Gomez_Sainz

I solved something an issue for another user today that involves a new record checking values of the record that immediately precedes it by comparing dates (see below). Could you describe what you want to do in a little more detail? Or feel free to copy the base from the link below and adjust it to fit your needs.

I went through the comments on this topic again and it dawned on me that Airtable actually calculates between records all the time. The Summary Bar at the bottom has a lot of it. For example: the summary “range” finds the lowest of all the records and the highest of all the records in a view, and calculates the difference.

Now, if it can be done in a Summary bar, it can be done in a regular Formula.
So Airtable: just show the community some muscles and bring it on :winking_face:

Regards,
André

Great observation André. I [rhetorically] ask myself this every morning and my wife is tiring from my mumbling.

The issue is that the development team has not exposed the event model (which obviously exists) at the formula or API surfaces. This is one of many critical elements that are gating factors concerning the future of Airtable because it limits the ability for regular users to perform usual and customary computations.

Making matters worse, they limit API calls to 5 per second. Without event handlers, they are forced to do this, of course, or continue to add more servers and bigger pipes. The lack of an accessible event model puts added pressure on the use of the API to mimic that which is effortlessly determined through events, so they’re in a difficult spot now.

Agree - they need to pull up soon.

Hi Bill,

Thanks for confirming. A lot of your text is new to me for I’m really not very familiar with the ins and outs of the machine room in AT.

I do hope they will make steps in this realm, for it will benefit a lot of users.

Regards,
André