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?
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?
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?
Hi, I followed the steps, but the table is not displaying. I am getting the msg: "ReferenceError: Sheets is not defined". Can you give me an advice what to do next?
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"}, ],
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
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"},
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
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"},
![How to create a data entry form in Google Sheets [with multiple databases]](http://i.ytimg.com/vi/qo743XZOU0M/mqdefault.jpg)
wow, the video is very good, short and easy to understand, special thanks to you
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?
Manual page reload.
Can we customize the sheet as per our requirements?
Yes.
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
How to sort and filter dates?
Thks bro.
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?
Friend, do you have any crud data table type applications where the apps script is outside the spreadsheet?
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?
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
Hi, I followed the steps, but the table is not displaying. I am getting the msg: "ReferenceError: Sheets is not defined". Can you give me an advice what to do next?
Thanks for the tutorial, really helpful!
good job sir 👍
Kindly make application that a user login and entry information, and also display only his input or information.
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"},
],
🔥🔥
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
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"},
❤❤❤
excellent!!! thanks for this!
Why the body of HTML didn't show up?
Why Sheet Data Not Showing??
Nice,
Hi can make step by tutorial
REALY THANKS THANKS THANKS
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
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"},