Questions tagged [gsheets]
20 questions
1
vote
2 answers
How to get total number of rows with data in a sheet using gsheets dart library?
Using the gsheets library, I can calculate the total number of rows in a specific sheet:
var sheet = ss.worksheetByTitle('test');
var rows = await sheet?.values.map.allRows();
var totalRows = rows?.length;
However, the above code requires fetching…
B Faley
- 17,120
- 43
- 133
- 223
0
votes
1 answer
How would I create a search box using IMPORTDATA?
I'm trying to create a search box that displays the result in a different Spreadsheet. The one I am importing has only the names. It is in the A column with no heading.
I have this formula
=QUERY(IMPORTDATA("URL", "Sheet1!A1:A29"), "SELECT * WHERE A…
Another Legend
- 1
- 1
0
votes
0 answers
Downloading an xlsx file from a webpage with google apps script
The webpage already has the export xlsx option.
I would like to get the data from the page and paste it to a gsheet. Is it possible with a script? if yes, could you explain me the process a bit.
Thank you
Pelin
- 127
- 6
0
votes
1 answer
shiny code optimization avoid repeating renderPlotly... maybe with a loop
I have a shiny app pulling data from a gsheet and displaying it in graphs inside individual tabs. The app works but:
the code inside the server section repeats itself too much => i was looking for suggestions to optimize it: could i use a loop to…
Romain
- 171
- 11
0
votes
0 answers
Diff between 2 gsheets sheets rows with multiple columns
I Have 2 sheets in a google sheet that have the same columns:
Name, Subject, Score
I want to create a new sheet where it lists all the rows in the second sheet that are not in the first sheet. Any change in one of the 3 columns should be in the new…
0
votes
1 answer
Copy selected/highlighted rows
This script is intended to copy the column values of rows which i highlighted/selected and paste to another googlesheet. However instead of copying column values of the rows which i selected, it is copying the first row column values instead.How can…
JP0710
- 41
- 6
0
votes
1 answer
Partial string matching to index output - Google Sheets
I'm using gsheets to structure survey responsed. I've got the list of responses (an array, user could have selected multiple).
I've then seperated the unique responses to group them.
Next I wanted to isolate distinct responses for each grouping so I…
Viktoria
- 3
- 1
0
votes
0 answers
printing header on Google Sheet
I've been using a script from carlesgg97 here. It's worked great! There's a line for a header ('fzr': false, // repeat row headers) which I finally need to use but have no idea how to define that header, or where to put it in the code.
Can anyone…
Missy Goldberg
- 13
- 3
0
votes
1 answer
Populating a cell with data from one sheet based on if another sheet cell contains a certain value
I would like a cell in Sheet3 to populate with data from Sheet2 IF data from sheet1 contains a specific value.
I have tried:
=IF('Sheet1'!A1="Yes",'Sheet3'!A1='Sheet2'!A1,"")
I was hoping that this formula would input data from Sheet2 A1 into Sheet3…
Row
- 11
0
votes
0 answers
Using dart g.sheets package how do i display all rows of the sheet
I am very new to coding and trying to learn. However, I have got stuck with trying to read existing data from google sheets using the g.sheets package.
Inside the Gsheets Api file, I currently have
/// Get all tasks
static Future>…
Blake
- 1
- 1
0
votes
0 answers
Is there a way to have a email sent if a certain cell contains a set word?
I have been working to send a email out automatically if a certain phrase is put in cell. We have found a formula but it sends out out a email even if the cell contains other words. Can you help out. Here is the current formula minus email addresses…
Terry Pack
- 1
- 1
0
votes
0 answers
gSheets checkbox value sometimes 'true' or true - what gives?
I have inserted multiple checkboxes in a Google sheet. I then use code to read the value and do things if it is true.
The line in question reads
if (variable == true){
then blah blah but sometimes I have to have
if (variable == 'true'){
with single…
Missy Goldberg
- 13
- 3
0
votes
1 answer
New Rows not aligned correctly when appended in google sheet via PHP/API
First time trying to automate some tasks with PHP and gSheet with API. Sorry in advance if my question is fool, I'm really lost here as a newbie.
My php page gets an array converted from a csv file like the…
ja rpa
- 1
- 1
0
votes
0 answers
How to update a cell depending on a specific date
I have a report with data on learning activities of some learners, see sheet here.
They are enrolled in a language learning program and to reach their goal, they have to learn 8 hours per month (sum of hours spent in self study, group classes and…
nadiamarra
- 3
- 1
0
votes
1 answer
How to merge data from different sources with a condition in GSheet?
I am trying to merge data from different GSheet sources while filtering them to get only cases that are >= 30min in a processing time column. However, before even filtering it, I'm facing a problem just importing the data.
I using a code…
gbam-ds
- 3
- 2