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

Комментарии • 26

  • @globalwastesolution2055
    @globalwastesolution2055 6 месяцев назад

    I love all video❤❤❤❤❤❤❤❤

  • @mranupam
    @mranupam Год назад

    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 ?

    • @selfimagination
      @selfimagination  Год назад

      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.

  • @rodolfoeduardo5488
    @rodolfoeduardo5488 10 месяцев назад

    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?

    • @selfimagination
      @selfimagination  10 месяцев назад

      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.

  • @amarkantmishra
    @amarkantmishra Год назад

    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.

  • @muhdikhwan5689
    @muhdikhwan5689 8 месяцев назад +1

    Sir, do you create video how to insert all those data into database MySQL?

    • @selfimagination
      @selfimagination  8 месяцев назад

      Thanks for Watching, There is a video on this channel by the name of "How to Connect HTML to MySQL Database using PHP"

  • @apnifamily-vy8my
    @apnifamily-vy8my 11 месяцев назад

    Sir hm search Kr ke jo matching kre vo data display kr sakte h?

    • @selfimagination
      @selfimagination  11 месяцев назад

      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"

  • @dlinesoftwares
    @dlinesoftwares 11 месяцев назад

    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

    • @selfimagination
      @selfimagination  11 месяцев назад

      aapne Javascript se Getdata function ko kis tarah se call kiya hain , wah code mujhe comment kijiye

    • @selfimagination
      @selfimagination  11 месяцев назад

      You replace the return statement with the following statement
      return JSON.stringify(obj);

  • @bh-slys
    @bh-slys Год назад

    nice

  • @fenixjam
    @fenixjam 6 месяцев назад

    sir ,mujhe aapse ek code m help chahiye

    • @selfimagination
      @selfimagination  6 месяцев назад

      Thanks For Watching , आप मुझे Email (About Section मे आपको Email मिल जाएगा) कर दीजिए .

  • @NirajKumar-jg4wq
    @NirajKumar-jg4wq Год назад

    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

    • @selfimagination
      @selfimagination  Год назад

      Bilkul ho sakta hain,
      Aapki jo bhi Requirement hain mujhe Detail mujhe mail kar dijiye.

    • @NirajKumar-jg4wq
      @NirajKumar-jg4wq Год назад

      @@selfimagination thanks

    • @NirajKumar-jg4wq
      @NirajKumar-jg4wq Год назад

      @@selfimagination Maine apko sheet share kiya hai apke is email id pr

    • @ripplerayinc862
      @ripplerayinc862 Год назад

      @@selfimagination please share your email id i have some requirements from you sir

    • @selfimagination
      @selfimagination  Год назад +1

      I have replied to the mail sent by you.