Forum Discussion

JessicaFeauto2's avatar
JessicaFeauto2
Qrew Cadet
8 years ago

Pull data from previous line into current line

I would like to create a way to have the field Due Dates be a number of days after the Due Date in the previous line.  In the picture below, the Expected Business Days for Completion is user input (an...
Ask about Quickbase functionality
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
If you are certain that the record IDs will be sequential, then you can relate the table to itself.  Make a field with the formula [Record ID#]-1.  Call, it [Previous Record ID#].

Then make the relationship t of your table to itself based on that field on the right side of the relationship.  Then look up field(s) from the previous record to the record.