I followed the instructions for how to call functions in appscript, but I can't find the sheet script that the appsheet is linked to... How do I do it?
@manueurofax wrote:
the sheet script
From an AppSheet app, you can't call a bound script. Only a standalone script project.
From a standalone app script can it be called from sheet appscript functions?
I assume there's a way to do that. Probably you need to load the standalone project to the bound script as a library.
I understand this limitation of not being able to call script that is bound.. but why does the limitation exist?
Isn't the premise of AppSheet to create an app based around a google sheet? If so, why wouldn't you automatically be able to run the code associated with that same sheet?
As it stands, I will have to de-couple my code from my sheet, refactor it to get the data via the sheets API (I guess) and in general have to put it a bunch of effort to work around this "feature". What gives? Why is it setup like this?
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |