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

Question

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

quickbasecoachd · Answer

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.&nbsp; That would then be on the Contract Record and can be used on a report of contracts.

Forum Discussion

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

Related Content

Create a formula duration over 5 years

AI Smart Builder for Creating Apps and Streamlining Pipelines

create pipeline to create new records based on current record

URL formula -API_RunImport

Formula Url Buttons