Accessing Previous Records


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”).


You can’t.


@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.