Hi, David. Thank you for the awesome video. I have a question. As far as I know, the Session.getActiveUser().getEmail(); doesn't work with the client user as long as the client is you or gives you the permission as you deployed the webApp with user accessing web app. Am I right? or is there any other way to get active user's email address?
Hi David, great video, How could it be done so that when opening the sheet in the open event, it opens the modal directly without having to use the custommenu? Thanks
Hi RICHO, Thank you! This is a rather straightforward solution. Instead of creating your trigger to run the function addMenuItem() when the spreadsheet is opened, configure it to run the function showModal() instead. Let me know if this helps!
Hi David,Thanks for the video! I'm am trying to make a modalDialog box onOpen(e) that contains a form. I want the details from the form to got various columns in a spreadsheet. I can't seem to even get the form object back to javascript file though. Any pointers? I notice you used an addEventListener to yours instead of a standard submit...
Wonderful series... as a noob I have no idea about programming, thansk for making time and hope I can see more about apps script / google sheets....
Hi, David. Thank you for the awesome video. I have a question. As far as I know, the Session.getActiveUser().getEmail(); doesn't work with the client user as long as the client is you or gives you the permission as you deployed the webApp with user accessing web app. Am I right? or is there any other way to get active user's email address?
Hi David, great video, How could it be done so that when opening the sheet in the open event, it opens the modal directly without having to use the custommenu? Thanks
Hi RICHO, Thank you! This is a rather straightforward solution. Instead of creating your trigger to run the function addMenuItem() when the spreadsheet is opened, configure it to run the function showModal() instead. Let me know if this helps!
@@DavidWeissProgramming it worked perfect
, thank you David
Hi David,Thanks for the video! I'm am trying to make a modalDialog box onOpen(e) that contains a form. I want the details from the form to got various columns in a spreadsheet. I can't seem to even get the form object back to javascript file though. Any pointers? I notice you used an addEventListener to yours instead of a standard submit...
🙏🏻👏👍🏻