Quick Base Discussions

Expand all | Collapse all

Summary field based on Time of Day field

  • 1.  Summary field based on Time of Day field

    Posted 05-03-2017 19:38
    Is there no way to do a summary field based on Time of Day fields?

    In an existing relationship, I want to create 2 summary fields in the Parent table:

    Min of Start Time
    Max of End Time

    However, the Start Time and End Time fields don't even come up for me to select in the "for the field" dropdown:

    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1591516/RackMultipart20170503-9324-m53yrn-Summary_Fields_inline.png?1493840226">
    Thoughts?


  • 2.  RE: Summary field based on Time of Day field

    Posted 05-03-2017 19:46
    Hmmm, I tested and you are correct.  

    I suppose that if you really need this you can make a formula field to turn this into a field that will summarize, such as the number of minutes from midnight, then Summarize that field, and then have another formula on the Parent to convert those minutes back to a Time of Day field.


  • 3.  RE: Summary field based on Time of Day field

    Posted 05-03-2017 20:03
    Thanks Mark, that's a good (albeit tedious) workaround to a simple want. I can't imagine why QuickBase wouldn't allow it.


  • 4.  RE: Summary field based on Time of Day field

    Bronze
    Contributor
    Posted 05-03-2017 20:29
    You CAN do a min or max summary of a date/time field. That might be the solve here. 

    Create a formula date/time field for start date and start time. The formula would be: totimestamp([start date], [start time]) and call it Start Date/Time. Then summarize that value up to your parent record. Just a thought. =]