Display Google Sheets Data on Interactive HTML Tables (Quick & Easy Setup)

Поделиться
HTML-код
  • Опубликовано: 21 окт 2024

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

  • @DLHK2024
    @DLHK2024 19 дней назад +1

    wow, the video is very good, short and easy to understand, special thanks to you

  • @THDYoung
    @THDYoung 6 месяцев назад +1

    Thank you.
    Question!
    If you paste the url of a web app like the one in this video into a Google Site (using 'embed'), then update the data in the spreadsheet associated with the web app, will the Google Site view update automatically or only with a manual page reload?

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

      Manual page reload.

  • @ArshadRaza-c7h
    @ArshadRaza-c7h Месяц назад +1

    Hi there, very nice video. please add print option in it so that it can be more usefull for people like us who are not good with coding. thanks

  • @jadoublez1
    @jadoublez1 15 дней назад

    Hello. This is amazing and thank you. I have several columns of numbers. When I click on column F, the column sorts high to low or low to high. Perfect. When I click column G (replicated from column F exactly in the Javascript), the column seems to sort randomly. My guess is it's feeding off something but i'm not sure why it wouldn't sort the same as Column F. Any reason spring to mind?

  • @zaccoza
    @zaccoza 2 месяца назад

    I am grateful for sharing your work. I adapted the project according to my own request. Column 3 entries in the data field have url links. What should I do to make the data come with url links in the web table?

  • @markdaniel-i1q
    @markdaniel-i1q 6 месяцев назад +1

    Can we customize the sheet as per our requirements?

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

      Yes.

  • @SOUVIKKUMAR-vj6wm
    @SOUVIKKUMAR-vj6wm 5 месяцев назад +1

    Sir, if i create hyperlink or want to show any weblink from Google, it is not showing or acting like fix value, how to do.
    Please help

  • @etayojuanc
    @etayojuanc 2 месяца назад

    Friend, do you have any crud data table type applications where the apps script is outside the spreadsheet?

  • @ImamFauzi-vj8xp
    @ImamFauzi-vj8xp Месяц назад

    Thanks for the tutorial, really helpful!

  • @sumithamarasinghe4196
    @sumithamarasinghe4196 Месяц назад +1

    good job sir 👍

  • @SkhemTechNongshli
    @SkhemTechNongshli 3 месяца назад +1

    Kindly make application that a user login and entry information, and also display only his input or information.

  • @SOUVIKKUMAR-vj6wm
    @SOUVIKKUMAR-vj6wm 5 месяцев назад

    Sir if i want to show any hyperlink or weblink which is in Google sheet, what changes have to do?
    Because hyperlink or weblink is not working in html table, it shows fix value.
    Please help

    • @bpwebs
      @bpwebs  5 месяцев назад

      Add formatter:"link" to the relevent column in the createTable function of the JavaScript.html file.
      E.g. {title:"Type",field:"Type",headerFilter:true, formatter:"link"},

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

    Mine does not display all the info for example i changed the headers to this: Part Description, Quantity, Location , Condition, Serial Number , Compatibility , Information, Comments , Date/Time ... and only quantity, information and date/time have their data populated in the app, what am i doing wrong ?
    columns:[
    {title:"Part Description", field:"Part Description"},
    {title:"Quantity", field:"Quantity"},
    {title:"Location", field:"Location"},
    {title:"Condition", field:"Condition"},
    {title:"Serial Number", field:"Serial Number"},
    {title:"Compatibility", field:"Compatibility"},
    {title:"Information", field:"Information"},
    {title:"Comments", field:"Comments"},
    {title:"Date/Time", field:"Date/Time"},
    ],

  • @perrysantos
    @perrysantos 2 месяца назад

    excellent!!! thanks for this!

  • @aa_konovalov
    @aa_konovalov 6 месяцев назад +1

    🔥🔥

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

    Why the body of HTML didn't show up?

  • @NdegwaGithigi
    @NdegwaGithigi 6 месяцев назад +1

    Nice,

  • @markdaniel-i1q
    @markdaniel-i1q 6 месяцев назад +1

    ❤❤❤

  • @SouravTalukdar-oz6os
    @SouravTalukdar-oz6os 5 месяцев назад

    Why Sheet Data Not Showing??

  • @MohammedAli-qq3zu
    @MohammedAli-qq3zu Месяц назад

    REALY THANKS THANKS THANKS

  • @airdrop4ufree
    @airdrop4ufree 5 месяцев назад

    Hi can make step by tutorial

  • @SOUVIKKUMAR-vj6wm
    @SOUVIKKUMAR-vj6wm 5 месяцев назад

    Sir if i want to show any hyperlink or weblink which is in Google sheet, what changes have to do?
    Because hyperlink or weblink is not working in html table, it shows fix value.
    Please help

    • @bpwebs
      @bpwebs  5 месяцев назад

      Add formatter:"link" to the relevent column in the createTable function of the JavaScript.html file.
      E.g. {title:"Type",field:"Type",headerFilter:true, formatter:"link"},