This is more to the point:
http://ai2.appinventor.mit.edu.ezproxy.canberra.edu.au/reference/other/googlesheets-api-setup.html
1 Like
HOO thank you, it works 
but sorry.. when i click "reset" in my apps, the data in spreadsheets will empty. but an error appears when I start retrieving the data and want to display it. iis it because i deleted my database? what should i do?
Show us where you do your math + operations.
this is my aia n code
Alicia_TinyML_DataLogger_ext.aia (411.3 KB)
NEW_XIAO_BLE_ACC_Data_Logger.ino (10.6 KB)
You had blanks in that column, and Ai2 math blocks hate blanks.
These draggable blocks should filter out the blanks.
what is NZ? what that mean? what should I enter there? I call columns on a spreadsheet
this is my database
NZ is a value procedure I just coded to take a value, check if it is a number, and return 0 if it is not a number.
I named it after a common spreadsheet function
https://www.google.com/search?q=nz%28%29
See
http://www.appinventor.org/bookChapters/chapter21.pdf
from the free book at
http://www.appinventor.org/book2
the application works fine in reading and displaying the previous "distance" value, but when I delete the value in the database. the function is different and there are errors. I think something went wrong when calling the data, after the value in the database was deleted. but idk what its is
it was new data that I sent, I tried to display that data in the application, but it couldn't
the problem starts after i delete all data. the previous value indicates this number. but now the distance value not appear
This has exceeded my complexity limit:
- I can't translate the headings
- You clear only partial ranges
- You request parallel columns, but do not request them as a single contiguous range to get them together at the same time
- You are using an unfamiliar charting extension
In point 3, how can i fix it? I used the first chart extension. I deleted all the data but I also tried to delete some of it
Is it just that block that I need to change?
How to display new data from a spreadsheet column in MIT App Inventor if there are empty values when the old data has been deleted. displays data that only has values. i need to display the distance value. The value is not displayed because there is empty data in column G. can u show me the block how fix it?
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.