Discussions

 View Only
  • 1.  what formula do I get a time of day field to read another time day and add 8 hours?

    Posted 09-22-2022 01:05
    Hey I'm trying to make a timesheet app, I want my end of work field (which is a time of day field) to instantly add 8 hours when I put my start time into a different time of day field?

    ------------------------------
    Jonty Foster
    ------------------------------


  • 2.  RE: what formula do I get a time of day field to read another time day and add 8 hours?

    Posted 09-22-2022 10:56
    You be able to make a new formula field  called [TOD + 8 hours]

    [my time of day field] + hours(8)

    And you can have a form rule which says that when the end time is blank and the start time is not blank change the end time  to be the value in the field [TOD + 8 hours].

    You would have to test but you probably need to have that formula field on the form for the form rule to work properly. If you find that you can put it into a section of the form which is hidden by a form rule.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: what formula do I get a time of day field to read another time day and add 8 hours?

    Posted 09-22-2022 22:28
    Thanks

    ------------------------------
    Jonty Foster
    ------------------------------