Function if and

Ask for Help
1

Hi I’m stuck on an if - and condition Basically I have the column with today’s date and the column with today’s time I should make sure that if the date is today’s and the time is greater than 11 am you have to send a notification otherwise send the new row I don’t know if the if function exists and otherwise I don’t know how to get there If someone can kindly direct me Thanks

1 Like
2

Hey Yoda! Glad to see you again.
Can you be more specific on what u meant by this:

3

if today’s date is in the date column and the time column is greater than 11:00 a.m. then notify me “too late” otherwise start the action

1 Like
4

To do this in Glide:

  1. Add a “Now” column to get the current date and time.
  2. Split your date and time columns if needed (“Date” and “Time”).
  3. Create an “If Then Else” column with this logic:

If Date is today and Time is after 11:00 AM → Send Notification
Else → Just send new row

You can then use this column to trigger actions like notifications or sending data.

5

Is it a scheduled workflow or a user-initiated workflow?

Regardless, you can try a math column with an HOUR(Time) function. That will return a number in a 24-hour format. If it’s greater than 11, you do something, else you do something else.

The difference is scheduled workflows run server-side, and will use UTC+0 I believe.

1 Like
6

I used this logic but I don’t understand how to set the “if then else” column because I can’t find the way to add “and”

1 Like
7

There’s no way to add “AND” in an if-then-else column. You have to work through the logic in a bit of an unconventional way.

1 Like
8

I had to change my reasoning and in the end I succeeded

2 Likes