All Questions

as per below code, from GoogleSheet, I wanted WhatsApp to open with some specific text ready to be sent when user sets a cell to "Ready to Print". The problem is every time a column in ...

I have recently gotten into Google Scripting to manage a School's IT space. I am currently working on a script that should check any students who have left and remove their paid licenses. However, I ...

I have an application (running on an IoT Boron device from Particle) that posts error messages to a Google sheet via a Webhook Web Form. The sheet serves as a log of application faults and this has ...

I have a table which looks like this: I want to copy the first two columns of data and insert them before the EOF, but empty them before the paste. The end result should look like this: So far, my ...

I am trying to create a simple Invoice generator that includes our company logo, but the logo will NOT render in the final PDF. I am designing the invoice template using HTML instead of a Google Doc ...

I’m having trouble getting a log-based alert policy to work in Google Cloud Monitoring. I can see the logs in the Logs Explorer and the filter seems to match correctly, but the alert never triggers ...

Hopefully, the title is clear. What I am NOT asking. How to update the cells background color to match the Theme via hex color code. How to update the spreadsheet theme colors themselves via appscript....

I’m building a Google Docs add-on using React + Google Apps Script (via clasp). From the sidebar, I receive a .docx file as a Base64 string (binary content). I can successfully convert the .docx to a ...

I have a script which checks the value of a series of flags before deciding on an execution pathway. Because of the way the script executes, the flag values are held as script properties, therefore ...

I have an Add-On under review in the Google Marketplace. My Add-On runs in Google Slides and needs to access Google Sheets data to create various visuals in Slides. Specifically my Add-On pulls data ...

I'm a long time reader, first time poster. I'm having a problem showing invoice details for each company id for this sheets. https://docs.google.com/spreadsheets/d/1iTJ8PR3snsbZKh01-...

I'm developing a Google Workspace Add-on for Google Drive and have run into a strange rendering bug. When my add-on is opened in the Drive sidebar, the card generated by my homepageTrigger function is ...

I have a spreadsheet that receives data inputs externally. That data is used by sheet formulas to calculate an output which is then collected via an HTTP request. What is the best way to allow google ...

So as per previous suggestions, I'm using checkboxes to replace the .getUi method so my project will work properly on mobile devices. I've come across a strange scenario and I wanted to confirm this ...

I have this table and the chart I want as below: To acheive this I have to switch rows/columns, and use column A as headers. However I cannot find the corresponding command for the checkbox "Use ...