Group by Timestamp Problems

I am working on an app where students can share what they learned today.
Here is a link to the current prototype: https://right-stomach-4836.glideapp.io/

The form writes to the sheet with the current date and the new user given insight.

But, when I try to “GROUP” the learning by DATE, it splits it up. (Because in the background it is actually the date AND the TIME (so the app sees each as a different “date”)
You can see, I even changed the DATE format to just the date.

image

Any thoughts?

1 Like

Yeah as you said, in the background it still is the full package of date & time so there lies the problem.

To fix this, Glide needs to allow us to choose what to write to the Sheet in the datetime component in the form, like the formats they allow in the datetime column.

For now, your best bet is to convert that to a date only value in the Sheets using an arrayformula.

Ohhh… tell me more … what would an array formula look like?
(maybe this should be in Spreadsheet Magic)

Let me quickly make an example in my sheet and share with you.

I used a combination of TO_DATE and INT in cell B1 to convert the datetime to date (and appropriate formatting inside the Sheets). Let me know if it works for your case.

I would maybe try creating a template column to store the formatted date. Then group by the template column. Seems to work for most other things like math and number columns that have precision set.

1 Like

Wow, that worked… I guess the template just reads what is in the cell and ‘turns it into’ just that text?

2 Likes

It appears so. I’ve used that hack quite a bit with math and number columns.

1 Like