How to run Multiple onEdit Functions from a single function

https://docs.google.com/spreadsheets...it?usp=sharing



I am unsure of performance impact but it seems fine for now.

Any ideas to improve this would be greatly appreciated.

This single function call has over 30 onEdit changes using different cells

show and hide rows

checkbox to set back ground color

single check box to check multiple checkbox values

This is a code snippet if anyone has any ideas to improve this please let me know

Please Login or Register  to view this content.

if each onEdit function is for separate tasks, it may be viable to ake separate functions for them, and list them all within a single onEdit, like this:
function onEdit(e) {
function1()
function2()
function3()
}

However it may also be suitable to set if clauses that would have effect depending on the edit made, like this:

function onEdit(e){
if (this=== something){
//do this
} else if (this=== something else){
// do this instead
}
}

and then it is also possible to call each operation regardless, like this:

function onEdit(e){
//do this
//do this too
}

So you can see that it depends on the need and there may not be just 1 method as it depends what you are really trying to achieve as an overall.

I wont be copy pasting your code into a file of my own so that i can give free script analysis. Instead, you can go here and create a sample file in which we can check the working code on a working sample data set:
https://docs.google.com/forms/d/e/1F...VbWiA/viewform