Discussions

Expand all | Collapse all

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

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

    Posted 07-25-2018 20:20
    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


  • 2.  RE: Create a formula date field to show the last time a meeting took place

    Posted 07-25-2018 20:24
    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.