Forum Discussion

JontyFoster's avatar
JontyFoster
Qrew Member
3 years ago

what formula do I get a time of day field to read another time day and add 8 hours?

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
------------------------------
  • 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
    ------------------------------
    • JontyFoster's avatar
      JontyFoster
      Qrew Member
      Thanks

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