Have chased my tail over this and even managed to lock up OpenAI's new ChatGPT interface into a repeated cycle of errors or incorrect values. Trying to enter the entire code into one cell does not seem to have an…
I'm trying to create a comparison line chart for student marks written on different dates. I want to display the date and the mark for example 2021 on one line and the dates and marks which were on different dates…
I have a folder named "Folder A" that contains Google Docs files that are added every month. I want to export in a Google Spreadsheet named "Exports" the previously last created file (the penultimate file created) in the "Folder A".…
How to make .map() ignore values in array. In script below values in column B and C of dstSheet are erased when running script. I want to keep it. How to modify this script? function dorozliczenia() { const ss =…
I'll be giving a bit of context: Using App script, I'm working on a macro which copies data from a sheet to another. To avoid copying mistakes cascading, I added code to check whether or not the cells are empty.…
This is the code : var values = [[ ph, sd, sg, qz, str ]]; var Rangeisi = shtdb.getRangeList(['C3:C6','C9']); if(id="id001"){Rangeisi.setValues(values); return } And this is the result : TypeError: Rangeisi.setValues is not a function But when I use this code…
I have JSON text in excel cells but it's hard to read. I want to format the text so it's easier to read the variable/value. var ss = SpreadsheetApp.getActive(); var jVal = ss.getRange('N145').getValue(); var jFormat = JSON.stringify(jVal,null, 3); SpreadsheetApp.getUi().alert(jFormat); Text…
Facing this error (Could not get unknown property 'kotlin_version' for object of type org.gradle.api.internal.artifacts.dsl.dependencies.DefaultDependencyHandler) following is the build gradle code. plugins { id 'com.android.application' id 'org.jetbrains.kotlin.android' } android { namespace 'com.example.forpfl2' compileSdk 33 defaultConfig { applicationId "com.example.forpfl2" minSdk 16 targetSdk…
Hi what I'm trying to do is get the data from a Salesbinder invoice API (Invoice # is taken from Sheet2 Cell A1) output the data to a Google sheet (sheet Cell A2) here's the code i'm using to get…
This Google Apps Script code to scrape press release news from Yahoo Finance randomly stopped working today. It suddenly gives the following error - TypeError: Cannot read properties of undefined (reading 'streams') (line 6) function pressReleases(code) { var url =…