hi friends,
I have created an App Script for fetching values from another sheet. For bot automation purpose i need to select script file as shown in below image. but I could not find any such file in google drive. I am sure both app sheet email id and app script email Id are same.
appscript screenshot :
Note : I don’t pass any column values to the script. script runs in background to fetch values.
If anyone have idea let me know please.
Have you created the appscript from within the google sheet. If so then try creating Standalone Appscript project.
Investigate where you have saved it. You can have it in any Drive directory. (I assume you have created it in the account you use AppSheet with.)
[quote=“jyothis_m”]
No bro, whatsaid was the issue. Now it has got solved.
[/quote][quote=“JSO”]
Investigate where you have saved it. You can have it in any Drive directory. (I assume you have created it in the account you use AppSheet with.)
[/quote]
Thanks for the support.
Indeed, at this time you cannot execute functions contained in a Spreadsheet script from AppSheet, it has to be in a separate file of type Script.
(I took it for granted)
