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 (and can change from Project to Project).  Additionally, the specific milestones can change from Project to Project.  I would like to make it so that the Due Date equals the previous Due Date plus the expected Business Days for completion.  

In this case, the Milestones should be made sequentially so using a relationship with some type of Record ID# - 1 might work, but I can't seem to get it to work properly.
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.
  • JessicaFeauto2's avatar
    JessicaFeauto2
    Qrew Cadet
    8 years ago
    Didn't realize you could relate a table to itself!  So much easier than the other ways I was trying to do it! Thanks Mark!
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    no problem,

    Ok course, that does assume that the records are being created sequentially!  So you will need to enforce that somehow.
  • JessicaFeauto2's avatar
    JessicaFeauto2
    Qrew Cadet
    8 years ago
    Is there anyway to do this if the Key field isn't the Record ID, therefore the Key field isn't sequential?  I'm trying this technique for a different project but didn't realize that the previous builder changed the Key field.

    I'm assuming not, but thought I'd ask.