How to Pull Data From Google Sheet To HTML Table Using Apps Script
HTML-код
- Опубликовано: 9 сен 2024
- About Video:
Is Video me Google Sheet (Spreadsheet) ke data ko Apps Script aur JavaScript ka upyog kar HTML Table me data Display Kiya hain.
00:00:00 Introduction
01:19:02 Apps Script doGet Function
06:04:00 HTML Basic Page
07:00:00 JavaScript (jQuery)
13:16:13 Live Testing
Read More at
selfimaginatio...
Fixing Google Sheets HTML Date Display: Showing Correct Date (One Day Behind) Solution
• 📰Fixing Google Sheets ...
#hindi #appsscript #html #javascript #googlesheets #spreadsheets
I love all video❤❤❤❤❤❤❤❤
Thanks for Watching.
Hello sir kya google sheet ke data ko wordpress website pr live update ke sath add kar sakte .
Or jab view page source karke dekhe to o google sheet ka data article contant ho. Na ki embed ho kya asa kar sakte hai to kaise ?
Yes, Bilkul dekh sakte hain,
Lekin jab bhi ham koi live data Display karwate hain to embed hi karna hota hain. Requirement ke anusar depend karta hain. Embed me bhi koi static page banwa kar add kar diya ja sakta hain.
Hi, I've joined this code with the last code (how to submit html form to google sheet), but it didn't work. Do we need to do any change?
Thanks for Watching. Although there is no need for change, maybe there may be some syntax issue, you should check once, if still not there then you should check step by step, using console.log or using alert. If you still face any issue, please let me know if there is any error being displayed on the console, I will try to solve it.
Hello sir, form validation kase lagae 2 input field m (to prevent empty form submit) as well as with timestemp just like google form please sir aap esss video m batao
I always watch your video ❤️ & thank you jo aap detail m explain krte hai.
Welcome, Video on validation will come soon
Bootstrap Invoice Validation Video Published
Sir, do you create video how to insert all those data into database MySQL?
Thanks for Watching, There is a video on this channel by the name of "How to Connect HTML to MySQL Database using PHP"
Sir hm search Kr ke jo matching kre vo data display kr sakte h?
Thanks for Watching, Ha kar skate hain, Isi channel par ek video hain use aap dekhe, aapko help mil sakti hain "HTML Invoice Search From Google Sheet Using Apps Script"
null value return ho rahi other function
function Getdata()
{
let obj = {};
let data = RcptSheet.getDataRange().getValues();
obj.content = data;
retrun ContentService.createTextOutput(JSON.stringify(obj)).setMimeType(ContentService.MimeType.JSON);
}
html ke page par null hi aata hai sir ji please help
aapne Javascript se Getdata function ko kis tarah se call kiya hain , wah code mujhe comment kijiye
You replace the return statement with the following statement
return JSON.stringify(obj);
nice
Thanks
sir ,mujhe aapse ek code m help chahiye
Thanks For Watching , आप मुझे Email (About Section मे आपको Email मिल जाएगा) कर दीजिए .
sir agar Particular ke pahle ek column add krna hai jisme ki category aaye or category jo ki google sheet ke kisi sheet se link ho. or jb hm category select kre to us category se related item ki dropdown menu mil jaye . agr category or item ka naam dono google sheet se lana chahe to kya possible hai ? agar possible hai to please modify kr k ap mujhe mere business ke liye ek invoice bna dijiye mai apke is mehnat ke liye payment kr dunga
Bilkul ho sakta hain,
Aapki jo bhi Requirement hain mujhe Detail mujhe mail kar dijiye.
@@selfimagination thanks
@@selfimagination Maine apko sheet share kiya hai apke is email id pr
@@selfimagination please share your email id i have some requirements from you sir
I have replied to the mail sent by you.