Hello After changing of figures for example 5 to 10, how to do that that old background color back to normal color( without ) it? And so on. From 10 to 3, background change again for new and old one too. thanks in advance
This was an older way, they've changed the output from sheets now to get directly from queries just like a database. I have several newer videos on this topic. You can create the strings on the AJAX request it doesn't have to be an object
Great tutorial sir. Thank you for this. I just want to ask if you know how to create a dropdown list and fetch from g.sheets and then the answer is chosen can display on the webpage. I hope you get it. Thank you again
sir, is there is any ways to securing api endpoint to avoid user accessing directly to json data from sheet on the web using shared link? for example maybe like php auth..
No its shared with the Get method, although you can use a script login to your Google account, You can also use backend code to make the requests and return the data within you own PHP output
@@LaurenceSvekisCourses yes, but when some user login and doing inspect element, then shared link spreadsheet can easily accesible.. not to worry if not a credential data..But will be bad if the fetch url are containing username or users password..
after ${query1} (which is "/gviz/tq"), you can add "?gid=SHEET_ID" you can see gid in google sheets URL on current selected sheet) now you get data from the other sheet. So final is like this: endpoint/gviz/tq?gid=123123123 (source now is Sheet2)
@@LaurenceSvekisCourses thanks problem is fixed , after deleting extra empty cells , but Laurence , if i m entry Date in cell its changed data into 0.62 something. your help is really appreciated.. thanks man you are legend.
Thanks for this! I followed all your instructions but keep receiving the following error in console. Any ideas on how to fix it? Uncaught (in promise) SyntaxError: Unexpected token '/', "/*O_o*/ go"... is not valid JSON at JSON.parse () at app.js:21:19
Excellent explanation, super clear. It's just I needed it. Thank you!
Thank You Master 💪
Thank you too!
great thank you
Welcome 😊
Hello
After changing of figures for example 5 to 10, how to do that that old background color back to normal color( without ) it?
And so on. From 10 to 3, background change again for new and old one too.
thanks in advance
thank you for your support
How would I impliment a way to get strings through this? Thanks for the great tutorial!
This was an older way, they've changed the output from sheets now to get directly from queries just like a database. I have several newer videos on this topic. You can create the strings on the AJAX request it doesn't have to be an object
Great tutorial sir. Thank you for this. I just want to ask if you know how to create a dropdown list and fetch from g.sheets and then the answer is chosen can display on the webpage. I hope you get it. Thank you again
You can make an initial request for the data or setup thee end point to return back specific queries
@@LaurenceSvekisCourses Thank you sir, goin to try that method.
i want to add multiple sheets in dropdown dynamically use googlesheet api plz help me
You can select the sheets using getSheets() and then use an array to build the object for the drop down.
@@LaurenceSvekisCourses thanks and great tutorials @Laurence Svekis :-)😀
@Emotional Shayari yes
sir, is there is any ways to securing api endpoint to avoid user accessing directly to json data from sheet on the web using shared link? for example maybe like php auth..
No its shared with the Get method, although you can use a script login to your Google account, You can also use backend code to make the requests and return the data within you own PHP output
@@LaurenceSvekisCourses yes, but when some user login and doing inspect element, then shared link spreadsheet can easily accesible..
not to worry if not a credential data..But will be bad if the fetch url are containing username or users password..
Is it possible to make a crud without using api? Thanks
Apps Script only support doPost() and doGet() methods, although you can send additional parameters to post for other methods.
U didn't show how to get the data of different sheet... I mean how to get the data of 2nd sheet by sheet name.
You can select the sheet or the entire workbook in the web publish options
after ${query1} (which is "/gviz/tq"), you can add "?gid=SHEET_ID" you can see gid in google sheets URL on current selected sheet) now you get data from the other sheet. So final is like this: endpoint/gviz/tq?gid=123123123 (source now is Sheet2)
Please guide me on how to generate Json callback url for any google sheet. Which will be used in angular js.
The endpoint URI can be used the same way making the request via angular instead of JavaScript
how to write and update please sir!
check my github I have all the code
i m using character and instead of digits, please help me
Its the same for any data. The cells share the content
@@LaurenceSvekisCourses thanks problem is fixed , after deleting extra empty cells , but Laurence , if i m entry Date in cell its changed data into 0.62 something. your help is really appreciated.. thanks man you are legend.
Жалко, что не на русском.
thanks
Thanks for this! I followed all your instructions but keep receiving the following error in console. Any ideas on how to fix it?
Uncaught (in promise) SyntaxError: Unexpected token '/', "/*O_o*/
go"... is not valid JSON
at JSON.parse ()
at app.js:21:19
There is an issue with the JSON format, its likely not a JSON data file that is returned