Google Apps Script Hide Row

[@StephanieGallentine-x7v]

Love, love, love the way you break it down and walk us through the script! Great pacing and great information. Thank you!!!

[@saperis]

You are welcome. Thank you for the feedback 😀

[@dewaynewest7756]

Hello. I used your share with permissions code and i love it. How can i use this function with the share with permissions function based on an email column and not check boxes? Thank you.

[@WatervilleCommunityChurch]

This is great! One question: can I use this same function to hide a row if it has a check in any one of multiple columns? What would need to be added/modified in this code to make that work? I have 19 columns, and if there is a check mark in any ONE of those 19, I want to hide the row. Thank you.

[@saperis]

You would have to change the range where you are looking for a checked column.

[@kayleightorcivia1050]

Hello! Great video. Do you think you could help with this use case? I have sheet1 that lists several products and all the ingredients contained in each product. In sheet2 I used the unique function to get a list of all ingredients. I want to be able to untick all the cells of 1 product in sheet1 and have any ingredients that aren't listed with another product to be hidden in sheet2.

[@kayleightorcivia1050]

For example, if we are discontinuing a product, I don't want to see ingredients that have been discontinued.

[@saperis]

Hm, I think you probably have to use a onEdit trigger that runs a script every time you change something in the file. You probably would need to write a script that check if the ingredients are also listed on another product and if not, not display it. I don't offer any coding services but you could hire someone to do this for you: workspacedevs.com/

[@AntonioRignanese-y6l]

How can I apply the check-box criteria on multiple sheets? I have on sheet1 a checkbox needed to move info on Sheet2 and then a checkbox on Sheet2 to move info on sheet3. How can I keep hiding rows if I check the boxes on different sheets?

[@saperis]

You would have to adapt your script. In the script you decide which data range is hidden when you check a box. Learn more about automating Sheets: developers.google.com/apps-script/reference/spreadsheet

[@gandyandriana6147]

i found an error here "Exception: The parameters (number[]) don't match the method signature for SpreadsheetApp.Sheet.hideRow." i have followed the document template as you

[@MagicMarketing-fg4zm]

Is this possible even though my data is being filtered in through query function based on a Google form fill out? My sheet doesnt seem to be filtering.

[@saperis]

Good question. I've never tried out that combination of using the QUERY function and then hiding rows. I'm assuming it won't work as this function doesn't actually add the values to the rows.

[@amirkahla5058]

Thanks a lot!

[@saperis]

You're welcome! 😀

[@mantu401]

Is it possible to send submitted google form respondent to another email using appscript. Written script it sending only responses in email body could you please help me to resolve this

[@saperis]

I just answered this question on the other video.

[@Lavil80]

Can the same script (or similar) can be done to hide a row for a table in a google doc?

[@saperis]

There is a removeRow() method for tables in Google Docs. Check the documentation to find out how to use it: developers.google.com/apps-script/reference/document/table#removerowrowindex

[@kakalkairuchi495]

Thank you for everything! 💝☺

[@saperis]

You are welcome!

[@sultanal-harby3522]

I don't know if you can help me but great video unfortunately I want to hide column not rows and not with check boxes but with values I tried to tweak based on your video but it didn't work

[@saperis]

I can confirm that what you are trying to do is possible. But I can't actually write the code for you. Check the official documentation to see the different options you have to automate Google Sheets: developers.google.com/apps-script/reference/spreadsheet

[@JenniferTheisen223]

Do I need to set up an array on my sheet first, or is it just automatically assumed?

[@saperis]

The data in Sheets, when you get it with Apps Script, is automatically of type array. Simply save it to a variable you create.

[@aldoyang688]

Thanks!

[@saperis]

Thanks for watching and your generosity. 😀

[@guntarion]

Thanks a lot! Could you next make a video on how to make a radio button functionality out of google sheet checkbox 🙏

[@saperis]

Thanks for watching. If I'm not mistaking, there aren't any radio buttons in Google Sheets.

[@guntarion]

@@saperis Exactly. Thus, the request :-) What I mean is to write a script to make a set of checboxes to behave like radio button, i.e. among all the checkbox in column C, only one is allowed to be in the checked state.

[@saperis]

@@guntarion Ok, now I understand what you mean. It's a bit of a difficult situation. How do you want to restrict the user from checking any further checkboxes? I think you can't. You could have a script working with the onEdit trigger and unchecking any boxes is one is already ticked.

[@rubenpatton4771]

🅿🆁🅾🅼🅾🆂🅼 💘

[@felipemorales9963]

Hi, I'm getting this error that says: Cannot call spreadSheetApp.getUi() from this context.

[@saperis]

Apps Script is case sensitive. So if you write spreadSheetApp.getUi() it will fail. The correct way to write this is SpreadsheetApp.getUi()