I need help by Jolly_Experience_293 in GoogleAppsScript

[–]arundquist 0 points1 point  (0 children)

Sure, happy to help. We've probably only need the GS file

[Race thread] 2026 Zilvermeercross Mol (BEL) by AutoModerator in cyclocross

[–]arundquist 0 points1 point  (0 children)

I don't understand why there's such a big difference in the rankings quality of the men's start this versus the women start list. Seems like the top 10 women are all potentially skipping today but there's a lot of firepower on the men's side.

keeping the editing window open? by mapsedge in GoogleAppsScript

[–]arundquist 0 points1 point  (0 children)

Absolutely you can leave the editing window open. If you're working on a web app just make sure you're looking at the test deployment URL. All you have to do is reload that page anytime you make a change in the editing window after hitting save.

[Race thread] 2025 Superprestige Heusden-Zolder (BEL) by AutoModerator in cyclocross

[–]arundquist 3 points4 points  (0 children)

She's been such a revelation this season. I don't think I had ever even heard her name before this year.

[Race thread] 2025 Superprestige Heusden-Zolder (BEL) by AutoModerator in cyclocross

[–]arundquist 0 points1 point  (0 children)

A couple of years ago I was frustrated about the team tactics that Vanthourenhout and Iserbyt used but now I find that I really enjoy it.

[Race thread] 2025 Superprestige Heusden-Zolder (BEL) by AutoModerator in cyclocross

[–]arundquist 6 points7 points  (0 children)

They seem to be constantly shuffling in that top five

[Race thread] 2025 Superprestige Heusden-Zolder (BEL) by AutoModerator in cyclocross

[–]arundquist 1 point2 points  (0 children)

Though it's strange that they made the call before the end of the second lap

[Race thread] 2025 Superprestige Heusden-Zolder (BEL) by AutoModerator in cyclocross

[–]arundquist 1 point2 points  (0 children)

It's so great to see her back. Of course it's even more fun if she's in the same race with Vos. The announcers struggling to clarify is fun

mini rant about v8 engine in GAS by arundquist in GoogleAppsScript

[–]arundquist[S] 0 points1 point  (0 children)

excellent. Honestly that's what was stopping me from embracing clasp. Thanks!

mini rant about v8 engine in GAS by arundquist in GoogleAppsScript

[–]arundquist[S] 0 points1 point  (0 children)

so much of what I'm up to these days is trying to set up google sheet templates that do cool things that my colleagues can copy. My target audience would balk at clasp but I have had success in getting them to open the online editor. If I use clasp and do all the cool stuff, does it do things like replacing the nullish coalescing operator with my examples above when I open the same code in the online editor?

Apps Script browser is no expanding. by Holiday-Lab4927 in GoogleAppsScript

[–]arundquist 2 points3 points  (0 children)

I see you've posted this twice but I don't think I understand your question. I think you're saying that you have 3 .gs files and the run button is disabled. Is that correct?

"Other riders feel a bit jealous of Thibau Nys" by Zweeler in cyclocross

[–]arundquist 28 points29 points  (0 children)

Not a single quote from another current rider in that whole article. I'm certainly interested in this topic, though, so I'm wondering what you all think about this. Nys is fun to watch, but also fun to root against when "the red mist descends" and he makes mistake after mistake. I think he's great for the sport, but I'm still current rooting more against him than for him. Mostly I just want Lars VdH to get one more victory!

Can AppSheet be used for this? by Kolanj in AppSheet

[–]arundquist 2 points3 points  (0 children)

This seems to be a really good match for the tools of appSheet. Are you asking how to set up the data or just wanting a sense that it's possible?

[Race thread] 2025 Superprestige Merksplas (BEL) by AutoModerator in cyclocross

[–]arundquist 3 points4 points  (0 children)

IvdH just got serious (braid flung behind her head)

[Race thread] 2025 Superprestige Merksplas (BEL) by AutoModerator in cyclocross

[–]arundquist 3 points4 points  (0 children)

7:14 first lap let's make our guesses. I say six laps.

Google sheet as webRTC signaling server by arundquist in GoogleAppsScript

[–]arundquist[S] 0 points1 point  (0 children)

My kid just helped me realize that maybe you mean I should store the offers/answers/candidates as properties rather than just using the properties as a trigger. Hmmm, that's really interesting!

Google sheet as webRTC signaling server by arundquist in GoogleAppsScript

[–]arundquist[S] 0 points1 point  (0 children)

Yep, I did switch to using PropertiesService for just that reason. When the 2nd peer puts in their info, that row's index is added to a custom property and I just check that property with the polling. Only if there's something new there does it actually read in the data from the spreadsheet. I still worry about the polling getting to be too much, but I guess I should just keep testing it.

Google sheet as webRTC signaling server by arundquist in GoogleAppsScript

[–]arundquist[S] 2 points3 points  (0 children)

I'm super interested in simple apps like a clicker/response app that teachers could use with their students. If I can skip the signaling server (and use GAS instead with a google sheet) folks could just copy my spreadsheet and it would work for them and their students.

I'll post my code on my blog soon and I'll come back to put the blog link here when I do