While switching tabs afterChange event has been calling for every row which is taking more time for the sheet getting to load. Is there any way that I can prevent calling afterChange event while switching tabs?
Faster Response
Hi @shaiksazidh
What tabs do you use? We do not offer tabs as an official plugin/functionality so it might be crucial to understand why you get so many calls.
Would it be possible for you to share an online demo with me? You can use this demo as a base https://jsfiddle.net/5dg9y32k/
I cant make a demo it’s huge.May I know how to stop calling afterChange event while load and saving a sheet?
@shaiksazidh afterChange is called with every change. You can add some statements to run the code inside your hook in some certain situation but every change triggers the hook if it wasn’t stopped by the beforeChange hook https://jsfiddle.net/bts7mkce/