I kindly request a video tutorial demonstrating the use of Document AI for extracting insights from documents, statements, that might be followed by data visualization in Looker Studio and integration with spreadsheets.
3 days ago I was talking to a friend of mine about this channel's owner and had told him that he is one of the best spreadsheets teacher on the digital. Now I really am glad to see he's back after a long time. Welcome back!
I see I'm not the only one happy to see you back. Please keep it up, don't abandon the channel for so long. I learned JavaScript thanks to this channel and already write my own applications in nodejs, svelte, tailwind and use GAS as backend in them. With pleasure and deep sense of gratitude, your subscriber from Russia.
Same... Your channel has helped me in automating my administrative activity, it had created more than 1mio covid letter pdfs during the pandemic before being taken over by the product team
I've been wondering for the past few days, if you'd be back to cover this latest addition to GSheets ... Thank you, Thank you Thank you...Glad you're back.
Teacher...Long Time No See! This Video I believe will Solve a Huge Problem with my Little Ongoing Project I have been Stuck On for Some Time!! Thanks...your The Best!!!
I saw the release of tables in Sheets and just hadn't gotten around to grokking it yet. You've done it for me, and in a very easy to understand way. Thank you! (OMG I have so much work to re-do now...)
I am Glad to see you back sirji. You spreadsheet tutorial are the best tutorial I have ever seen. Also I get a lot of respect because of you at my workplace. You are doing a great job keep doing it Sirji.
Oh wow I havent seen one of these thumbnails show up in my feed in a long time. I first subscribed 5+ years ago when working on some random side project in high school, and then stumbled across ur import HTML/XML parsing videos and thought it was some crazy magic I was populating my spreadsheets with... and now I'm a web developer. Thank you xD
Welcome back. I hope you are doing well. You are my favourite content creator and I have made so many useful things based off of your lessons. If life takes you away from the channel we will all understand, but for now I am so happy to see you back.
Hi. Any idea if it is possible to populate a table with data using appscript ? Seems to be defined as a "banding" Create a banding : spreadsheet.getRange('D7:E7').activate(); var banding = spreadsheet.getRange('D7:E7').getBandings()[0]; banding.setRange(spreadsheet.getRange('D7:E700')) .setHeaderRowColor('#356854') .setFirstRowColor('#ffffff') .setSecondRowColor('#f8f9fa') .setFooterRowColor(null); Of couse an excellent video (as always) will be appreciated 🙂
TH-cam removed the video for violating their terms of service. They said it was removed for posting offensive content, bullying. I've tried to appeal, but everything is automated these days, so it was rejected and their customer service is AI bots too and it said they stand behind their decision. Can you believe it? :) It was a one hour video, it took over a week to make it. Anyways, I don't think I'll be posting one again, sorry.
Do you have a question. Let's say make a table. For the data and column one, I want to pull in data from another sheet. Something like a form response. So every time I get a new form response, the array formula will pull the data in to the table. Will that expand the table as well? And if I delete data from the table, will it automatically shrink the table range? For example, if I'm pulling in data from another sheet using an array formula, if I delete one of the rows from the data range, then the listing column one of the table will decrease. Will that affect the table range itself?
@@ExcelGoogleSheets gotcha. I appreciate the reply. What about pulling in data within the ray formula? Do you think that might work? It would at least be one problem solved.
I don't think array formula will grow or shrink the table. The purpose of the table is for formulas to react to table growth, not the other way around.
@@ExcelGoogleSheets Of course you can use the getRange() method. But let's say you know the name of the table but not it's location. It would be nice to have a method getTableByName(). In Excel VBA we can do: set oTable = ActiveSheet.ListObjects("TableName"). Do you know if there is something similar in Google Sheets?
@@ExcelGoogleSheets Of course I can use the getRange() method. But what if I don't know the location of the table? In Excel VBA I can access the table using it's name with ActiveSheet.ListObjects.Item("tableName"). Do you you if something similar exist in Google Sheets?
I think Named Range just replaces usual format like B2:G17 with a "name" Table instead leverages on the column name reference and other features shown in the video
useless feature they picked up from excel... I think Google just has to focus on their innovation more and never look back at that old and stupid Excel.... Everybody loves GSheets because it's better than Excel. And now they want to be like Excel?! really?! 😅
I find your logic very odd. The entire Google Sheets project is a copy of Excel to begin with. How are you upset that they copy Excel features all of the sudden? What innovation has Google Sheets made? I haven't seen anything innovative in Google Sheets since I've been making videos about it for 7-8 year now.
@@sergheyzaporojanu6872 As far as I'm concerned, none of that was improved in any way within the last 7-8 years. They couldn't even improve QUERY to support basic SQL like join statements. Don't get me wrong, it's not like I dislike Google Sheets, but at this point it has fallen behind. The only good things that were added in Google Sheets within the last 8 years were all thanks to Excel, like LAMBDA, named functions, REDUCE, MAP, BYROW, TOCOL, WARPCOL etc.
@@sergheyzaporojanu6872 As far as I'm concerned, none of that was improved in any way within the last 7-8 years. They couldn't even improve QUERY to support basic SQL like join statements. Don't get me wrong, it's not like I dislike Google Sheets, but at this point it has fallen behind. The only good things that were added in Google Sheets within the last 8 years were all thanks to Excel, like LAMBDA, named functions, REDUCE, MAP, BYROW, TOCOL, WARPCOL etc.
You are back, I was thinking about you from time to time, especially when I use my Googlesheet. I was thinking you must have moved on to AI stuff already. :) so glad that you are back.
Thanks for this very good video and welcome back ! Take care when using array formula inside a table. If you sort the table by a column, the results may be strange or wrong.
![[TH] FS vs BME - VCT Ascension Pacific - Lower Bracket Final](http://i.ytimg.com/vi/wnygqsR2Fig/mqdefault.jpg)
Thanks everybody!
Nice to see you again
I kindly request a video tutorial demonstrating the use of Document AI for extracting insights from documents, statements, that might be followed by data visualization in Looker Studio and integration with spreadsheets.
3 days ago I was talking to a friend of mine about this channel's owner and had told him that he is one of the best spreadsheets teacher on the digital. Now I really am glad to see he's back after a long time.
Welcome back!
I see I'm not the only one happy to see you back. Please keep it up, don't abandon the channel for so long. I learned JavaScript thanks to this channel and already write my own applications in nodejs, svelte, tailwind and use GAS as backend in them. With pleasure and deep sense of gratitude, your subscriber from Russia.
Same!
Thanks! I was really busy with my business, which is a good thing. TH-cam is a good hobby, but it doesn't make a living for me.
Same... Your channel has helped me in automating my administrative activity, it had created more than 1mio covid letter pdfs during the pandemic before being taken over by the product team
Welcome Back
We miss you and miss your beautiful lessons
Welcome back here! I hope there will be new videos regularly, this is clearly the best Google sheet TH-cam channel.
I've been wondering for the past few days, if you'd be back to cover this latest addition to GSheets ... Thank you, Thank you Thank you...Glad you're back.
I have learnt so many spreadsheet things through your Tutorials. Thank you!
Thank you very much for yet another informative post. Is there any way to format currency or date or even amounts in a particular format
Yes. Just select the column and use custom number format as you usually do when it's not a table.
Welcome back
I was just on Reddit last night talking about tables and here you are. Your tutorials are awesome. Thank you!
Teacher...Long Time No See! This Video I believe will Solve a Huge Problem with my Little Ongoing Project I have been Stuck On for Some Time!! Thanks...your The Best!!!
Welcome back! Glad to see your perspective on Tables!
I saw the release of tables in Sheets and just hadn't gotten around to grokking it yet. You've done it for me, and in a very easy to understand way. Thank you!
(OMG I have so much work to re-do now...)
Welcome back good to see you 😊
Great to see that you are back. Your videos are always excellent.
This is the best channel of Google Sheets ever
Welcome back.. It's been 1 year...
I waited for you every day, my google spreadsheet teacher!
Welcome back dude.
Thank you for the video king! Learned so many things from you!
Thank you sir. I had gained a lot from your videos.
Happy to see you back 😊
Yeees! Learnt so much from your videos.
Thanks for your efforts.
I am Glad to see you back sirji.
You spreadsheet tutorial are the best tutorial I have ever seen.
Also I get a lot of respect because of you at my workplace.
You are doing a great job keep doing it Sirji.
Sidd...you are so fortunate to know Sirji personally! He is an Incredible Teacher!! Be an Honor to Talk to him in person!!!
Thanks a ton
Oh wow I havent seen one of these thumbnails show up in my feed in a long time. I first subscribed 5+ years ago when working on some random side project in high school, and then stumbled across ur import HTML/XML parsing videos and thought it was some crazy magic I was populating my spreadsheets with... and now I'm a web developer. Thank you xD
I'm starting to despise web development lately 😀 Every month there is a new way of doing the same thing.
Salam o Aaalikom, it's nice to see you again with your great videos, we miss you a lot :)
😊 thanks!
Welcome back 🥳
Thank You!
Welcome back!
Great great to see a new video!!🎉
the king is back!!
Welcome back. I hope you are doing well. You are my favourite content creator and I have made so many useful things based off of your lessons. If life takes you away from the channel we will all understand, but for now I am so happy to see you back.
I am happy that you are back, I hope you are well
Love you sir.I learnt google sheet basics from you.Happy that you are back. From India
Welcome sir
Welcome back ❤🎉
Welcome back buddy!
Welcome back! Thank you very much for the new video
Welcome Back Sir! Thanks for making this valuable content.
Lot's of love from 🇮🇳
👍
Thank you and welcome back! Do you know if we can reference the table using gas as we can for namedranges?
My mannn
The King is back!
Welcome back
Thank you sir. I've learned so much from your video.
You are amazing.
More video pls..s
So happy to hear your voice again 🙏.
😊 thank you
Welcome back! We love you! :)
First. Long time sir.
Welcome Back!!
Does the table content has always be static? Can the content be a result set from a formula, eg. FILTER, UNIQUE etc.? thanks
No.
Top stuff!
Thank u google sheet MASTER ❤
Where can I find all your google sheets practice files for all your videos here on your TH-cam Channel?
Thanks!
Thank You!
Hi. Any idea if it is possible to populate a table with data using appscript ?
Seems to be defined as a "banding"
Create a banding :
spreadsheet.getRange('D7:E7').activate();
var banding = spreadsheet.getRange('D7:E7').getBandings()[0];
banding.setRange(spreadsheet.getRange('D7:E700'))
.setHeaderRowColor('#356854')
.setFirstRowColor('#ffffff')
.setSecondRowColor('#f8f9fa')
.setFooterRowColor(null);
Of couse an excellent video (as always) will be appreciated 🙂
How would tables work with imported data or query formulas that are always changing ranges?
Depends...
Could you please make a video on the sql in sheets video again because the old one is not working anymore
TH-cam removed the video for violating their terms of service. They said it was removed for posting offensive content, bullying. I've tried to appeal, but everything is automated these days, so it was rejected and their customer service is AI bots too and it said they stand behind their decision. Can you believe it? :) It was a one hour video, it took over a week to make it. Anyways, I don't think I'll be posting one again, sorry.
Do you have a question. Let's say make a table. For the data and column one, I want to pull in data from another sheet. Something like a form response. So every time I get a new form response, the array formula will pull the data in to the table. Will that expand the table as well? And if I delete data from the table, will it automatically shrink the table range? For example, if I'm pulling in data from another sheet using an array formula, if I delete one of the rows from the data range, then the listing column one of the table will decrease. Will that affect the table range itself?
No, I don't believe formula updates will grow or shrink your tables, at least not at the moment.
@@ExcelGoogleSheets gotcha. I appreciate the reply. What about pulling in data within the ray formula? Do you think that might work? It would at least be one problem solved.
I don't think array formula will grow or shrink the table. The purpose of the table is for formulas to react to table growth, not the other way around.
Hello. Thanks for the video. Now is there a way to retrieve the data using the table name with App Script ?
Doesn't just the usual getRange() method work?
@@ExcelGoogleSheets Of course you can use the getRange() method. But let's say you know the name of the table but not it's location. It would be nice to have a method getTableByName(). In Excel VBA we can do: set oTable = ActiveSheet.ListObjects("TableName"). Do you know if there is something similar in Google Sheets?
@@ExcelGoogleSheets Of course I can use the getRange() method. But what if I don't know the location of the table? In Excel VBA I can access the table using it's name with ActiveSheet.ListObjects.Item("tableName"). Do you you if something similar exist in Google Sheets?
what about another spreadsheet?
How is a Table different from a Named Range?
I think Named Range just replaces usual format like B2:G17 with a "name"
Table instead leverages on the column name reference and other features shown in the video
What he said ^^
useless feature they picked up from excel... I think Google just has to focus on their innovation more and never look back at that old and stupid Excel.... Everybody loves GSheets because it's better than Excel. And now they want to be like Excel?! really?! 😅
I find your logic very odd. The entire Google Sheets project is a copy of Excel to begin with. How are you upset that they copy Excel features all of the sudden? What innovation has Google Sheets made? I haven't seen anything innovative in Google Sheets since I've been making videos about it for 7-8 year now.
@@ExcelGoogleSheets IMPORTRANGE to begin with. UI, appscript on JavaScript, Query etc...
@@sergheyzaporojanu6872 As far as I'm concerned, none of that was improved in any way within the last 7-8 years. They couldn't even improve QUERY to support basic SQL like join statements.
Don't get me wrong, it's not like I dislike Google Sheets, but at this point it has fallen behind. The only good things that were added in Google Sheets within the last 8 years were all thanks to Excel, like LAMBDA, named functions, REDUCE, MAP, BYROW, TOCOL, WARPCOL etc.
@@sergheyzaporojanu6872 As far as I'm concerned, none of that was improved in any way within the last 7-8 years. They couldn't even improve QUERY to support basic SQL like join statements.
Don't get me wrong, it's not like I dislike Google Sheets, but at this point it has fallen behind. The only good things that were added in Google Sheets within the last 8 years were all thanks to Excel, like LAMBDA, named functions, REDUCE, MAP, BYROW, TOCOL, WARPCOL etc.
hope google give new method to access table's data from app script, like "getTableList() / getTableByName()" then give object value
Wouldn't just getRange work?
You are back, I was thinking about you from time to time, especially when I use my Googlesheet. I was thinking you must have moved on to AI stuff already. :) so glad that you are back.
Welcome back ❤
Welcome back
Hi bro, long time no see.
Welcome back
Waiting for so long from you Sir, finally you are back with awesome videos on Google Sheets
Great that you are back with awesome explanations.
you have been missed
He is back!!!
This is very useful!
wow you are back now
So glad you're back ! We missed you ! Great and helpful video as usual.
welcome back my brother nice to see you again
Thank you so much for coming back, teacher! You are amazing!!!
I was worried you had quit. So thankful for all you have taught me in excel/google. Welcome back!
Welcome back ❤
Welcome back ❤
YOU ARE BACK? 🙏
Excellent video as always
thank you for great video.
I would like to ask if we can deal with tables from Google Apps Script?
Can i set a default view? for a table ...group by one of the columns, I want everyone to see it with this view
Cool! I hadn't realized they added Tables! Thanks for the video.
Welcome back! And again a great tutorial on Google sheets Table!
I can't wait to see how tables can work with JavaScript
Good to see you back! I did not find a feature to unconvert a table. I think they forgot to add it?
Yea, the worst part is when you delete the table it deletes the entire thing 🤣
You'll have to copy/paste as values only someplace else.
@@ExcelGoogleSheets I almost fell from my chair when I found out! 😂🤣😂🤣
@@ExcelGoogleSheets I love that the new lines added to tables seen to retain the column formatting much better!
Welcome back ❤🎉
Welcome back ❤
Welcome back.
Thanks for this very good video and welcome back !
Take care when using array formula inside a table. If you sort the table by a column, the results may be strange or wrong.
good point!
The more I watch this video the more I am learning. And being able to implement the TABLE feature in my workload is the best part. Thank you again!