Thank you. I get it
How about this problem. How could I fix it?
What problem ?
If you have edited your script at all:
1 Open the script project
2 Go to Publish
3 Deploy as Web App
4 Project version: - select New from the dropdown
5 Execute the app as: your google account address (email)
6 Who has access to the app: Anyone, even anonymous
7 Press the Update button
You have to do this EVERY TIME you change your script
Thank you for your detail instruction!
I'm trying to follow this person Hay Kel. His method look like more simple.
His script: code_AI2Sheet.txt (2.0 KB)
The app run as I want, but on list view. The time of record showing like this
Looking forward to your response!
Hey Kel copied the script code from my site for their youtube videos, but did not account for the fact the the script was bound to a spreadsheet, or that the script auto-selected the first sheet in the spreadsheet. Some of their code in the app is therefore incorrect.
Google sheet date/time formats may just be for viewing only, which means any data returned to the app will provide the entire date number. You could format this using the text replacement blocks or the clock date/time formatting blocks, or entire dates/times as text in your google sheet (put an apostrophe in front before typing the date)
I cant find any document to support this thing. Could you show me how to build the blocks by uising replacment block?
sir I try my best but this system don't work, what's problem? please help me as soon as possible.
scrip not save, show 2 file error massage.
What system, show your blocks, script, sheet ?
Thank you. This system is work,
But create one more problem, no image show from google sheet on my MIT app. How Can I do this?
Exm: google drive or others Image link or any image put on my Google sheet, how I can show or view this image on Appinventor?
If you are trying to display an image embedded in a google spreadsheet (insert image) then this will not work. You will need to place the image url in a cell on the same row.
Long discussion here:
An alternative is to show your google sheet directly in a webviewer using a special url that shows just the cells e.g.
https://docs.google.com/spreadsheets/d/<YOUR FILE ID>/preview
hello, I want to ask a small question. I just want to check whether the barcode exists. However, it appears on the first line during the query.
I do not believe there is an EXISTS function in the gviz query language. You would need to test the returned results to see if any records are returned, therefore confirming that the barcode exists.
The documentation is here Query Language Reference (Version 0.7) | Charts | Google for Developers