Видео

Thank you very much!!

Hi! I need help if this is possible, I'm trying to create a pdf from sheet but i want to put an if statement based on a specific column,. like if the specific column Z has no Success/Blank then create a PDF.

Thank you for the clarification.. Question: I want to retrieve and retrieve Google table data on an HTML page that contains complete data while showing the real image and includes a search box. Thanks.

Thank you :)

I've never used getDataRange, so exuse this question if it's common knowledge; does "getDataRange" also get formatting information from each cell? If I use a method to get the rich text values from the data range, will it "work"? Is that some of that data that's gathered?

Thank you so much for this tutorial this is exactly what I was looking for! Thanks again!

I appreciate the straightforward demonstration. Thank you.

too blurry

Hi there, just came accross your excellent tutorial and I straigth went for it. But everything looks different here ... is it because of I am using the latest version of the google script application ? maybe do you have any Idea it would help me a lot thank you very much

how to keep the save sheet with the photos with out saving the link

This was so helpful, thank you! The UI is a little different now in 2023, but I was able to get the idea.

I want to sum a row (all cells to the right) but leave it open ended like you did with the column; how? Thank you!

Very helpful!

How copy text to clipboard with sidebar?

thank you this helpED me figure something out that I couldn't figure out.

Why does mine equal 0?

THANK YOU!

I'm trying to sum a row but skiping over a row . like the sum of B2:B5:B6

Thanks for the help!

I am working with this script and have it doing what I need it to do. My only problem is that I only want to rewrite the data in column [6] instead of rewriting the entire sheet.

Thanks!! Needed that bit right at 1:45 as well!

Thanks for the video! Great step-by-step guide to do exactly what I want

So much thank you bro for this tutorial... !!! This tutorial helped me a lot. Thanks a lot for making this tutorial.

Alright here's a doozy that's stumped me up for a while: Is there a way to place data submitted through a Form (to attached Spreadsheet) into a sidebar that was created/called by another, separate extension (and thus we have no access to the box id tags)? Long story: trying to low-key bypass the permissions restriction for our Chromebook reporting system (gopher buddy). We only have a handful of people in my district with Google Admin permission high enough to run those reports and, surprise, the queue gets backed up. If I could skirt the permissions by running an "on submit" trigger created/authorized by someone who _does_ have access, then any ol' employee could pop data into the form and get their report in seconds, rather than waiting however long for a manual request. We might have to set up a permanent device to stay on just to trigger the report But, the Gopher extension pulls up its own sidebar for entering device/user data, and I haven't found a way to write to pre-made sidebars yet T_T Stack exchange and I did a loooot of good this last year, but I'm stuck on this one.

thanks ! it is very helpful!

Source code please

This really helped me get a basic library going, thanks so much!

Awesome video, All problems are solved.

This is awesome; thank you very much for this tutorial. I use a lot of power pivot in MS excel and this is just as good. Thank you! new sub!

is it possible to use postgresql instead of mysql?

Cool - and lots quicker than many other videos (that's why I chose yours to watch)! Thanks much.

I think the Google Drive part doesn't work anymore, but the Google Photos part does. Very well explained, in the end uploading photos to Google Photos or to Google Drive is basiacally the same thing

Thank you for the short and clear explanation! I ran into a slight issue: when I add a $ sign in front of the number, the formula doesn't calculate the total, not sure if there's a setting I have to edit.

Awesome video. You covered all the basic scenarios to get started with app script sidebars. Well planned out and informative.

Please help, when I do this in google sheet the number become 0. The row I want to collect is by _

Yes thank you so much needed this for a long time now

Do not be shy to zoom your code

Please help me . The formula u use on the total up ..tnx

Please help me..im in trouble . Wats the formula for the thing u used on the top to show the sum up the total all..

Hı how find is code?

Great videos . Thanks for explaining. These really help me.

ESTO ESTABA BUSCANDO! GRACIAS!!

Nice Tutorial but what if i have 100 Rows for Example and 100 Colums and i wanna have =SUM(D7:R7) and =SUM(D8:R8) and =SUM(D9:R9) and so on. Is there a way to replace the Numbers by a Variable like: =SUM(D$CurrentRow:R$CurrentRow) to make it more reusable?

Hi, Thank you for this video. I want to ask you that i want to create a if statement with 2 conditions. 1 is onedit(e) and the other one is a given cell value is not empty. If the above statements are true then trigger my "send mail" function. Kindly let me know if this is this posible. Thanks

You need to zoom in.

so you showed how you could leave it open ended so that if the sales team adds more rows, the top cell keeps adding to the total by doing sum (a2:a). how could you do the same thing by having a cell on the extreme left that does the same thing for a row, so that if the sales team adds more columns, it could be open ended? your current formula has the sum for rows on the right, so it's assuming a fixed number of columns.

Hey, this video is awesome. Can you help me modify this to show a an image in the sidebar? So far I have a column (E) that contains links to photos (already formatted as <img src="[insertlink]"/>). I can get the image to open up the sidebar, but I have to click a new cell, then run the side bar each time for it to populate the new image in the sidebar. In other words, I have to run the sidebar function individually for each cell in order to get an image. Is there an easier way??

Wow

How to do viceversa? Like enter data inside googlesheet and it db gets updated

thank you!