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…
Writing a program in Google's App Script to sync a Calendar to a Sheet. The program successfully adds events from the Calendar into the spreadsheet whenever the Calendar is updated however I want to make it more specific. Is there…
I've been using Google Apps Script to deploy a web app, which plays videos on the side bar. The video links are from the Google Sheet. It worked until I have two files about 500mb each. The videos couldn't play…
I am new to google apps script. I have 3 sheets data (source), sheet(target), and master_rate. in the datasheet, there are around 4k rows of data. what I am doing is summarising the data sheet and displaying it in sheet…