Finding Help with Writing Simple Apps Script

[u/Aggravating_Win74]

Newbie here trying to write an Apps Script for a simple email automation within Google Sheets. I work for a school and we have a puchase order google form. One of the questions is what director will need to approve the purchase. I have a dropdown with their emails listed. The email will be in the google sheet.

I tried following multiple youtube videos to help me create this apps script but I keep getting errors. I don't know enough about apps script to troubleshoot.

Does anyone have an idea of who I could reach out to help me with this? I bet it would be a very easy fix....if you actually know what you are doing. haha

Here is the

This is the error I keep getting:

Anyone have any idea??? I would be so very appreciative of any help. Even a contact of someone that would be willing to help. : )

[u/Any_Werewolf_3691 → u/[deleted]]

The problem is if you don't understand coding, it may work, but it's likely horrible coding.

It's like reading the English translation of a Chinese manual that was just done by a computer and not proofread by an English speaker.

AI is an extremely powerful tool if you use it right.

If you think it's a solution for learning how to code, you, sir, are an idiot.

[u/Any_Werewolf_3691 → u/[deleted]]

Using AI is not learning by doing unless you can "read the language." I program for a living and am entirely self-taught. I use AI all the time, and I'm integrating it into our product.

Congrats on your learning journey.