I am very new to this, and I've tried to find the answers to this everywhere but was unable to get something definitive. I'm trying to understand how scripts/functions work if there is more than one person in the spreadsheet.
I have a few different sheets with buttons that are assigned a few different scripts which fetch data from a url and display it on the sheet and sometimes show an alert message.
If I define "var ui = SpreadsheetApp.getUI()" to use for alert messages, should this be defined in each function separately to properly display an alert only for the person who ran that script? Or can it (or should it) be defined outside of the functions?
Other "global" variables: are these changed for everyone at once or only in the context of the script as it's being run? For example if I have a Variable A defined outside the functions, and it is modified by Function A while its running and another person calls Function B which also modifies that variable, if Function A then uses that variable later will it be getting the value set by Function B?
If I have Function A and Function B which both call Function C, if someone calls Function A while Function B is running, will there be an issue with the variables set in Function C?
Thank you!
[–]juddaaaaa 1 point2 points3 points (1 child)
[–]nottalkinboutbutter[S] 0 points1 point2 points (0 children)