search

Budibase / budibase

Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MariaDB, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀
https://budibase.com
Other
22.42k stars 1.54k forks source link

Table setting to display large numbers with commas #14820

Closed mikesealey closed 54 minutes ago

mikesealey commented 2 hours ago

Describe the feature request Create an option in the table to process number columns with commas to separate thousands.

This would likely make use of number.toLocaleString() but it would need to impact the display only, and not actually change the value from number to string

Currently, the workaround involves a quick formula column, but that approach isn't ideal.

Screenshots image

linear[bot] commented 2 hours ago

BUDI-8759 Table setting to display large numbers with commas

aptkingston commented 2 hours ago

Do you reckon there's ever a downside to this? Or could we just bake it in as the default functionality always?

aptkingston commented 2 hours ago

Just going to ship this as the default going forwards because I've often found myself wanting the same thing!

mikesealey commented 2 hours ago

Do you reckon there's ever a downside to this?

Would someone ever use a number column to store binary?

Also some European countries use a full-stop where I would use a comma, and a comma as the decimal point.

aptkingston commented 1 hour ago

Do you reckon there's ever a downside to this?

Would someone ever use a number column to store binary?

Also some European countries use a full-stop where I would use a comma, and a comma as the decimal point.

Locale string is exactly for this :) it will use the correct delimiter according to whatever the user's locale says - so it will be decimal points instead of commas for Europeans for example.