Forum Discussion

JustinParker's avatar
JustinParker
Qrew Trainee
6 years ago

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

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

1 Reply

  • 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.