Create a formula date field to show the last time a meeting took place

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
As part of my business, my managers are required to have monthly meetings and record the meeting notes into QuickBase. 

Each meeting is saved as its own record.  I would like to be able to build a formula date field that outputs the date of when the MOST RECENT Contract meeting took place so I can be alerted if a meeting is missed. 

I have a text field [Contract] and a date field [Date of Meeting]

Any help would be greatly appreciated
Photo of Justin Parker

Justin Parker

  • 152 Points 100 badge 2x thumb

Posted 5 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
If there is a Relationship where 1 Contract has Many Monthly Meetings, then you just navigate back to that Relationship and add a Summary field on the left side to Summarize the Maximum of the date field.  That would then be on the Contract Record and can be used on a report of contracts.