For some reason, my formatNumber() output is incorrect.
I have the following setup.
The basic trigger generates an output of 150000
The formatNumber() at the Google Sheet is set as follows
I expect my output to be 150000, 150,000.0, and 150,000.00
But I get this instead. What did I do wrong? Thanks
Welcome to the Make community!
There is probably formatting in Sheets itself, and Sheets has automatically converted the format for you.
To prevent this, select Unformatted “YES”:
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
Hi @samliew, thanks for your reply. I have tried “unformatted” , but my output is still wrong.
I also tried parseNumber() with and without “unformatted”, the output is still wrong.
Would you be able to get the right output on your end?
Sorry, I remembered incorrectly.
You should also set the input mode to RAW, in the advanced settings.
With the above settings, it works for me:
Output:
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
Hi @samliew, thank you very much!
It only needs the “Raw” input to work on my end.
No need to use “Unformatted” or “parseNumber()”.
Thanks again
