How to Display Google Sheets Data in a Table and Show Details on an HTML Page
ฝัง
- เผยแพร่เมื่อ 26 ก.ย. 2024
- How to Display Google Sheets Data in a Table and Show Details on an HTML Page
About Video:
In this tutorial, you will learn how to display Google Sheets data in a table on your website and how to use JavaScript to show detailed information about each item when clicked. We will show you step-by-step how to set up your Google Sheet, how to integrate it with HTML and JavaScript, and how to customize the display to fit your needs. This is a great solution for showcasing data on your website or creating an online directory.
00:00:00 Introduction
01:33:00 Step 1 : Apps Script Code
03:56:10 Step 2 : HTML Code
06:44:24 Step 3 : JavaScript Code
11:04:17 Program Flow
Read More or Source Code
selfimaginatio...
Deploying Apps Script as a Web API: A Step-by-Step Guide
selfimaginatio...
#GoogleSheets #HTML #JavaScript #DataDisplay #Table #Integration #WebDevelopment #CodingTips #Tutorial
Thanks Sandip ,as usual in very easy way u explain the concept and method .
Thank you
Thanks a lot
Most welcome
Thanks, Sandeep for detailed video of using this
Do we have any Video to host this in appscript that adds these files into appscript project instead of files on disk
Working fine for Local projects but not want to host this in Appscript
How to move all these files to appscript project and use URL to run this invoice
Welcome, You can watch this video once on this channel "Use of Google Sheet API | Google Sheet to HTML Table"
Sandip sir, Inventory management system kaise banaye? Is project ko banaye kaise?
Abhi kuch Video Planning me hain unke Complete hone ke bad Inventory par bhi banaunga.
Thank you so much sir for making this video help me a lot
But I have a question
That as we enter the product name,
can the rate be automatically displayed or fetched from google sheet?
Because I want to create an invoice in such a way that
I only need to enter the barcode of the product, and after that,
the product name, unit of measurement, and cost price should automatically appear from [my sheets "all products" database].
I can simply enter the quantity and submit it."
Welcome,
You can do exactly as you want. As soon as you select the item, the information related to the item is picked up from the item sheet and appears on the HTML.
@@selfimagination
Glad you replied 😊
would you mind making a video tutorial about it ?
In the upcoming videos, you can get help related to this topic. Thank you.
Hello, how do you do it so that the number in the table is increased, which add a file so that in the # column it goes from 1 to 2 and 3 etc.
A video has been published yesterday, in that you will get the serial number code.
Hi, Thanks for you, and hope the best for you, I have an issue after I click on the button to submit Forbidden Error 403, where is the error here ??!
Welcome, Generally 403 error comes due to lack of execution permission, whenever you deploy, you have given permission only to yourself, then you have to execute the link on use browser only, or else the permission you are giving is given to anyone.
when you select 'Show Detail Invoice,' the display is not 100% accurate because the invoice number is not updated to match the document number.
If the invoice number is unique then there should be no issue of any kind.
I agree, but your code has a bug. If you click 'Show Detail Invoice' and the invoice number doesn't match the document number, then you update the item data, the system will create a new invoice document in the database. This is not an update@@selfimagination
Yes, the solution here is that the search function is Search(pNo=""), in which the value has been set on inv_dt, before that also set the value on inv_no, so that when you update, the same invoice will be updated. that have been opened by us
Mujhe app script pura sikhna h guide kijiye
Isi channel par apps script ki play list hain, isme aapko bahut se logic mil jayenge
It's Possible? Make a Data table with search button, without G-Code Changing, Only on Java Script.
Yes, you can do this using jQuery. In that, all the data will have to be fetched once using Apps Script and then it will have to be shown by applying search or filter.
@@selfimagination Please Help Me...
I Have Done It...Thanks For your Inspiration..
Why doesn't my file drop down?
Sorry, I could not understand what you want to ask, please explain in detail.
Thank you, it's working@@selfimagination
Thanks for Watching
TypeError: Cannot read properties of undefined (reading '1') line 14 @@selfimagination
1. in index.html line no 140: remove disabled="";
2. add value attribute on qty, rate, desc.
I have changed and checked, still if there is any issue, please paste the code of addOrder.gs in code.gs.
Please remove the link of the sheet from the comment. Anyone can update the sheet from here.
Hi I am a forex trader and want to display my trade history from Google sheets and provide filters and sorts on the data. The data is sourced from export from MT4 or MT5 (ideally without exporting and just from History) The data is standard data seen on Google Sheets. Maybe we can chat? - sorry i only speak english
Thanks for Watching, Whatever is your requirement please mail me (you will get the Mail Id in about this channel).
@@selfimagination ok sent