Discussions

Expand all | Collapse all

Adding Duration Fields

  • 1.  Adding Duration Fields

    Posted 03-06-2020 15:54
    I am trying to add duration fields but if one is blank the total doesn't show.  Any suggestions?

    [End Time 1] - [Start Time 1]  =  [Time 1 Total]
    [End Time 2] - [Start Time 2]  =  [Time 2 Total]
    [End Time 3] - [Start Time 3]  =  [Time 3 Total]

    So if [Time 1 Total] is 1 hour and [Time 2 Total] is 30 min and [Time 3 Total] is blank it won't give me a [Total Time] ([Time 1 Total]+[Time 2 Total]+[Time 3 Total])

    How do I get a total if one of the [Time Total Fields] is blank (null)

    ------------------------------
    Mark Comish
    ------------------------------


  • 2.  RE: Adding Duration Fields

    Posted 03-06-2020 15:58
    np,
    use the Nz() function which will treat any nulls as zeros.

    The formula for the field [Time 1 Total]  should be

    Nz([End Time 1] - [Start Time 1])

    etc for each of the three fields.


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Adding Duration Fields

    Posted 03-06-2020 16:52
    As usual you are the man!!!  Thank you!

    Another question

    On Grid Edit I am pulling from from a field on another table "Opportunities" (Parent Table).  It shows all opportunities but I only want the ones that are from a certain [Division].  I can't seem to figure out how to limit it.

    Thanks as always

    ------------------------------
    Mark Comish
    ------------------------------



  • 4.  RE: Adding Duration Fields

    Posted 03-06-2020 19:42

    Sorry, but I'm not understanding the question. 


    Is this an embedded report o a parent record form?



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Adding Duration Fields

    Posted 03-06-2020 22:14
    How to make the Opportunities show on Opportunities that are from a certain


    ------------------------------
    Mark Comish
    ------------------------------



  • 6.  RE: Adding Duration Fields

    Posted 03-07-2020 22:07
    Mark,

    Is this in a Cross App relationship?  it appears Krista Time Tracker has only a single table in the app.


    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 7.  RE: Adding Duration Fields

    Posted 03-07-2020 22:23
    Yes it is.  I actually figured it out with multiple forms, roles and reports.  Thank you for taking a look at this.

    ------------------------------
    Mark Comish
    ------------------------------



  • 8.  RE: Adding Duration Fields

    Posted 03-08-2020 09:45
    Seems like you got it working, but fir the record, the technique is to create a form called perhaps Grid Edit, to specify the field sequence and the reports used for the drop down fields, and then in Forms Usage to use the Grid Edit form for Grid Edit.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------