Hi,
I found what looks like a bug or at least an unnecessary limitation in self-hosted Baserow.
I am running:
-
Baserow 2.1.2
-
self-hosted via Docker
-
image: baserow/baserow:latest pulled around February 2026
I have a table where:
-
fill dur sync is a regular duration field
-
k dur is a number field
-
dur sync is a formula field with this formula:
field('fill dur sync') * if(field('k dur') != "", field('k dur'), 1)
Baserow correctly detects dur sync as a formula with duration output, and the values display correctly in the grid, for example 2:30:00.
However, in the Grid view footer, for this column the Summarize menu only shows None.
At the same time:
-
a normal duration field can be summarized with sum
-
a formula field returning a number can be summarized
-
but a formula field returning duration cannot be summarized at all
This seems inconsistent, because the underlying data is still a duration and PostgreSQL can sum it correctly.
I checked this on the backend and confirmed that summing the formula field works technically. In my case, a direct aggregate on the table model returns the correct result for the formula duration field as well.
From the code, it looks like the limitation comes from the aggregation compatibility list:
SumViewAggregationType allows:
-
NumberFieldType
-
RatingFieldType
-
DurationFieldType
-
formula fields only when the formula type is number
So formula fields with duration output are excluded from sum, even though they appear to work correctly at the database level.
Expected behavior:
A formula field with duration output should support sum in Grid view footer summarize, just like a normal duration field.
Actual behavior:
The summarize dropdown for that field only shows None.
It would be great if formula fields returning duration were allowed in summarize/aggregation, at least for sum, and possibly also for min/max where appropriate.
If needed, I can also provide:
-
exact table setup
-
screenshots
-
the relevant code location I found in the backend
