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
2 ответов
0
You can directly use Google Forms to create
No use of app script
It's simple
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.