When I try to group entries within a form, date and time fields seem to be missing from the field list. Is there a reason why grouping by date isn’t supported? I’d like to be able to sort by reverse chronological order and browse backwards. (This is for an expense-tracking database.) Thanks.
Hello Harold,
There’s no group by date function (yet). But you can sort by date.
Thanks,
Brendan
Thanks for the reply, Brendan. I think adding “group by date” would be a really great addition. I’ll hopefully see it in a future update.
Sure this is an old thread, but for someone who finds this page in the future and wants a workaround, this is what I found to work well
I have a “Date created” field
in addition I made a calculated field called “date as text” which is hidden, and has the formula
DATE( [Date Created]; "yyyy - MM - dd EEEE"), result returned as text
This returns the date in the format: 2020 – 01 – 31 Friday
which not only can be grouped by, but can also be ordered in descending order
Also, in the newer versions of Tap Forms since the original question, if you set the First Sort Field to any Date field, Tap Forms will automatically group them by Month and Year. E.g. February 2020.
.
