Automation, call sheet appscript

[manueurofax]

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?

[dbaum]

---

@manueurofax wrote:

the sheet script

---

From an AppSheet app, you can't call a bound script. Only a standalone script project.

[manueurofax]

From a standalone app script can it be called from sheet appscript functions?

[dbaum]

I assume there's a way to do that. Probably you need to load the standalone project to the bound script as a library.

[spotlightcanada]

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?

[dbaum]

Feature Ideas - Google Cloud Community