0

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

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

6th Sep 2020, 10:11 AM
ASHRAFUL HAQUE
ASHRAFUL HAQUE - avatar
2 ответов
0
You can directly use Google Forms to create No use of app script It's simple
20th Sep 2020, 10:22 AM
Mayank Gupta
Mayank Gupta - avatar
0
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.
20th Sep 2020, 10:27 AM
ASHRAFUL HAQUE
ASHRAFUL HAQUE - avatar