Google sheets bulk add rows from JSON, but need numbers to use commas instead of periods

[Romain_cote]

Hello, I’m using a JSON to bulk add rows to my google sheet. The issue is that it uses periods rather than commas as separators in numbers, but my google sheets regional settings use commas rather than periods as separators for $$ amounts, for example.

I tried to use the replace function after the JSON, the problem is the JSON is returning multiple bundles containing multiple arrays and I’m not sure how to replace while retaining the structure.

I’m sure there is a simple way to do this, right?

Factures Communauto.blueprint (1).json (58.6 KB)

[L_Duperval]

Bonjour Romain,

You neet the formatNumber() function:

formatNumber(number; decimalPlaces; decimalSeparator; thousandSeparator)

Docs are here: Math functions - Help Center

L

[Romain_cote]

Hi L_Duperval,

brilliant, thank you!

[Romain_cote]

One more question, in the Google sheets bulk add rows, is there a way to add as many rows as there are values in the input array? At the moment I have to specify which element of the array I want to add for each row but it seems ineficient and “dumb”. I must be missing something here to be able to loop it.

[L_Duperval]

Does this help:

How to use Bulk Add/Update Rows in Google Sheets?

Welcome to the Make community! Every result (item/record) from a search/match module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort. Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and has applies to many use-cases. There are other types of aggre…

L