How to display Good morning/afternoon/evening based on Current time?

Ask for Help
1

I have a welcome screen with a button to track user login time. Set (Log in time) to current time.
But is there a way to display “Good Morning” or “Good Evening” based on the (Log in time)?

2

You mean based on the current time, right?

  • Use a math column to determine the current hour of the day: Hour(Now)
  • Then use that in an if-then-else column:
    – If Hour > 18, then Evening
    – If Hour > 12, then Afternoon
    – Else Morning
  • Then use that in a template column
5 Likes
3

Sometimes, I overcomplicate things! :rofl:

1 Like
4

Encounter a similar issue with Computer Columns not able to have less than or more than conditions.

image
image602×516 29.5 KB

5

You need to convert the current time to a number using the formula that I gave you earlier:

CleanShot 2023-08-05 at 19.47.22@2x
CleanShot 2023-08-05 at 19.47.22@2x878×664 33.4 KB

1 Like
6

Ah that’s a formula! I was using the option > Now.
Is there anywhere to refer such formulas or are they basically Excel formulas?

7

All the supported functions are listed in the Docs.

2 Likes
8

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.