Hi, I am trying to create a daily log for my staff. That it is only active as long as the current time is between “Time Start” and “Time End”, but I don’t know what I am doing wrong.
This is my column if
I am by means an expert in glide but I do have a tip that I believe will work. If you create a template column that is set to the value of “Current Time” then you can change your if/then/else column to where “if” is pulling from the “Current Time” column. You can make it [if “Current Time” is after “Time Start”] and [if “Current Time” is before “Time Start”]. Let me know if this works for you or if you have any other questions!
It also looks like you have the “Time Start” and “Time End” columns set to a certain date. This will cause you problems. If you want it to allow for the same time slots each day, I would use a time only column instead of the date and time.
Use false logic:
if time is on or before then false
If time is on or after then false
else true
Because in the “true” logic you loose second case after first true
Oh, i see i haven’t read you question carefully.
It may be because your time start and end are set up as calculated value instead of as an actual time. Is there a reason for that?
On mine, with “Time Start” and “Time End” set as an actual date and time (time only), it works how I understand you are wanting it to.
This should work
Start time 8:30 = 8x60+30=510
End time 22:00 = 22x60=1320
NowMinutes = Hour(NOW)x60+Minute(NOW)
If NowMinutes less Start then false
If NowMinutes greater End then false
Else true
2 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.