How can I make a blank date pull in if the most recent version does not already have a date using record ID Maximum Summary?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Under Table-to-table relationships I created a Maximum date (summary) field that is looking for the date from the most recent version of a design.  How can I make a blank date pull in if the most recent version does not already have a date?

Photo of Yang

Yang

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,630 Points 50k badge 2x thumb
If the most recent version does not have a date, then what is the definition of the most recent version?  Is it the one with the highest Record ID#?
Photo of Yang

Yang

  • 0 Points
yes, the one with the highest Record ID#.  We are using version # field to determine most recent version and the the date may be blank as we are using forecast and Actual dates so that's why it may be blank.

So for example,

Version 1 Forecast Date: 8-5-15 Actual Date: 8-1-15
Version 2 Forecast Date: 8-20-15 Actual Date: ______

So it pulls version 2 but actual date for version 2 would be blank when it pulls.  On a side note, its not report, but in the forms of a table.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,630 Points 50k badge 2x thumb
You will need a reverse  relationship.  easy to do.

Make a summary of the maximum record ID# of the verions, called [Record ID# of latest version]



Then make a new relationship where 1 version is related to many Parents (I don't know what you real parent table is called) and base the reference field n the bright side to be that new field [Record ID# of latest version].

Then lookup the date field down (up) to the Parent.
Photo of Yang

Yang

  • 0 Points
my concern is the reverse relationship.  Because in this case, 1 version will be tied to multiple parents when in actuality, its not the case.  How will that work?  Unless it's just a trick to make it work.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,630 Points 50k badge 2x thumb
Yes exactly.  It's the trick that is commonly used to float up info form the child to the parent.  It's called a reverse relationship technique because it seems backwards.  You are right to think that this is backwards.