Use MIT app inventor app to read data from google sheet and use them in calculation

MIT App Inventor Help
1

Good evening,

I am reading data from google Sheets using MIT App inventor. I want to use these values in some calculations. For that, I need to convert text to numbers but I am not sure which block code I can use for that. Can you assist, please?

image
image719×650 40.7 KB

image
image769×419 20.9 KB

2

Happy Birthday, Sodium!

To fill your ListView .Elements easily,
set ListView1.Elements to split at \n (responseContent) in the Web1.GotText event block.

AI2 will treat text as numbers, if it looks like a number and is non-blank.
AI2 math blocks hate empty values like blanks, though.