Templates Plugins Courses

Datatables plugin- CSV Export issue with formatted numbers

I am having issues exporting a datatable with formatted numbers to CSV.

200,000.50 is easier to read than 200000.50

I would like to use commas as the thousand separator rather than spaces so the numbers can easily be worked with in Excel.

How can I solve this?

Hello @ifeoma, thank you for your message, and thanks for using our plugin :slightly_smiling_face:

We are currently checking the feasibility of your request and will get back with an update once there will be any progress.

Thank you for your patience and understanding.

Have a good day!

Hi @ifeoma, thank you for your patience.

The exported data is saved inside the databases, usually the data is stored as numbers thus there are no dots to format the numbers. This is how Bubble’s databases are structured, unfortunately there is no way we can influence the format.
As an alternative, it is possible to mention the data type as text, as this will allow you store the number in the format that works best for you.

Let me know if this worked for you, or if you got any other questions.