Fix and Enhance my Google Sheets App Script
Budget: $10 – $30 USD
I have a few issues with this script below:
1. The last trigger is causing the following error message: "Exception: This script has too many triggers. Triggers must be deleted from the script before more can be added.
setupTrigger @ Code.gs:160"
2. I have multiple things happening with the script. The first is a copy function, the second is a minor update date function, and the third and most important is a function that looks at sheet B and compares row A in sheet A and B, if the value is contained in sheet B but not Sheet A then it looks at column H in sheet B and if column H is "Not Active Yet" or "Recurring" then it will append that value in sheet A on the last field thats empty.
The issue is the script is too complex and only the not active yet is working properly. the recurring is not working at all. The person who developed this part of the script added all kinds of minute updates and its just too complex. I would like to get on a quick call to fix this the right way. ONLY message me if you will get on a call and share screen with me.
1. The last trigger is causing the following error message: "Exception: This script has too many triggers. Triggers must be deleted from the script before more can be added.
setupTrigger @ Code.gs:160"
2. I have multiple things happening with the script. The first is a copy function, the second is a minor update date function, and the third and most important is a function that looks at sheet B and compares row A in sheet A and B, if the value is contained in sheet B but not Sheet A then it looks at column H in sheet B and if column H is "Not Active Yet" or "Recurring" then it will append that value in sheet A on the last field thats empty.
The issue is the script is too complex and only the not active yet is working properly. the recurring is not working at all. The person who developed this part of the script added all kinds of minute updates and its just too complex. I would like to get on a quick call to fix this the right way. ONLY message me if you will get on a call and share screen with me.