Is it possible?
I need the timestamp feature that I can record the current time just with one or two click(s)
but still can be modified manullay.
I use ‘date’ field for this purpose but it displays date that I dont’t need.
Duration field shows only time but it does not support one-click current time insertion.
The only work-around I found is
Column A: date field: 2020/12/15 17:56
Column B: formula filed: DATETIME_FORMAT(‘Column A’, ‘hh:mm’)
There are two problems.
- I have to use two columns to show only one field
- Column B has a timezone issue.
(I live in UTC+9 area. The column A has a local time but column B shows UTC time.
So A is 2020/12/15 17:56, but B is 08:56