I was getting problemas with my code to format the borders of a table in a Google Document and Tanaike helpe me here The problem now is that my table is not getting formatted, it is as if the code…
In order to obtain the necessary code to get a function that can be executed every time a local is selected in "id-local" and that what it does is the following: with the data that this input has <form class="row…
I want to create automated google calendar events from Google Form responses that are feeding into a Google Sheet, using Google Apps Script. My issue is the date formatting - I've tried two different methods and neither resulted in the…
The Woocommerce export to a Google Spreadsheet with the code below works. Except the format of the order total shows "99.95" instead of "99,95". This results in some faults in further processing the data. Is there a solution to fix…
I have an empty column, let's say Column 'C'. Column 'C' is where a user can add his comments. When he adds his comments in the rows under Column 'C', it can be random. For instance: I want to build…
I am trying to write a Google Sheets script to copy the display values from one sheet on a workbook to another sheet on a workbook. However, I am receiving the following error message, "Exception: The number of rows in…
i was trying to get an expression for google script for a google document that i cant get. I want to find all occurences of words that are: "X-X-Xr" Where "X" is a capital letter or number, "-" it is…
I have a database that has columns of RGB values and I wanted to display the color on anther column. I will have a custom function on the cell where I passed in the RGB values from the other columns.…
const ss = SpreadsheetApp.getActiveSpreadsheet(); // collect data. const sourcerange = ss.getRangeByName("b94:h94"); const sourceVals = sourcerange.getValues(); // skip val, gather user email const email = Session.getActiveUser().getEmail(); const data = {email,sourceVals}; console.log(data); //append data const destinationsheet = ss.getSheetByName("test log"); destinationsheet.appendRow(data); edit: error…
I want to automatically produce a PDF of my invoices. The worksheet (master) where I generate the invoices has several tabs which I do not want to print. My thoughts were to create a single tab sheet and print from…