I am making a web app using google sheets and google app script. My web app have an index page and an input page. There is no problem with inputting the data, however when i try to populate the data from google sheet it displayed undefined value for cells that are empty in the google sheet.
My script is quite long so i attached it here:
https://drive.google.com/drive/folders/1Zl-8UsntRUTlJcnaBuYIgXP2PvD4mIyN?usp=sharing
What i want is, when i click the edit button the form will be populated with the right data and if the data in google sheet is empty then it will just display the placeholder.
Thank you in advance.