How do I send decimal numbers to google sheet?

MIT App Inventor Help
1

Hello, I need some help. I have a textbox on my app that reads the average of some spiners, I want to send this number to google sheets but when the number at the textbox is 0.09091 at the google sheet it appears as 9.091. Thanks

2

How are you sending the data to google sheets ?

Please show your relevant blocks, scripts etc.

3

This is the script and the bocks

script
script1314×826 85.2 KB
blocks
blocks8890×3802 1.71 MB

4

Hmmm... nothing there that gives any indication why 0.09091 would be converted to 9.091. Check your google sheet is not converting it from a number to a percentage ?

You may need a bit more script to clear any formatting in the row/sheet you append to:

https://developers.google.com/apps-script/reference/spreadsheet/range#clearformat

5

Thanks for the reply! I will try it !

6

Yes it converts it to a percentage.

7

Tada....... :slight_smile:

8

thank you very much!

9

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.