Fun with Dates

Fair enough you got me there. What I should have said was equal to the same “ambient temperature”.

We could all take comfort in knowing no matter where your friends are in the world we all feel -40 c and -40 F the same.

2 Likes

:heart_eyes: :heart_eyes: :heart_eyes:

1 Like

Except for some of us that never happens, and never will (I hope) :stuck_out_tongue:

2 Likes

Probably the best reply, ahahaha

@Jeff_Hager @ThinhDinh or whoever knows this:

Can Math column count how many characters we have in a text/number column? :worried:

I’ve already requested, but I super needed now

I don’t know about the Math Column in Glide, but the “=LEN()” function/formula will count the characters in your GSheet.

Yeah, the point with formulas is the spreadsheet response time

Yeah I know what you mean…whereas the Math Column would be instant…

1 Like

Not easily, but if you’re willing to put in some work, this is the only solution I know of that’s contained within Glide and shows a count in real time (Not in add/edit/form mode).

3 Likes

Damn @Jeff_Hager , you’re the Lord.

image

4 Likes

If you are only counting characters on numeric columns, I think you can skip the ‘1’ column and the template column and just do the math directly on the numeric column.

3 Likes

Actually I’m using both, and it worked perfectly

3 Likes

Greetings,
I have a problem, I’m trying to add dates, but specifically months. Ex: today (02/05/2021 + 18 months) trying to do it by MATH, but the expressions DATEM or Month are not valid.
Can someone help me?

Sorry for the writing I’m using google translator …

Here you go. Just use 1.5 years for the number of years, or you can take your number of months and divide by 12. Same thing either way.

3 Likes

Quick Q - can’t think… :thinking:

Using 'glide tables’

I need to calculate the day from a date so ‘NOW’ = ‘Wednesday’ (in the uk)

Day(NOW) will give you the day (number) of the week, then plug that into an ITE

1 Like

Used this in a recent app for a client — check it out:

4 Likes

@Jeff_Hager perhaps a flaw here?

Makes sense, I think
‘Now’ is always going to be ‘Now’ :slightly_smiling_face:

1 Like