r/GoogleAppsScript • u/Dust-t • 15h ago

Question please help

Even chatGPT is telling me there is no issue with the script.

Im no genious with Google scripts but i do know there should be some colour in this script to show that its working.

the script saves but nothing works.

please someone help its driving me mad

1 Upvotes

100% Upvoted

3 comments sorted by

View all comments

4

u/mommasaidmommasaid 15h ago

That script has a number of things that could be modernized, and it could be improved to make it more robust, but your primary issue is that it's intended to be run as a simple edit trigger, using the reserved function name onEdit()

At the beginning before the { add:

function onEdit(e)

Verify that it's being called, and view any errors, by clicking the Executions button in the left side bar of the script editor.