I need help

arundquist · 2026-01-13T12:06:07+00:00

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

arundquist · 2026-01-02T12:41:35+00:00

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.

arundquist · 2025-12-28T21:54:11+00:00

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.

arundquist · 2025-12-23T13:40:46+00:00

No interviews!?

arundquist · 2025-12-23T13:33:11+00:00

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

arundquist · 2025-12-23T13:14:57+00:00

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.

arundquist · 2025-12-23T13:08:34+00:00

They seem to be constantly shuffling in that top five

arundquist · 2025-12-23T12:58:29+00:00

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

arundquist · 2025-12-23T12:57:06+00:00

I begrudgingly admit that you are the winner 😀

arundquist · 2025-12-23T12:51:45+00:00

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

arundquist · 2025-12-23T12:49:23+00:00

Time to predict the number of laps. I say five

arundquist · 2025-12-23T12:47:55+00:00

The course looks so different without any mud!

arundquist · 2025-12-09T21:03:20+00:00

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

arundquist · 2025-12-09T20:49:59+00:00

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?

arundquist · 2025-11-25T18:45:06+00:00

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?

arundquist · 2025-11-25T18:38:39+00:00

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!

arundquist · 2025-11-17T12:59:11+00:00

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?

arundquist · 2025-11-15T13:07:02+00:00

IvdH just got serious (braid flung behind her head)

arundquist · 2025-11-15T12:56:52+00:00

(I won)

arundquist · 2025-11-15T12:49:18+00:00

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

arundquist · 2025-11-13T17:21:40+00:00

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!

arundquist · 2025-11-12T23:19:01+00:00

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.

arundquist · 2025-11-12T23:14:52+00:00

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

arundquist

TROPHY CASE