What is your goal?
Solve the formatting problem
What is the problem & what have you tried?
Hi there! What a great tool that GSheets Bulk Update! However, I come across a format issue. My current test flow exists of three modules: GSheets Watch New Rows, Array Aggregator; Gsheets Bulk Update Rows. My current sheets use a comma as decimal separator. I want to make a calculation of a few columns (variables).
I’ve added a formula in the “Value” section of the Array Aggregator. This works with parseNumber and to multiply them. To add an additional formatNumber doesn’t work. Obviously adding the module “Tools” to address Variables solves the formatting issue, but then the whole benefit of having the Bulk Update has gone up in smoke. What am I missing? Many thanks.
Error messages or input/output bundles
NaN. Solved that. Now the outcome is a decimal point, which is in fact the 1.000 seperator. Google Sheets Settings are European (decimal comma).
Screenshots (scenario flow, module settings, errors)