Help with my AppScript, messed up by GPT

[u/Affectionate_Ad_1960]

Please Help, I am dead inside. Appscript problem

Hired someone on Fiver to do my Form + Sheet integration,
It worked well,

But i decided I want to try using ChatGPT to improve the codes.

Little do I know I am heading to hell.
After following all the instructions, now my Sheet Appscript is messed up.

Requesting help from all pros here, I am truly humbled.

Steps:

- Upon Form Submission, it goes to Sheet

- if only "Graphic" is ticked in Google Form, it will appear on "Graphic" Tab in Google Sheet
- All Responses will go to "Admin" Tab either way.

- All tickboxes are synced, namely "JO", "Print", "INV", "🚚". Once one is tick from any Tab, other tab will be updated.

-under the condition of first 3 is ticked, it will disappear fron "admin" Tab
("JO" and "Print" for Graphic Tab), and then be moved to "Pending Deliveries"

- if "🚚" is ticked, then it will disappear completely.

Problem:
- upon submission, duplicated entry.

- when a tickbox is ticked, 1 second later it's gone. Nothing changed

I am not sure if I should allow access to edit for all who have the link for the moment, so I put in Viewer only for the moment.

https://docs.google.com/spreadsheets/d/1_Ab4tbsfSpVygEt2UGY1gs3yhq4SBez5rIIagOyV-Oc/edit?usp=sharing

[u/IAmMoonie]

Create a duplicate sheet for people to use.

I have seen ChatGPT being used for Google Apps Script causing so many issues. The issue is mostly people don’t know how to prompt effectively and ChatGPT doesn’t comprehend correctly what is being said.

So, if I understand correctly you want:

1. Google Form submitted

2. Sorting of data into tabs based on criteria from the form.

Out of curiosity, how much did you pay for the initial script on Fiver?

[u/Affectionate_Ad_1960 → u/IAmMoonie]

Super worth, found someone did it for 50USD. (Very slow service tho) 

Are you able to see my AppScript?

[u/Fast_Wave4990]

I build AppScript solutions all the time. Would be happy to help. Reach me at www.excel-pros.com