Today date without user login

I want to get the current month from when user open the app, without login.
Is there a way to get it?

As long as you force the user to click a button or perform some sort of action when they first open the app, you can get the current date/time through that action from the Special Column Values and add a row to a sheet with the date/time or set the value to a user specific column.

If you simply want the current date/time, you can add a math column to your sheets that gets the current date/time. If you wanted only the date, you could wrap the value in the math column with MONTH(date). That would give you the month number that you can convert to the word version with an IF column


@Jeff_Hager I just had an epiphany!
In my apps, I have lots of columns that look like this:

As I was creating yet another one of these yesterday I was thinking to myself “there must be an easier way”. And then it hit me just now as I was reading your post…

Challenge: Extract the short month name from a date (eg. “Jan”)

The way I normally do this is by first extracting the Month and Day components using date math, and then that stupid if-then-else column to determine the month name.

But there is a much easier way…

  • Create a Text column that contains all the month names
  • Then do a direct lookup on this column with a Single Value, using the calculated month number as an offset from the start.

Soooooo much easier!! :laughing:


That’s smart!


Smart thinking!

Thanks @Darren_Murphy , @Darren_Murphy for the replys.
I will try yours @Darren_Murphy , it’s very smart indeed.

1 Like