Text color has change(red) perfectly when I open the app at first time. But it'll not work after running the app. Solution?

Question

https://code.sololearn.com/WR5374MAXMn8/?ref=app

Answer 1

ASHRAFUL HAQUE Wait... What? How are you using Google Sheet as the PHP page?

TBH... I'm a bit confused about whether or not you understand, much less, wrote the code implementing the Google Apps Script API or if you grabbed parts of it from somewhere else and you're trying to figure it out.

This code does look like it was pulled from some other code base written by someone who understands the Google Apps Script API. It's just unclear if you were that person based on your responses so far and the code I've reviewed.

To cut to the chase, did you write this code or grab this from some other source?

Have you ever gotten this code working? If so... what happened to the scripts for initializing the Google Apps Script API?

Answer 2

ASHRAFUL HAQUE Sorry for the late reply. It's been a busy day.

I just pulled your project and have a few comments to kick this off.

1. https://github.com/Ashraful7679/user-form/blob/master/main.html#L82

This appears to be some left over from a PHP page. You need to initialize this value in another way. It's breaking your Javascript.

2. Your references to the google object are undefined. Perhaps you're missing a library you meant to include. Without having that implemented, there's not much that's going to work.

Answer 3

ASHRAFUL HAQUE I can try to make time tomorrow to review from my machine. It's 3:41am EDT at the moment. 😉😴

Answer 4

https://docs.google.com/spreadsheets/d/1sYR_SywKL5vwPhxEWwyJm2YmEJ6e9gcHBIjj3O7d650/edit?usp=sharing

Answer 5

David Carroll this is the google sheet I'm using for the reference and as the php page.

Answer 6

I'm using this code as a script file in the google sheet.
You can find the script editor in the Tools>Script editor section.

Answer 7

Please verify your code, there are missing pieces there which prevents the code to run and be analysed.

Answer 8

Big Thanks David Carroll 🙏

Answer 9

https://github.com/Ashraful7679/user-form/

Answer 10

Please check the github url for full code

Answer 11

I have another issue with this userform.
I want to disable the add-customer-button when the initial value <=0

Answer 12

Please first tell me which file, you have 7 files there bro. Tell me where to begin?

Answer 13

Main.html

Answer 14

https://docs.google.com/spreadsheets/d/1sYR_SywKL5vwPhxEWwyJm2YmEJ6e9gcHBIjj3O7d650/edit?usp=sharing

Answer 15

This is the google sheet you can input data using the code

Answer 16

I'm not sure, but looking at your main.html, I think you need to verify variable <initVal> value is evaluable as number when it is checked at line 83.

That is the part that changes colours right bro?

Answer 17

Let me give you the access to edit the code and check if it is okay or not.

Answer 18

https://script.google.com/d/122OwA8p_hGeJYkkB4rG9Y__43AUkACffT6W_fhk26Hm8iPf11PiBCy_Q/edit?mid=ACjPJvG5R-_1eRe-AWHftRSjHES-sDpt0QUvy61f2SDnYcQLyiIu2xsMa4KlKicE_Eu8KdBp3zbwch7Ql1iwA_-xuOPAYo56Xd5gRxsg34z1rygLtWrfV7JA8W2HnfuvQnud6slVscrrGkE&uiv=2

Answer 19

Okay
No problem.
please help me when you are on pc

Answer 20

You can open the userForm following the 'custom manu'