I am trying to use the dayjs library in my Google apps script and some of its plugins. I first added the library to my project by searching for the following script ID: 1ShsRhHc8tgPy5wGOzUvgEhOedJUQD53m-gd8lG2MOgs-dXC_aCZn9lFB Then I used it in my…
I have a form which will generate a letter once submitted based on the Google form submission. One of the questions has three outcomes and depending on the entry, it will delete either one line, or both lines. I have…
I'm progressively working through learning enough of HTML and javascript to apply to a google sheets package I'm developing for personal use. I developed a script from assistance on a previous post I made but am having some issues. Essentially…
I have a spreadsheet which values comes from an importRange built-in function, the thing is that the getRange function is not fetching the right values, regardless the ROW, COLUMN selected, it returns the word "info" all the time except for…
I have a Google Sheet and I'm trying to output a date or string depending on three dates and three booleans which represent a task as complete. I've been writing a custom function to do this but I can't get…
Google Apps Script: I have an array with numbers. The array contains monetary values extracted from an invoice. Another array contains the applicable VAT/tax values. For each tax value I want to find the applicable value pair(s) in the array.…
I'm trying to set up this in Google Sheets, where there's info being added to a spreadsheet and a pdf is created from a template. I copied this code from a YT video: function createBulkPDFs(){ const docFile = DriveApp.getFileById("ID"); const…
This script import new clients from the source files and update the existing clients with possible new data from the client sheet. The problem I'm getting is that the script always update the header "Ultimo cambio" (last change in spanish)…
The options in the dropdown are Completed, In Progress, and Followup. I only want to hide the row when Completed is selected. Is there a way to achieve this? Tried the following function function onEdit(e) { const columns = [3];…
I'm trying to run a script to parse through my sent box and scrape unique email addresses in the to and cc lines of my outgoing email. I think I might be running into a memory limit. But I'm not…