We hope that thousands separators will be introduced soon.
We would like to be able to restrict the number of digits that can be inserted in a number field (e.g. four).
If would be nice if we could select “only year” in date fields.
Hey @Mary-Lou,
This is coming soon: Advanced number formatting (#1270) · Issues · Baserow / baserow · GitLab
Noted! I’ll discuss this request with the team.
Hi @olgatrykush,
Yes, I saw. But Advanced number formatting seems ages away (weight: 742000).
I had hoped that the thousands separators might get preferential treatment. At this point, working with numbers in BaseRow is very very very inconvenient.
What we do at the moment is to send data to a Google Sheet via Make.com, run some calculations, and then update the Baserow Table again.
If the number formatting inside Baserow could be improved and also some more complex calculations and formulas were made available, then more use cases could be handled inside Baserow directly. But its fine, Baserow actually has been very useful and can handle large datasets. Thats the main advantage. Thanks
1 Like
Quick update on this! Showing only the ‘year’ could be introduced, but only as a separate field type, and we don’t have any plans to add it yet. As a workaround, you can use the formula function ‘year’:
Hope it helps!
Hi! It is a good workaround, but only while it is possible to fully use a formula field, I mean in group by, filter and etc…
A formula field can be used in the group by feature and for filtering. Doesn’t it work for you?
Ah, you’re right, the formulas are working fine. What’s missing is the ability to use fields with types like link, lookup, etc. in filters and groupings. Sorry for the confusion earlier)
1 Like
Hi Mary-Lou, I am a new Baserow user and I love the number formatting feature just like you. Just want to tell you that the Baserow team has updated the weight of the issue to 800000 and the issue is now pretty high on the list. Well, I expected the weight will change because something more urgent may come up, but still, it’s glad to see that Baserow team does see how important it is for the number field to be formatted properly.
Let’s hope that the feature will be available by the end of this year.