Using previsous data from the same sheet

Support
1

Hello Ragic.

I’m trying to use data from previous entries in the same sheet.
Exemple : deduct the previous invoice for the same reference

I tried Link and load, but it doesn’t work … any advice ? thx

2

Hi,

I have the same need to be able to figure out the time difference between two record entries.

Something like this.
image

PREVIOUSROW(value) does not work but something like PREVIOUSROW(FieldID) would be perfect.

Any advice?

Regards

3

Hi Support,

Does the record ID increment sequentially as we could then use this to get the previous record should records not be deleted?

Regards

4

Hi,

You may use the link & load feature to retrieve data from the previous entry.

For example create a field with record ID minus one, which should be your previous entry. Then, load the “Date Time” to the “Previous Entry” field.