Automation task with Appscript on effective user

[Werni]

Hello 

does anybody nows if an Appscript linked as a task in the automation can be executed not with the AppOwner ID but with the ID of the user effectively using the App?

Thanks

Werner

[Aurelien · Accepted solution]

Hi @Werni 

You can't.

ON the documentation it is said this way:

Call Apps Script from an automation - AppSheet Help

However, if you need to keep track of the user calling the script, you may enter the USEREMAIL() expression in a parameter of the function called, and use it to store this value somewhere.

For reference:

USEREMAIL() - AppSheet Help

[Werni]

Thanks Aurelien. I will develop via a local file the automation actions in the GDrive of the user. Would be an interesting feature request.

Werner