I've created a Google sheet user form using appScript. But I'm having some issue with it. Can you help me please?

Question

My user form has 3 input section. First Name(column B), Last Name(column C), and phone number(column D).
And the id(column A) is generated automatically. In my sheet cell E1 =SUM(A2:A).

I can show the E2 value in my user form. I want to show the value with red color when E2<=0.

I've solved the problem also.
But my problem is, I want to update the value every time the form loaded.

And when it will less than 0, the 'Add Customer' & 'Edit' button will be disabled.

Anyone can help me with it, please?

My code is here: https://github.com/Ashraful7679/user-form

Answer 1

You can directly use Google Forms to create
No use of app script
It's simple

Answer 2

I know the simple solution. But you can't search, edit or delete sheet data using google form.
I think you don't know about the app script.