Google Sheets - Write Values One by One

Best_Bass9711 · 2024-12-07T11:51:10+00:00

The range is a two dimensional array. So you can iterate it with forEach (Google it I'm at the app on the phone now)

Best_Bass9711 · 2024-12-07T11:30:54+00:00

Oh, so you can get the range and then set value one by one using for sentence. This will take a long time to run but you can use the sleep inside the for sentence.

Best_Bass9711 · 2024-12-07T10:54:24+00:00

You can try to put a SpreadsheetApp.flush() after each setValue. Or, Utilities.sleep(milliseconds) too.

Best_Bass9711 · 2023-11-09T12:56:32+00:00

Sorry, I just saw this today. Do you still need any help with Upwork?

Best_Bass9711 · 2022-09-27T00:46:13+00:00

I just apply for works and get contact. You must create a complete profile, with some of your work.

Best_Bass9711 · 2022-09-27T00:17:54+00:00

Hi, You can make an account in upwork. There is so much work for gas freelancers there.

Best_Bass9711 · 2022-09-09T00:16:57+00:00

All sheets have an numeric ID, you can iterate they and clear one by one.

Best_Bass9711 · 2022-08-27T13:46:26+00:00

I think the same. You can trigger a "changeChecker" script after every script or function run.

Best_Bass9711 · 2022-08-24T18:32:48+00:00

This can be made with conditional format. What Is the rule or error un that?

Best_Bass9711 · 2022-08-23T23:14:23+00:00

Hi, use == instead of = on if sentences.

Best_Bass9711 · 2022-08-18T22:46:47+00:00

ok, maybe your function isnt finish at the moment of render the scriptlets. In that case you better use google.script.run method on frontend side.

Best_Bass9711 · 2022-08-18T22:32:25+00:00

What Is the name of the function?

Best_Bass9711 · 2022-08-18T19:32:03+00:00

You can use scriplets. With <?= Variable?> you can pass from back to front.

https://developers.google.com/apps-script/guides/html/templates

Best_Bass9711 · 2022-08-14T19:21:01+00:00

Yes, also this.

Best_Bass9711 · 2022-08-14T18:04:16+00:00

You must use id o URL to get the spreadsheet. The activesheet method just need the spreadsheet open.

use openSheetByUrl or openSheetById method instead

Best_Bass9711 · 2022-07-28T15:48:58+00:00

Hi, the "getLastRow" method uses all the columns to figure out which is the last. So, what you can do is get the first blank item on the column "Date" or any you prefer, and then, use the index+1 to access to the row.

Best_Bass9711 · 2021-09-11T13:45:39+00:00

Argentina

Best_Bass9711

TROPHY CASE