Forum Discussion

VARCSolutions's avatar
VARCSolutions
Qrew Trainee
21 days ago

URL for current time in Time of Day field

Hey all,

Trying to deal with stamping a Time of Day field with the current time when clicking a button. I know about how "now" functions to do this properly when using a Date/Time field, but it doesn't seem to translate properly into Time of Day fields. It errors if I just try to use "now" in the field assignment and returns nothing if I ToTimeofDay("now").

I can't use Now() because this caches the time the page loads and that won't work for how this process needs to function.

What's my best option to get this handled?

formulas

3 Replies

  • KellyHayes's avatar
    KellyHayes
    Qrew Trainee
    21 days ago

    Could you create a helper date/time field, have your button populate that with the current date/time using "now", and then have your Time of Day field be a formula that just reflects what's in the date/time field - ToTimeOfDay([My Date/Time Field]). It sounds like maybe your users won't need to manually populate the time of day, since it's done via the button. Or am I not understanding your process?

  • VARCSolutions's avatar
    VARCSolutions
    Qrew Trainee
    21 days ago

    No, you're right, but it does have the option of manual override as well. I could just go date/time but they've given pushback on not wanting both to be changeable. I thought about having another set of date/time fields that stamp from "now" in the button and a formula to grab the time from that to run a pipeline over to stamp onto the manual Time of Day fields but that all feels very overkill for what this should be doing.

  • Roy-Wanyoike's avatar
    Roy-Wanyoike
    Qrew Captain
    21 days ago

    How about you change your field to Date/Time (instead of pure Time of Day) if possible. Date/Time fields handle Now () perfectly, and you can display only the time portion on forms/reports using formatting.

    Going your way I think if you're concerned on the exact time of the day then opt for a pipeline which will be listening from a checkbox and when there's is a flip of state. It captures the exact time and then send an update. This way you can capture realtime without being affected by page loads and cache.