2026-01-30_ai_platform_-_linear_automation_sync_74d726a5

Meeting Title: AI Platform - Linear Automation Sync Date: 2026-01-30 Meeting participants: Gabriel Lam, Samuel Roberts, Casie Aviles

---

WEBVTT

1 00:02:07.730 ⇒ 00:02:08.810 Samuel Roberts: Ayy.

2 00:02:12.440 ⇒ 00:02:13.680 Gabriel Lam: Hello!

3 00:02:15.380 ⇒ 00:02:16.429 Samuel Roberts: How are you doing?

4 00:02:17.510 ⇒ 00:02:27.180 Gabriel Lam: I’m doing well, the little stuck on the railway side, I think because it’s not extracting the right

5 00:02:28.040 ⇒ 00:02:34.390 Gabriel Lam: client ID, or it’s like… Defaulting to a local.

6 00:02:34.730 ⇒ 00:02:39.509 Gabriel Lam: So I’m… I’m sort of debugging it, as I see it.

7 00:02:39.650 ⇒ 00:02:40.330 Gabriel Lam: Bye.

8 00:02:43.340 ⇒ 00:02:48.259 Gabriel Lam: Wanted to set a time just to discuss the linear thing, and…

9 00:02:49.820 ⇒ 00:02:53.600 Gabriel Lam: Basically see, like, okay, what are the sort of next steps that we can take?

10 00:02:54.290 ⇒ 00:02:58.310 Gabriel Lam: Given what we had on Wednesday.

11 00:03:03.010 ⇒ 00:03:05.090 Samuel Roberts: Right, sorry, shifting gears, I was in…

12 00:03:05.090 ⇒ 00:03:09.310 Gabriel Lam: You’re good, no problem. Actually, let me send a quick message, yeah.

13 00:03:10.320 ⇒ 00:03:11.390 Samuel Roberts: for me.

14 00:03:12.210 ⇒ 00:03:14.590 Samuel Roberts: Oh, why is that not… oh, maybe I’m not ready.

15 00:03:24.350 ⇒ 00:03:25.840 Samuel Roberts: Sorry, I was just trying to…

16 00:03:26.330 ⇒ 00:03:27.510 Samuel Roberts: But I don’t think it’s gonna happen.

17 00:03:36.940 ⇒ 00:03:38.669 Samuel Roberts: Well, I’ll just deal with that later.

18 00:03:40.820 ⇒ 00:03:42.380 Samuel Roberts: Actually, Allison, that’s real quick.

19 00:03:46.320 ⇒ 00:03:50.319 Samuel Roberts: No, I’ll send it after, because it’ll take too long to explain. Okay,

20 00:03:50.470 ⇒ 00:03:56.989 Samuel Roberts: Yes, so we got the linear IDs in there, so we can probably not…

21 00:03:57.470 ⇒ 00:04:02.450 Samuel Roberts: Do the lookup the way we were doing, which will help identify people in the meetings.

22 00:04:02.770 ⇒ 00:04:03.480 Gabriel Lam: Yes.

23 00:04:08.790 ⇒ 00:04:18.199 Samuel Roberts: From there, we need to come up with a good way to identify the teams, which maybe would be better now that we know all the people, ideally.

24 00:04:18.839 ⇒ 00:04:19.589 Gabriel Lam: Yeah.

25 00:04:21.959 ⇒ 00:04:31.749 Gabriel Lam: I think the other thing was, like, it wasn’t… at least on your Ghostify, it wasn’t tagging everyone in the meeting, it was just tagging, I think, like, 4 people.

26 00:04:32.060 ⇒ 00:04:39.220 Samuel Roberts: Yeah, I think that was because of the way it was doing the lookups for names, so I’m hoping that means now we can just pull those…

27 00:04:40.220 ⇒ 00:04:43.569 Samuel Roberts: Right from the table, based on the emails.

28 00:04:45.360 ⇒ 00:04:50.059 Samuel Roberts: Or the names, whatever we have. I think we have names, which might be an issue, but…

29 00:04:53.670 ⇒ 00:04:59.550 Samuel Roberts: Yeah, okay.

30 00:05:04.210 ⇒ 00:05:09.289 Samuel Roberts: Yeah, buddy. Alright, so let’s see… We need…

31 00:05:12.290 ⇒ 00:05:17.460 Samuel Roberts: Well, okay, let’s just try it. Hold on, let me… let me get into the code. I’m gonna start, like, talking, but I wanna see if this.

32 00:05:17.460 ⇒ 00:05:18.850 Gabriel Lam: No, you’re good, you’re good.

33 00:05:19.940 ⇒ 00:05:22.770 Gabriel Lam: Trying to change context as well, and trying to…

34 00:05:23.340 ⇒ 00:05:25.269 Gabriel Lam: resurface what I had thought of.

35 00:05:28.590 ⇒ 00:05:29.400 Samuel Roberts: Yeah.

36 00:05:34.430 ⇒ 00:05:36.089 Gabriel Lam: So I think the first thing we were…

37 00:05:37.480 ⇒ 00:05:45.480 Gabriel Lam: we had left off. Where we had left off was… it was able to finally… sort of… Split.

38 00:05:46.310 ⇒ 00:05:48.959 Gabriel Lam: tickets from Create and Update.

39 00:05:49.690 ⇒ 00:05:51.970 Samuel Roberts: We did have that, sort of, didn’t we?

40 00:05:51.970 ⇒ 00:05:52.450 Gabriel Lam: Yeah.

41 00:05:52.450 ⇒ 00:05:54.190 Samuel Roberts: But it was… didn’t seem…

42 00:05:54.420 ⇒ 00:06:01.360 Samuel Roberts: Well, I think the problem we have… yeah, that problem might have been because of the Teams issue, which hopefully is better now?

43 00:06:04.760 ⇒ 00:06:07.600 Samuel Roberts: Okay, let me… Sorry, I’ll…

44 00:06:07.860 ⇒ 00:06:08.179 Gabriel Lam: You’re good.

45 00:06:08.180 ⇒ 00:06:09.789 Samuel Roberts: All over the place right now.

46 00:06:14.470 ⇒ 00:06:15.589 Samuel Roberts: Let me close out.

47 00:06:15.720 ⇒ 00:06:22.390 Samuel Roberts: All this stuff I got here… And switch over to…

48 00:06:24.270 ⇒ 00:06:27.270 Samuel Roberts: platform, right? That’s what we’re on.

49 00:06:28.490 ⇒ 00:06:32.430 Samuel Roberts: Okay, so we have the linear IDs, we want to merge… okay, so we were…

50 00:06:34.010 ⇒ 00:06:37.510 Samuel Roberts: Working on the linear… let me share my screen.

51 00:06:37.920 ⇒ 00:06:39.200 Gabriel Lam: Yes. Talking.

52 00:06:39.560 ⇒ 00:06:40.190 Gabriel Lam: Awesome.

53 00:06:40.770 ⇒ 00:06:42.259 Samuel Roberts: If I know where you want to eat.

54 00:06:46.790 ⇒ 00:06:48.420 Samuel Roberts: So, I will share…

55 00:06:54.350 ⇒ 00:06:55.010 Samuel Roberts: Come on.

56 00:06:57.840 ⇒ 00:06:58.610 Samuel Roberts: Okay.

57 00:06:59.790 ⇒ 00:07:05.229 Samuel Roberts: Is this, like, too big? Should I shrink it? How are you… I don’t know what you’re seeing.

58 00:07:05.920 ⇒ 00:07:09.820 Gabriel Lam: I’m seeing your Git graph on cursor.

59 00:07:09.820 ⇒ 00:07:12.200 Samuel Roberts: Okay, and you can read things? I just want to make sure, like, I have no.

60 00:07:12.200 ⇒ 00:07:12.629 Gabriel Lam: Yeah, yeah, yeah.

61 00:07:12.630 ⇒ 00:07:13.910 Samuel Roberts: coming in as… yeah, okay.

62 00:07:14.460 ⇒ 00:07:21.839 Samuel Roberts: Okay, so what I’m gonna first do is merge… main… Into what we have.

63 00:07:23.410 ⇒ 00:07:26.989 Samuel Roberts: That will have the linear ID… no, it doesn’t matter. Nevermind.

64 00:07:27.100 ⇒ 00:07:28.809 Gabriel Lam: I think you’ve already merged.

65 00:07:30.490 ⇒ 00:07:34.330 Samuel Roberts: It’s into main, I’m just saying I was gonna merge it into the linear ticket one, but it actually doesn’t

66 00:07:34.470 ⇒ 00:07:37.030 Samuel Roberts: Because all that did was change the table.

67 00:07:37.550 ⇒ 00:07:37.980 Gabriel Lam: Yeah.

68 00:07:37.980 ⇒ 00:07:42.089 Samuel Roberts: So, we’ll not worry about that yet. Okay, so we’re on this branch.

69 00:07:44.460 ⇒ 00:07:47.659 Samuel Roberts: We’ll go here… Civil base is what got…

70 00:07:48.140 ⇒ 00:07:54.759 Samuel Roberts: there now is probably not tracked, so we’ll ignore that for now, but that’s all gonna be there, isn’t it? We could probably…

71 00:07:56.490 ⇒ 00:08:00.160 Samuel Roberts: Wow.

72 00:08:00.380 ⇒ 00:08:02.829 Samuel Roberts: Oh, not a problem. He’s combo.

73 00:08:05.710 ⇒ 00:08:06.500 Samuel Roberts: Okay.

74 00:08:06.600 ⇒ 00:08:09.489 Samuel Roberts: So… What files have we changed?

75 00:08:10.500 ⇒ 00:08:14.679 Samuel Roberts: Right, we had the run… okay, okay, I’m remembering things, sorry.

76 00:08:16.450 ⇒ 00:08:24.059 Samuel Roberts: I was in Google Sheets, and so my brain is in very different than programming mode right now.

77 00:08:24.560 ⇒ 00:08:27.189 Samuel Roberts: This is fine, I can… I can catch up. Okay.

78 00:08:28.080 ⇒ 00:08:30.999 Samuel Roberts: Linear integrations is this one, right?

79 00:08:33.860 ⇒ 00:08:36.149 Samuel Roberts: Nope, that’s the one where I did the actual…

80 00:08:39.190 ⇒ 00:08:40.139 Samuel Roberts: This one.

81 00:08:44.200 ⇒ 00:08:46.559 Samuel Roberts: Thought for one second. Okay, we’re gonna…

82 00:08:47.930 ⇒ 00:09:00.099 Samuel Roberts: Does this function do what it claims? That’s the last thing we did. Yeah. Okay. So, I think what I’m gonna say now is, where we get matched users is the…

83 00:09:00.800 ⇒ 00:09:05.040 Samuel Roberts: thing we can now update, right? So, where are we calling this?

84 00:09:06.940 ⇒ 00:09:15.930 Samuel Roberts: Linear ticket pipeline, calculate common teams from matched users, matched users is this one. Okay, so this function can probably get

85 00:09:16.320 ⇒ 00:09:17.540 Samuel Roberts: Updated, okay.

86 00:09:19.000 ⇒ 00:09:20.170 Samuel Roberts: I’m gonna pass this in.

87 00:09:21.560 ⇒ 00:09:23.550 Samuel Roberts: And I’m going to explain that.

88 00:09:24.820 ⇒ 00:09:34.250 Samuel Roberts: we now have linear IDs stored on the Teams table in Superbase. I think we can use that to match better.

89 00:09:39.370 ⇒ 00:09:43.470 Samuel Roberts: And then say… I have RCP set up, I think I do.

90 00:09:45.040 ⇒ 00:09:49.089 Samuel Roberts: I was playing with Superbase earlier, I don’t know if I set that up here.

91 00:09:50.240 ⇒ 00:09:55.379 Gabriel Lam: I think there’s a auto… Like, if… I don’t see it, but…

92 00:09:55.660 ⇒ 00:09:56.879 Samuel Roberts: Yeah, no, okay.

93 00:09:57.200 ⇒ 00:10:00.160 Gabriel Lam: I think you can pretty easily just go to the.

94 00:10:00.160 ⇒ 00:10:00.810 Samuel Roberts: Yeah.

95 00:10:00.810 ⇒ 00:10:01.470 Gabriel Lam: directory.

96 00:10:01.470 ⇒ 00:10:05.650 Samuel Roberts: I might just… tell it what I have there.

97 00:10:05.920 ⇒ 00:10:08.139 Samuel Roberts: Not worried about it for a second.

98 00:10:09.650 ⇒ 00:10:12.279 Samuel Roberts: Let me… nope, it’s time.

99 00:10:14.130 ⇒ 00:10:16.829 Samuel Roberts: Need a new superbase.

100 00:10:23.890 ⇒ 00:10:30.150 Samuel Roberts: This is… Or… and it’s, on the… Oops, table editor.

101 00:10:30.910 ⇒ 00:10:33.899 Samuel Roberts: team, and I believe it’s just linear…

102 00:10:34.380 ⇒ 00:10:36.590 Samuel Roberts: User ID, okay, that’s good, okay.

103 00:10:38.220 ⇒ 00:10:39.060 Samuel Roberts: Oops.

104 00:10:39.440 ⇒ 00:10:48.160 Samuel Roberts: Alright, we, the column is… Let’s just try that.

105 00:10:48.810 ⇒ 00:10:50.100 Samuel Roberts: If this…

106 00:10:51.080 ⇒ 00:10:56.570 Samuel Roberts: It feels a little bit like I’m kind of going a little granular here, but I think if this helps, we’ll know.

107 00:10:59.030 ⇒ 00:11:02.239 Samuel Roberts: how much of an issue matching the teams is gonna be.

108 00:11:02.240 ⇒ 00:11:03.050 Gabriel Lam: Yeah.

109 00:11:03.740 ⇒ 00:11:08.839 Gabriel Lam: I also wonder if we should tell them, like, which table, because that’s probably not gonna change.

110 00:11:10.060 ⇒ 00:11:10.580 Gabriel Lam: And…

111 00:11:10.580 ⇒ 00:11:11.080 Samuel Roberts: There’s a way to…

112 00:11:11.080 ⇒ 00:11:12.160 Gabriel Lam: a table idea.

113 00:11:12.160 ⇒ 00:11:14.619 Samuel Roberts: You’re right, I kind of thought I would have figured that out, my bad, you’re.

114 00:11:14.620 ⇒ 00:11:15.060 Gabriel Lam: You’re good.

115 00:11:15.060 ⇒ 00:11:15.720 Samuel Roberts: for that.

116 00:11:16.360 ⇒ 00:11:19.849 Samuel Roberts: I said Teams… Teams table, okay, so it does know that, hopefully that’ll be fine.

117 00:11:22.450 ⇒ 00:11:24.420 Samuel Roberts: Yeah, I should have given it to the MCP, damn.

118 00:11:27.850 ⇒ 00:11:30.569 Samuel Roberts: I don’t see that in graph. Oh, no, no.

119 00:11:39.310 ⇒ 00:11:40.730 Samuel Roberts: Great process to exit.

120 00:11:44.700 ⇒ 00:11:48.059 Samuel Roberts: Yeah, there we go. Let’s doing it right there. That’s good.

121 00:11:51.470 ⇒ 00:11:52.450 Samuel Roberts: What?

122 00:11:53.580 ⇒ 00:11:54.789 Samuel Roberts: What did it do? Okay.

123 00:11:58.040 ⇒ 00:12:00.460 Samuel Roberts: No, I think I wanted that, actually, didn’t I?

124 00:12:02.610 ⇒ 00:12:04.270 Samuel Roberts: Yeah, we’re gonna undo this.

125 00:12:05.230 ⇒ 00:12:08.000 Samuel Roberts: No, we’ll leave it, we’ll leave it, we’ll leave it. Let’s just run it and see what happens.

126 00:12:08.610 ⇒ 00:12:10.919 Samuel Roberts: This is my new mentality with all this stuff, like, do they work?

127 00:12:11.480 ⇒ 00:12:12.570 Samuel Roberts: then I’ll inspect.

128 00:12:16.210 ⇒ 00:12:19.130 Samuel Roberts: Alright, issues for adults at all? What the hell?

129 00:12:26.360 ⇒ 00:12:27.249 Samuel Roberts: That’s what I’m looking.

130 00:12:29.130 ⇒ 00:12:35.220 Samuel Roberts: So we ignored emails… Filter…

131 00:12:37.810 ⇒ 00:12:41.949 Samuel Roberts: Union by the team table matches first, so they take precedent?

132 00:12:43.190 ⇒ 00:12:46.039 Samuel Roberts: We’re just gonna keep everything and see what happened here.

133 00:12:47.120 ⇒ 00:12:50.059 Samuel Roberts: Resolve participants via Teams table.

134 00:12:50.870 ⇒ 00:12:56.920 Samuel Roberts: When available… Oh, it is a fallback. Okay, that’s what it’s doing here.

135 00:12:58.350 ⇒ 00:13:01.890 Samuel Roberts: That’s… I guess, let’s try to run that.

136 00:13:02.310 ⇒ 00:13:05.829 Samuel Roberts: We had a… didn’t we? Yeah.

137 00:13:08.260 ⇒ 00:13:09.099 Samuel Roberts: Let’s do that.

138 00:13:31.400 ⇒ 00:13:33.900 Samuel Roberts: Oh, the screen reader, that’s what the sound is.

139 00:13:35.180 ⇒ 00:13:35.930 Samuel Roberts: Weird, okay.

140 00:13:37.910 ⇒ 00:13:40.499 Samuel Roberts: And then I need a meeting ID. I need a meeting ID.

141 00:13:46.740 ⇒ 00:13:49.030 Gabriel Lam: We could use, like, this morning’s AI stand-up.

142 00:13:49.030 ⇒ 00:13:52.270 Samuel Roberts: That’s exactly what I was gonna do, because I at least know what’s going on there, so…

143 00:13:53.380 ⇒ 00:13:54.289 Samuel Roberts: Let’s see what…

144 00:13:59.140 ⇒ 00:14:03.729 Samuel Roberts: I don’t know what this is logging, we may have to go in and make sure it logs. Oh, no, it’s probably gonna do it.

145 00:14:04.330 ⇒ 00:14:09.510 Samuel Roberts: Okay, so found everything. Didn’t log anyone, but teams in scope.

146 00:14:11.640 ⇒ 00:14:14.350 Samuel Roberts: Okay, so I probably gotta go back into here…

147 00:14:15.070 ⇒ 00:14:16.749 Samuel Roberts: And we are going to return…

148 00:14:21.410 ⇒ 00:14:22.120 Samuel Roberts: Cool.

149 00:14:22.450 ⇒ 00:14:23.340 Samuel Roberts: Whoa.

150 00:14:27.290 ⇒ 00:14:28.849 Samuel Roberts: We want name.

151 00:14:35.290 ⇒ 00:14:36.060 Samuel Roberts: again.

152 00:14:42.270 ⇒ 00:14:44.280 Samuel Roberts: Oh, hey, look at that. What do we got?

153 00:14:44.280 ⇒ 00:14:45.300 Gabriel Lam: Okay.

154 00:14:46.930 ⇒ 00:14:51.500 Samuel Roberts: Nope Yep, yep, yep. Why did it match?

155 00:14:56.760 ⇒ 00:14:59.699 Samuel Roberts: It missed Clarence and Pranan.

156 00:15:01.920 ⇒ 00:15:05.419 Samuel Roberts: Okay, we might have to dig into that function a little bit more.

157 00:15:12.200 ⇒ 00:15:15.830 Samuel Roberts: team, whereas not null. That might be an issue here, too.

158 00:15:20.580 ⇒ 00:15:21.980 Gabriel Lam: Wait, I don’t have a team.

159 00:15:22.880 ⇒ 00:15:23.720 Gabriel Lam: Or…

160 00:15:23.730 ⇒ 00:15:30.790 Samuel Roberts: No, in the team table, which is all of our names. If someone hasn’t been synced yet, it might be a problem, but…

161 00:15:31.570 ⇒ 00:15:32.290 Samuel Roberts: Let me take a look.

162 00:15:32.480 ⇒ 00:15:32.979 Samuel Roberts: I have to.

163 00:15:32.980 ⇒ 00:15:33.950 Gabriel Lam: table opened.

164 00:15:34.630 ⇒ 00:15:40.279 Samuel Roberts: Okay, yeah, I just… I’m trying to figure out… the real issue is that it found Robert, but it didn’t find…

165 00:15:42.140 ⇒ 00:15:45.000 Samuel Roberts: A knob, and it didn’t find…

166 00:15:52.410 ⇒ 00:15:56.220 Samuel Roberts: I don’t think either of them are in the Teams table.

167 00:15:56.360 ⇒ 00:15:57.490 Gabriel Lam: That’s why.

168 00:15:58.120 ⇒ 00:16:00.579 Gabriel Lam: Oh, Pranav is, but he doesn’t have a name.

169 00:16:03.350 ⇒ 00:16:06.159 Samuel Roberts: Oh, oh, oh. Does he have a linear ID?

170 00:16:06.900 ⇒ 00:16:11.380 Gabriel Lam: Let’s see… He does have a linear ID.

171 00:16:11.870 ⇒ 00:16:12.530 Samuel Roberts: Okay.

172 00:16:16.740 ⇒ 00:16:18.559 Samuel Roberts: So let’s actually just do this.

173 00:16:20.940 ⇒ 00:16:24.319 Gabriel Lam: Clarence also has one, I found it. He also has an entry.

174 00:16:24.340 ⇒ 00:16:26.530 Samuel Roberts: And he also has a linear IDP, is there?

175 00:16:26.950 ⇒ 00:16:30.639 Samuel Roberts: Alright, let’s just log the team rows that we get, and then we’ll process it.

176 00:16:40.890 ⇒ 00:16:42.469 Samuel Roberts: Oh, that’s correct, because I logged.

177 00:16:43.100 ⇒ 00:16:45.559 Samuel Roberts: - what the… oh, what?

178 00:16:45.850 ⇒ 00:16:49.419 Samuel Roberts: Oh, it’s finding everyone and then filtering, isn’t it?

179 00:16:49.780 ⇒ 00:16:50.790 Gabriel Lam: Mmm…

180 00:16:52.210 ⇒ 00:17:05.950 Samuel Roberts: Okay, well… That’s… Fine, so we’ll come down here. What do we actually build? We’re building… Pee, peep.

181 00:17:07.720 ⇒ 00:17:10.609 Samuel Roberts: Max by linear ID is what we get, so now we’re gonna…

182 00:17:14.380 ⇒ 00:17:17.310 Samuel Roberts: So that’s what we’re actually looking for. Now we’re… now we’re getting somewhere.

183 00:17:17.900 ⇒ 00:17:20.940 Samuel Roberts: It’s so different debugging code you didn’t write.

184 00:17:21.930 ⇒ 00:17:26.219 Samuel Roberts: Like, I would’ve caught… oh, of course, it’s gonna be just that stupid.

185 00:17:27.990 ⇒ 00:17:33.360 Samuel Roberts: Okay, well that’s at least 1, 2, 3, 4, 5, and we should have…

186 00:17:33.880 ⇒ 00:17:37.009 Samuel Roberts: 1, 2, 3, 4, 5, 6, 7.

187 00:17:54.060 ⇒ 00:17:55.679 Samuel Roberts: we’ve got May…

188 00:18:12.270 ⇒ 00:18:13.840 Gabriel Lam: It’s gotta be first name.

189 00:18:14.980 ⇒ 00:18:15.730 Samuel Roberts: Think about that.

190 00:18:16.620 ⇒ 00:18:20.430 Gabriel Lam: And there should be a few, nulls in there.

191 00:18:21.240 ⇒ 00:18:25.500 Samuel Roberts: Yeah, okay. How are we still getting Robert to match, though?

192 00:18:29.030 ⇒ 00:18:33.380 Samuel Roberts: Email… okay, let’s look at it. So we’re pulling out the email, first, last.

193 00:18:34.630 ⇒ 00:18:41.910 Samuel Roberts: Full, forward, full, reverse, interesting, okay. And then we’re matching against P, and P is the participant.

194 00:18:42.940 ⇒ 00:18:43.850 Samuel Roberts: It’s just…

195 00:18:52.600 ⇒ 00:18:58.699 Samuel Roberts: Samuel Roberts matched, and… Because it’s doing that furl reverse thing.

196 00:18:59.280 ⇒ 00:19:00.050 Gabriel Lam: So that’s how.

197 00:19:00.050 ⇒ 00:19:03.870 Samuel Roberts: We got Robert. Okay, so maybe let’s get rid of that, we don’t need that.

198 00:19:05.900 ⇒ 00:19:07.830 Samuel Roberts: Last included last, ask for that.

199 00:19:10.020 ⇒ 00:19:11.089 Samuel Roberts: That’s funny.

200 00:19:13.330 ⇒ 00:19:15.920 Samuel Roberts: Still matching… bumper…

201 00:19:27.160 ⇒ 00:19:30.760 Samuel Roberts: First, and P includes first.

202 00:19:32.870 ⇒ 00:19:35.010 Samuel Roberts: Participant Samuel Roberts.

203 00:19:47.150 ⇒ 00:19:51.080 Samuel Roberts: linearity… Oh…

204 00:20:04.100 ⇒ 00:20:09.619 Samuel Roberts: Okay, sorry, I’m just trying to think, why is it doing that?

205 00:20:10.260 ⇒ 00:20:18.519 Samuel Roberts: Email… Email… Email includes P, that’s it, right?

206 00:20:18.860 ⇒ 00:20:19.440 Gabriel Lam: Yeah.

207 00:20:20.180 ⇒ 00:20:26.960 Samuel Roberts: My email includes P, and P is… participant… So…

208 00:20:27.760 ⇒ 00:20:30.109 Samuel Roberts: What? Am I missing something here still?

209 00:20:35.340 ⇒ 00:20:38.100 Samuel Roberts: Let’s just keep digging.

210 00:20:43.640 ⇒ 00:20:47.800 Samuel Roberts: Okay, we did a lot. This is doing way more than I think it should. Okay.

211 00:20:48.670 ⇒ 00:20:49.790 Samuel Roberts: Participant.

212 00:20:50.460 ⇒ 00:20:55.080 Samuel Roberts: Sam Roberts. Matches false. Why is this one just…

213 00:20:55.890 ⇒ 00:20:59.569 Samuel Roberts: The email, we don’t have anything else, so match must have been…

214 00:21:02.830 ⇒ 00:21:06.750 Samuel Roberts: Action… Automate.

215 00:21:06.960 ⇒ 00:21:09.540 Samuel Roberts: Didn’t even log that.

216 00:21:11.040 ⇒ 00:21:13.820 Samuel Roberts: Oh, because we’re doing a continue here, right?

217 00:21:19.260 ⇒ 00:21:22.200 Samuel Roberts: So maybe there’s something missing here that I’m not catching.

218 00:21:24.200 ⇒ 00:21:27.240 Samuel Roberts: Alright, we don’t need to do all this, so this is not how I would have done this.

219 00:21:29.340 ⇒ 00:21:30.820 Samuel Roberts: Wednesday…

220 00:21:33.910 ⇒ 00:21:39.599 Samuel Roberts: Alright, so what do we really need to do here? We find the participants, and we want to look up their linear IDs in the Teams table, right?

221 00:21:39.600 ⇒ 00:21:40.180 Gabriel Lam: Yup.

222 00:21:40.900 ⇒ 00:21:42.450 Samuel Roberts: So I’m gonna say…

223 00:21:48.920 ⇒ 00:21:52.999 Samuel Roberts: No. That’s wrong. I’ll just tell him it’s wrong, I guess.

224 00:22:06.170 ⇒ 00:22:12.070 Samuel Roberts: For this function… We can use the…

225 00:22:16.220 ⇒ 00:22:25.900 Samuel Roberts: Participants… Hooray… to look up… each part.

226 00:22:40.320 ⇒ 00:22:42.949 Samuel Roberts: Alright, well, we’ll see if this… Does it?

227 00:22:44.350 ⇒ 00:22:47.169 Samuel Roberts: Man, my cursor’s doing so much thinking today.

228 00:22:48.590 ⇒ 00:22:51.220 Samuel Roberts: It was literally spinning for, like, 2 minutes on another one.

229 00:22:51.900 ⇒ 00:22:54.860 Gabriel Lam: I hope you don’t run out of tokens today.

230 00:22:55.680 ⇒ 00:22:56.600 Samuel Roberts: Oh, that’d be rough.

231 00:22:56.790 ⇒ 00:23:00.450 Samuel Roberts: I’m trying to use auto, so I’m hoping it’s, like, prioritizing certain things.

232 00:23:00.450 ⇒ 00:23:01.360 Gabriel Lam: Bam.

233 00:23:03.040 ⇒ 00:23:04.639 Samuel Roberts: It’s doing a lot of thinking.

234 00:23:10.410 ⇒ 00:23:11.200 Samuel Roberts: Right.

235 00:23:16.170 ⇒ 00:23:16.940 Samuel Roberts: Did it.

236 00:23:17.500 ⇒ 00:23:18.979 Gabriel Lam: It didn’t do anything.

237 00:23:19.560 ⇒ 00:23:20.740 Samuel Roberts: Why?

238 00:23:29.860 ⇒ 00:23:31.460 Samuel Roberts: That’s not at all.

239 00:23:32.040 ⇒ 00:23:32.750 Samuel Roberts: Okay.

240 00:23:33.380 ⇒ 00:23:35.499 Samuel Roberts: You’re gonna make me write code cursor? Come on.

241 00:23:37.990 ⇒ 00:23:40.770 Samuel Roberts: Okay, so we’ll do this from Team, select…

242 00:23:46.930 ⇒ 00:23:51.059 Samuel Roberts: Select… We want…

243 00:23:52.450 ⇒ 00:23:56.900 Samuel Roberts: I don’t know what participants it’s coming in at, so let’s just log that real quick.

244 00:24:04.150 ⇒ 00:24:05.530 Samuel Roberts: Where is this getting called?

245 00:24:10.790 ⇒ 00:24:16.240 Samuel Roberts: Participants is just an array of names. It’s probably full name, I guess?

246 00:24:43.180 ⇒ 00:24:44.939 Samuel Roberts: Oh, I must have left something.

247 00:24:48.350 ⇒ 00:24:50.689 Samuel Roberts: Even if it never gets to the island, it wouldn’t do it.

248 00:25:00.560 ⇒ 00:25:04.859 Samuel Roberts: This is an issue that we also should keep in mind in general.

249 00:25:06.200 ⇒ 00:25:10.550 Samuel Roberts: I don’t like how we match participants to the Teams table.

250 00:25:10.840 ⇒ 00:25:12.010 Samuel Roberts: Sometimes?

251 00:25:12.740 ⇒ 00:25:17.030 Samuel Roberts: Because it’s all based on, like, if I change my name, on Zoom.

252 00:25:18.190 ⇒ 00:25:19.219 Gabriel Lam: Bro, it doesn’t.

253 00:25:19.730 ⇒ 00:25:24.600 Samuel Roberts: it’ll, like, if I make my name Sam, which I’ve been wanting to do, because on client calls, I don’t…

254 00:25:24.730 ⇒ 00:25:27.530 Samuel Roberts: I need it to be Samuel, but…

255 00:25:27.680 ⇒ 00:25:32.299 Samuel Roberts: it would show up here as Sam, and then when I try to match it to the Teams table, it might not match.

256 00:25:32.610 ⇒ 00:25:36.620 Gabriel Lam: So, is it better to… Match by email, because that probably.

257 00:25:36.620 ⇒ 00:25:38.529 Samuel Roberts: almost changed. Almost definitely?

258 00:25:38.530 ⇒ 00:25:39.220 Gabriel Lam: And then…

259 00:25:39.220 ⇒ 00:25:40.300 Samuel Roberts: Emails you look up.

260 00:25:40.300 ⇒ 00:25:43.430 Gabriel Lam: Yeah, also people who have… Yeah.

261 00:25:44.780 ⇒ 00:25:46.869 Samuel Roberts: That would definitely be the best case, I think.

262 00:25:49.030 ⇒ 00:25:50.120 Samuel Roberts: Okay, let’s do it.

263 00:25:53.120 ⇒ 00:25:54.060 Samuel Roberts: Oh, boy.

264 00:25:56.490 ⇒ 00:26:00.439 Samuel Roberts: Use the participants.

265 00:26:04.140 ⇒ 00:26:08.660 Samuel Roberts: Alright, 26… for…

266 00:26:12.220 ⇒ 00:26:14.040 Samuel Roberts: Let’s see if it doesn’t really know.

267 00:26:15.630 ⇒ 00:26:17.099 Samuel Roberts: Nope, it doesn’t know what I’m talking about.

268 00:26:19.920 ⇒ 00:26:26.750 Samuel Roberts: You still wanna do that. You want to do where… In email… no, in…

269 00:26:28.380 ⇒ 00:26:31.699 Samuel Roberts: Here’s the issue. We got first name, last name. Do we have a full name?

270 00:26:32.910 ⇒ 00:26:33.340 Gabriel Lam: We don’t.

271 00:26:33.860 ⇒ 00:26:35.649 Gabriel Lam: Split into first name and last name.

272 00:26:36.260 ⇒ 00:26:37.460 Samuel Roberts: Of course it is, okay.

273 00:26:38.560 ⇒ 00:26:40.740 Samuel Roberts: So we’re gonna do this. We’re gonna do…

274 00:26:40.860 ⇒ 00:26:44.789 Samuel Roberts: I don’t like this, this is a little hacky, and remember, we’re doing this when it breaks later.

275 00:26:46.190 ⇒ 00:26:54.300 Samuel Roberts: Names… equals… No, no, what are you doing?

276 00:26:57.590 ⇒ 00:27:00.520 Samuel Roberts: No, that’s not gonna be good, is it?

277 00:27:10.250 ⇒ 00:27:11.969 Samuel Roberts: Alright, now let’s just keep going.

278 00:27:14.550 ⇒ 00:27:16.969 Samuel Roberts: Participants don’t have P dot…

279 00:27:20.840 ⇒ 00:27:23.230 Samuel Roberts: Split.nap… okay, there we go.

280 00:27:23.590 ⇒ 00:27:24.699 Samuel Roberts: That’s what we’re looking for.

281 00:27:29.320 ⇒ 00:27:30.800 Samuel Roberts: Yeah, cool.

282 00:27:42.320 ⇒ 00:27:48.610 Gabriel Lam: But that’s still looking for… filtering via names, right?

283 00:27:49.470 ⇒ 00:27:52.880 Samuel Roberts: Yes, I think that’s the only way to do it right now. We’d have to change how we’re pulling things from…

284 00:28:01.190 ⇒ 00:28:01.919 Samuel Roberts: I’m trying to say.

285 00:28:03.740 ⇒ 00:28:06.870 Gabriel Lam: Oh, because the participants is pulling names and not emails.

286 00:28:07.160 ⇒ 00:28:09.519 Samuel Roberts: Yeah, so at some point, we should… that’s, like…

287 00:28:10.670 ⇒ 00:28:27.880 Samuel Roberts: I’m gonna tell you, so I don’t have to remember, but at some point, we need to update the way we do this, so that… I don’t know exactly how that works from Zoom, or from Zoom, but if we could match to emails, or even, like, a Zoom ID, or whatever it is that we could store in the table, but I think emails would be the best thing.

288 00:28:28.070 ⇒ 00:28:34.069 Samuel Roberts: That’s a whole other… like… Because there’s a participants table, I think, in Superbase too, right?

289 00:28:36.020 ⇒ 00:28:40.620 Samuel Roberts: There was… oh, no, I think we just store them, it’s not…

290 00:28:40.730 ⇒ 00:28:43.150 Samuel Roberts: The way participants are stored is bad.

291 00:28:43.820 ⇒ 00:28:46.459 Samuel Roberts: Like, if I go…

292 00:28:47.010 ⇒ 00:28:51.569 Samuel Roberts: to Zoom, this might be a good context for you in general, so… I always do that.

293 00:28:51.750 ⇒ 00:28:56.809 Samuel Roberts: we have… all these meetings, we just have a big participant.

294 00:28:56.810 ⇒ 00:28:58.840 Gabriel Lam: Oh, I see.

295 00:28:58.840 ⇒ 00:29:02.409 Samuel Roberts: It’s just been everyone who’s ever been in a Zoom meeting

296 00:29:03.710 ⇒ 00:29:07.610 Samuel Roberts: you know, 5,221 rows. Like, that’s not…

297 00:29:08.010 ⇒ 00:29:10.610 Samuel Roberts: a good way to do it.

298 00:29:13.280 ⇒ 00:29:24.039 Samuel Roberts: But… it’s working for now, so, you know, at some point we need to re-architect that a little bit. Like, it does store the email, so I guess that’s a good thing that we… it must be coming from Zoom some way, but if we can…

299 00:29:24.180 ⇒ 00:29:25.590 Samuel Roberts: Use that better.

300 00:29:26.470 ⇒ 00:29:32.140 Samuel Roberts: That would be… Smarter.

301 00:29:33.370 ⇒ 00:29:34.500 Samuel Roberts: Let’s turn back here.

302 00:29:34.500 ⇒ 00:29:40.950 Gabriel Lam: I guess for this, is there a way to just sort of circumvent that and, like, pull directly… not.

303 00:29:41.060 ⇒ 00:29:47.099 Gabriel Lam: from… Oh, wait a minute. Oh, because Participants is pulling from Zoom.

304 00:29:48.310 ⇒ 00:29:53.849 Samuel Roberts: Yeah, the meeting ID is getting it, so we need to make sure that the meeting ID, load meeting…

305 00:29:55.070 ⇒ 00:29:58.929 Samuel Roberts: participants comes from this fetch meeting, let’s just see…

306 00:29:59.130 ⇒ 00:30:08.059 Samuel Roberts: the Zoom meeting recorded files, and that includes participants, but I think that’s where we’re only storing the name. So if I look at this table…

307 00:30:10.870 ⇒ 00:30:12.280 Samuel Roberts: Oops, that’s alright.

308 00:30:14.520 ⇒ 00:30:20.500 Samuel Roberts: So if I go here… I think here, Participants is just a big ol’ list of names.

309 00:30:20.500 ⇒ 00:30:21.150 Gabriel Lam: Yup.

310 00:30:21.940 ⇒ 00:30:23.710 Samuel Roberts: That’s where we want to change it to.

311 00:30:25.000 ⇒ 00:30:28.780 Samuel Roberts: So when we write to… the…

312 00:30:30.060 ⇒ 00:30:35.540 Samuel Roberts: meetings, recordings, files. We probably want, like, participant emails as a new column or something.

313 00:30:35.540 ⇒ 00:30:36.330 Gabriel Lam: Yup.

314 00:30:37.120 ⇒ 00:30:41.440 Samuel Roberts: And that way, this will still work, but we can just add the emails.

315 00:30:41.650 ⇒ 00:30:43.080 Samuel Roberts: And then we could even…

316 00:30:44.490 ⇒ 00:30:44.990 Gabriel Lam: how much of.

317 00:30:44.990 ⇒ 00:30:45.680 Samuel Roberts: I lived with that.

318 00:30:45.680 ⇒ 00:30:47.080 Gabriel Lam: B, just to…

319 00:30:47.540 ⇒ 00:30:50.650 Samuel Roberts: I would talk to Casey.

320 00:30:50.650 ⇒ 00:30:51.010 Gabriel Lam: Okay.

321 00:30:51.010 ⇒ 00:31:00.130 Samuel Roberts: I don’t think it would be crazy, especially if participants is getting written somewhere, and the emails are coming from Zoom. It’s probably just part of the pipeline for what.

322 00:31:00.130 ⇒ 00:31:00.490 Gabriel Lam: Yeah.

323 00:31:00.490 ⇒ 00:31:01.410 Samuel Roberts: I put in here.

324 00:31:01.410 ⇒ 00:31:01.820 Gabriel Lam: Yeah.

325 00:31:01.820 ⇒ 00:31:07.589 Samuel Roberts: He would just have to add a, like, participant’s email, even just for now, just a participant’s email.

326 00:31:08.050 ⇒ 00:31:14.929 Samuel Roberts: JSONB, and just store it that way. That way, we can at least look up by email. But realistically, they should have a, like.

327 00:31:16.130 ⇒ 00:31:22.610 Samuel Roberts: participants… IDs that references this table.

328 00:31:26.050 ⇒ 00:31:26.560 Samuel Roberts: But that.

329 00:31:26.560 ⇒ 00:31:27.209 Gabriel Lam: Also, it was weird.

330 00:31:27.210 ⇒ 00:31:32.330 Samuel Roberts: Because the team is different than participants, so, like, just storing the emails is probably the best bet for now.

331 00:31:33.950 ⇒ 00:31:38.180 Samuel Roberts: So I would say that’s… that’s the best thing to do.

332 00:31:38.180 ⇒ 00:31:39.139 Gabriel Lam: Let me.

333 00:31:39.140 ⇒ 00:31:40.100 Samuel Roberts: medium term.

334 00:31:40.470 ⇒ 00:31:47.400 Samuel Roberts: So… But for now, I’m not gonna be able to get emails, so that’s a… oop.

335 00:31:47.400 ⇒ 00:31:51.469 Gabriel Lam: Alright, let me just tag Casey at platform.

336 00:31:51.890 ⇒ 00:31:55.889 Samuel Roberts: How much of a lifter would it be to…

337 00:32:02.950 ⇒ 00:32:05.890 Samuel Roberts: Wait… Oh, no, if I close out what I’m fine.

338 00:32:17.190 ⇒ 00:32:18.969 Samuel Roberts: First name…

339 00:32:33.750 ⇒ 00:32:36.130 Samuel Roberts: Just can’t even think straight. It’s still Friday.

340 00:33:06.750 ⇒ 00:33:10.590 Gabriel Lam: But I guess, like, how is it that… they…

341 00:33:10.970 ⇒ 00:33:15.739 Gabriel Lam: you know, for example, Pranav doesn’t have a name on… on Teams.

342 00:33:15.740 ⇒ 00:33:16.230 Samuel Roberts: Love it.

343 00:33:16.230 ⇒ 00:33:18.400 Gabriel Lam: His name shows up at Participants.

344 00:33:20.150 ⇒ 00:33:21.650 Gabriel Lam: Oh no, what happened?

345 00:33:22.620 ⇒ 00:33:27.059 Samuel Roberts: because participants… comes from Zoom, so he has a.

346 00:33:27.060 ⇒ 00:33:29.079 Gabriel Lam: I see, he hasn’t even on Zoom, and he’s just taken that.

347 00:33:29.080 ⇒ 00:33:32.889 Samuel Roberts: And when Zoom saves to the table, that’s… yeah, and the Teams table and the.

348 00:33:32.890 ⇒ 00:33:33.240 Gabriel Lam: Yeah.

349 00:33:33.240 ⇒ 00:33:34.840 Samuel Roberts: Since they don’t talk at all.

350 00:33:36.700 ⇒ 00:33:40.920 Samuel Roberts: Oh, gosh.

351 00:33:46.000 ⇒ 00:33:51.570 Samuel Roberts: Let’s see what happens here… All participants, or…

352 00:34:00.230 ⇒ 00:34:03.709 Samuel Roberts: I knew it was going to be something more complicated over conditions, that’s what it was.

353 00:34:06.340 ⇒ 00:34:10.169 Samuel Roberts: It’s so fun, because, like, my SQL knowledge is… ugh.

354 00:34:11.949 ⇒ 00:34:18.040 Samuel Roberts: Is, like, decent enough, but then when you have to get into this, like, weird superbase syntax, it’s even worse.

355 00:34:18.040 ⇒ 00:34:18.769 Gabriel Lam: Oh, yeah.

356 00:34:19.170 ⇒ 00:34:24.519 Gabriel Lam: I’ve decided not to think about that. I’m just like, let me use cursor to translate.

357 00:34:24.520 ⇒ 00:34:29.289 Samuel Roberts: Exactly, so I mean, that’s why I was just like, I don’t want to think about things. I know there’s an OR or something I need to do.

358 00:34:30.400 ⇒ 00:34:35.840 Samuel Roberts: And first name equals single, last name equals Roberts. And… why are those all ANDs?

359 00:34:41.739 ⇒ 00:34:42.659 Samuel Roberts: Travel alone.

360 00:34:52.230 ⇒ 00:34:54.270 Samuel Roberts: That’s not working, okay.

361 00:35:00.060 ⇒ 00:35:02.759 Samuel Roberts: Hmm, okay. Let’s just ask her.

362 00:35:14.520 ⇒ 00:35:15.500 Samuel Roberts: She’s told that.

363 00:35:34.080 ⇒ 00:35:37.769 Samuel Roberts: Case sensitive, I like, of course, of course.

364 00:35:38.280 ⇒ 00:35:44.190 Samuel Roberts: I want this, we’re gonna undo that, we’re gonna keep that, and keep… I just was doing this for the other thing I was working on, too.

365 00:35:46.370 ⇒ 00:35:48.209 Samuel Roberts: Doing equals versus I like.

366 00:35:53.680 ⇒ 00:35:54.270 Samuel Roberts: Huh?

367 00:35:54.270 ⇒ 00:35:56.019 Gabriel Lam: Oh, got rid of the console.

368 00:35:56.510 ⇒ 00:35:57.530 Gabriel Lam: logs.

369 00:36:00.090 ⇒ 00:36:02.260 Samuel Roberts: Mmm… Oh, I think it…

370 00:36:03.280 ⇒ 00:36:07.699 Samuel Roberts: No, they’re here, why did it not cross up? Did something fail that was gonna happen here?

371 00:36:08.190 ⇒ 00:36:11.070 Samuel Roberts: Failed to fetch issues for Team Reed.

372 00:36:15.020 ⇒ 00:36:16.679 Samuel Roberts: Oh, I didn’t say it.

373 00:36:23.770 ⇒ 00:36:24.760 Samuel Roberts: Okay.

374 00:36:25.880 ⇒ 00:36:27.100 Samuel Roberts: progress.

375 00:36:29.330 ⇒ 00:36:31.829 Samuel Roberts: So my name is probably Sam in the database, isn’t it?

376 00:36:36.050 ⇒ 00:36:38.430 Gabriel Lam: Hmm… Let me take a look.

377 00:36:51.260 ⇒ 00:36:53.569 Gabriel Lam: In the teams, or in the participants?

378 00:36:53.570 ⇒ 00:36:55.250 Samuel Roberts: Yeah, it’s Teams, okay.

379 00:36:56.250 ⇒ 00:36:59.080 Samuel Roberts: Well, that’s… see, this is… this is exactly the problem, like…

380 00:36:59.500 ⇒ 00:37:02.810 Samuel Roberts: It’s just hard to match everything. Okay.

381 00:37:04.440 ⇒ 00:37:05.410 Samuel Roberts: Okay.

382 00:37:08.160 ⇒ 00:37:09.250 Samuel Roberts: Okay.

383 00:37:10.140 ⇒ 00:37:12.950 Samuel Roberts: Oh, what time are we at? 1.30? Okay.

384 00:37:27.640 ⇒ 00:37:31.179 Samuel Roberts: Trying to think of how important this is to getting the teams coaching.

385 00:37:31.280 ⇒ 00:37:36.339 Samuel Roberts: For the, the teams, the clients that we’re trying to match to, the linear teams.

386 00:37:36.870 ⇒ 00:37:37.779 Samuel Roberts: Too many team.

387 00:37:52.410 ⇒ 00:37:57.759 Gabriel Lam: Would it be diffic- too difficult to… What would it… Sorry, what if we…

388 00:37:58.650 ⇒ 00:38:05.230 Gabriel Lam: From the participants, then look up the participants table to look up emails, and then use those emails.

389 00:38:05.800 ⇒ 00:38:06.950 Gabriel Lam: I feel like it’s a…

390 00:38:06.950 ⇒ 00:38:08.870 Samuel Roberts: awful way to do it.

391 00:38:09.170 ⇒ 00:38:13.519 Samuel Roberts: That is a terrible, terrible idea that we’re gonna do.

392 00:38:13.980 ⇒ 00:38:17.130 Samuel Roberts: That’s… oh my gosh. Okay, hold on, let’s…

393 00:38:17.740 ⇒ 00:38:21.579 Gabriel Lam: It’s, like, an additional step that really doesn’t need to be done, but…

394 00:38:21.650 ⇒ 00:38:24.350 Samuel Roberts: No, but it does at this point. But it works?

395 00:38:24.470 ⇒ 00:38:32.180 Samuel Roberts: like, let’s see real quick here, if I try to filter… I wanna say… Where I think is…

396 00:38:39.430 ⇒ 00:38:40.180 Samuel Roberts: What?

397 00:38:40.750 ⇒ 00:38:42.029 Samuel Roberts: Am I not in here?

398 00:38:46.710 ⇒ 00:38:47.529 Gabriel Lam: Oh, wow.

399 00:38:47.530 ⇒ 00:38:48.570 Samuel Roberts: It hasn’t been updated.

400 00:38:48.570 ⇒ 00:38:49.410 Gabriel Lam: spot. Okay.

401 00:38:51.060 ⇒ 00:38:53.679 Gabriel Lam: Why is… is this HubSpot? No.

402 00:38:54.070 ⇒ 00:39:00.190 Samuel Roberts: No, that’s just storing that idea. I think we’re generating those names when we’re, like, zooming stuff. I see what you’re saying, though, but…

403 00:39:00.490 ⇒ 00:39:04.270 Samuel Roberts: Alright, now we’re gonna sort by… Is this even getting updated?

404 00:39:07.080 ⇒ 00:39:08.250 Samuel Roberts: 72.

405 00:39:08.490 ⇒ 00:39:09.930 Samuel Roberts: 718, maybe…

406 00:39:13.080 ⇒ 00:39:15.230 Samuel Roberts: Oh, hold on, so we’re only looking at styles.

407 00:39:16.840 ⇒ 00:39:19.139 Samuel Roberts: Sorted by… created at.

408 00:39:19.920 ⇒ 00:39:23.180 Samuel Roberts: 718… 30 degrees right.

409 00:39:28.930 ⇒ 00:39:31.210 Samuel Roberts: That’s all the same day?

410 00:39:34.220 ⇒ 00:39:36.239 Samuel Roberts: Okay, this is not even being used.

411 00:39:36.900 ⇒ 00:39:38.720 Samuel Roberts: We must not be writing to this anymore.

412 00:39:41.530 ⇒ 00:39:42.220 Gabriel Lam: Right.

413 00:39:42.970 ⇒ 00:39:49.760 Samuel Roberts: If they’re all written… One day in 2025. There’s no way.

414 00:39:51.870 ⇒ 00:39:53.309 Samuel Roberts: And then at this point, we should just…

415 00:39:54.010 ⇒ 00:39:57.400 Gabriel Lam: What if we just… I don’t know if we should delete this table?

416 00:39:58.530 ⇒ 00:40:00.170 Samuel Roberts: I am so scared to do that.

417 00:40:05.400 ⇒ 00:40:06.250 Samuel Roberts: Okay.

418 00:40:07.560 ⇒ 00:40:10.279 Samuel Roberts: Maybe this was just a… maybe this was just synced from HubSpot.

419 00:40:10.960 ⇒ 00:40:12.480 Gabriel Lam: Yeah, I think so.

420 00:40:13.590 ⇒ 00:40:15.109 Samuel Roberts: Okay, so that’s not helpful, okay.

421 00:40:15.650 ⇒ 00:40:19.759 Samuel Roberts: This is… we’re finding all the little cracks where things are…

422 00:40:20.020 ⇒ 00:40:26.709 Samuel Roberts: Not architected right to begin with right now. Okay, so let’s say… oop, let’s say that’s not the plan then.

423 00:40:31.150 ⇒ 00:40:37.030 Samuel Roberts: I’m gonna say we need Casey to put those emails in, and that’s the best thing to do.

424 00:40:40.210 ⇒ 00:40:41.300 Gabriel Lam: Alright.

425 00:40:42.280 ⇒ 00:40:43.709 Gabriel Lam: Let me see if he’s there.

426 00:40:45.190 ⇒ 00:40:46.709 Gabriel Lam: Let me see if he’s online.

427 00:40:47.220 ⇒ 00:40:52.630 Samuel Roberts: Okay, yeah, not the, like… I’m trying to think if there’s another way forward before that, but…

428 00:40:55.140 ⇒ 00:40:56.209 Samuel Roberts: I’m not sure.

429 00:41:19.120 ⇒ 00:41:24.789 Gabriel Lam: The other option, which probably is not much better, which is PE, to look up…

430 00:41:26.980 ⇒ 00:41:28.060 Samuel Roberts: Hmm.

431 00:41:28.280 ⇒ 00:41:29.660 Gabriel Lam: No, nevermind.

432 00:41:32.840 ⇒ 00:41:34.530 Samuel Roberts: You try by last name?

433 00:41:35.470 ⇒ 00:41:40.625 Gabriel Lam: But I don’t think that gets around the… Yum…

434 00:41:44.620 ⇒ 00:41:46.670 Gabriel Lam: The null values.

435 00:41:47.920 ⇒ 00:41:49.270 Samuel Roberts: Oh, right.

436 00:41:50.620 ⇒ 00:41:52.729 Samuel Roberts: Okay, we could do something really crazy.

437 00:41:53.840 ⇒ 00:41:58.400 Samuel Roberts: We can parse the email, like, look up into the emails field.

438 00:42:04.610 ⇒ 00:42:08.180 Samuel Roberts: We could also just take everyone’s name and put them in, too.

439 00:42:08.760 ⇒ 00:42:09.800 Samuel Roberts: Oh my god.

440 00:42:10.770 ⇒ 00:42:11.750 Samuel Roberts: I don’t know.

441 00:42:12.730 ⇒ 00:42:13.410 Samuel Roberts: Let’s here.

442 00:42:15.130 ⇒ 00:42:21.680 Samuel Roberts: The best plan is to step back and probably rethink a little bit of the stuff as we’re finding it all, and try to figure out the…

443 00:42:21.940 ⇒ 00:42:27.550 Samuel Roberts: Right way to do it, but… That’s not,

444 00:42:28.340 ⇒ 00:42:31.829 Samuel Roberts: Why is the first thing not getting pulled? Wait, hold on, wait a minute, that’s a good question, like…

445 00:42:32.560 ⇒ 00:42:35.080 Samuel Roberts: Slack ID, so she also doesn’t have.

446 00:42:37.430 ⇒ 00:42:40.300 Samuel Roberts: linear ID he has, but he should definitely have a Slack ID.

447 00:42:40.880 ⇒ 00:42:42.000 Samuel Roberts: So it should print off.

448 00:42:43.630 ⇒ 00:42:44.490 Samuel Roberts: people.

449 00:42:47.680 ⇒ 00:42:50.090 Gabriel Lam: But… Do they not?

450 00:42:50.570 ⇒ 00:42:52.270 Samuel Roberts: I’m wondering what’s happening here.

451 00:42:52.720 ⇒ 00:42:54.959 Samuel Roberts: That’s exactly… something else is going on, yeah, we’re…

452 00:42:56.210 ⇒ 00:42:58.269 Samuel Roberts: We’re really getting down to it.

453 00:43:08.140 ⇒ 00:43:10.119 Gabriel Lam: So let me just invite.

454 00:43:11.010 ⇒ 00:43:12.439 Samuel Roberts: What? Oh, no, here we go.

455 00:43:12.440 ⇒ 00:43:13.560 Gabriel Lam: Invite, Casey.

456 00:43:26.900 ⇒ 00:43:28.069 Samuel Roberts: That’s not good.

457 00:43:43.800 ⇒ 00:43:44.550 Samuel Roberts: We’ll just…

458 00:43:49.950 ⇒ 00:43:53.850 Samuel Roberts: Sync44, deactivated 12. Okay. Alright, Casey’s coming in.

459 00:43:53.980 ⇒ 00:43:55.310 Gabriel Lam: Should be hopping on in a minute.

460 00:43:55.310 ⇒ 00:43:58.299 Samuel Roberts: That just synced everyone’s names, so this is… that is not running.

461 00:43:59.010 ⇒ 00:43:59.830 Gabriel Lam: Okay.

462 00:44:00.830 ⇒ 00:44:03.150 Samuel Roberts: I just synced everyone’s names from Google.

463 00:44:04.460 ⇒ 00:44:07.050 Gabriel Lam: And Pranav is still… missing.

464 00:44:08.530 ⇒ 00:44:10.850 Gabriel Lam: Is there a Slack sync that needs to happen?

465 00:44:11.170 ⇒ 00:44:13.879 Samuel Roberts: Slack, yes, that’s another one, I was just… I hadn’t done that yet.

466 00:44:15.520 ⇒ 00:44:16.270 Gabriel Lam: Hello.

467 00:44:16.270 ⇒ 00:44:17.570 Samuel Roberts: Jump into… okay.

468 00:44:18.680 ⇒ 00:44:19.720 Samuel Roberts: So is this not happening?

469 00:44:19.720 ⇒ 00:44:20.410 Casie Aviles: I mean…

470 00:44:23.400 ⇒ 00:44:29.420 Samuel Roberts: Hey… Okay, so maybe these are not… yep, that’s exactly what’s going on here. What the heck?

471 00:44:32.050 ⇒ 00:44:32.480 Gabriel Lam: So…

472 00:44:32.480 ⇒ 00:44:38.129 Samuel Roberts: So those just synced. Did it sync SlackID? They did not sync with SlackID for a few people.

473 00:44:39.780 ⇒ 00:44:43.479 Gabriel Lam: Just to catch you up, Casey, one thing we were looking at was how…

474 00:44:43.870 ⇒ 00:44:46.820 Gabriel Lam: The linear tickets are being matched to people.

475 00:44:47.180 ⇒ 00:44:50.060 Gabriel Lam: Right now, they’re being matched to…

476 00:44:51.110 ⇒ 00:44:56.759 Gabriel Lam: like, meeting participant names, so what you see on the platform, like, the Zoom names get captured.

477 00:44:57.550 ⇒ 00:45:05.419 Gabriel Lam: And that’s being matched to, like, people’s linear teams, we’re realizing it’s… A lot better to…

478 00:45:06.000 ⇒ 00:45:08.390 Gabriel Lam: Do it through matching emails.

479 00:45:08.760 ⇒ 00:45:09.319 Casie Aviles: Yeah, we can.

480 00:45:09.480 ⇒ 00:45:14.150 Gabriel Lam: filter out, like, any Brain4G emails, and then… people…

481 00:45:14.740 ⇒ 00:45:26.170 Gabriel Lam: in the Teams table, like, some people don’t have names on their Teams table. It’s just, like, their email. So, like, Pranav, for example, is… is it null now? Or… no, it’s there, okay.

482 00:45:26.170 ⇒ 00:45:27.910 Samuel Roberts: Nope, it’s good, now we got it. We got it!

483 00:45:27.910 ⇒ 00:45:28.460 Gabriel Lam: Okay.

484 00:45:28.460 ⇒ 00:45:35.609 Samuel Roberts: So, for some reason, this is not updating every evening, like, or every morning, like it should. Yeah. The other thing is, like… That’s fine, I can…

485 00:45:35.950 ⇒ 00:45:41.919 Gabriel Lam: Sam’s name is different on Zoom versus… Slack. So…

486 00:45:41.920 ⇒ 00:45:42.370 Casie Aviles: Hmm.

487 00:45:42.570 ⇒ 00:45:52.279 Gabriel Lam: things that should go to Sam are not getting picked up, and so we were wondering, okay, can we add, like, another column on the team… on the Zoom recording table?

488 00:45:52.720 ⇒ 00:45:58.560 Gabriel Lam: to include the Zoom persons… Email.

489 00:46:00.730 ⇒ 00:46:01.400 Casie Aviles: how much.

490 00:46:01.400 ⇒ 00:46:03.890 Gabriel Lam: How hard would that be, basically?

491 00:46:06.170 ⇒ 00:46:09.220 Casie Aviles: Yeah… oh yeah, okay, we can… yeah, we can get it.

492 00:46:09.440 ⇒ 00:46:10.050 Casie Aviles: I was just checking.

493 00:46:10.050 ⇒ 00:46:10.760 Samuel Roberts: Yeah, my thoughts…

494 00:46:10.760 ⇒ 00:46:11.630 Casie Aviles: right now.

495 00:46:12.310 ⇒ 00:46:12.990 Samuel Roberts: Okay.

496 00:46:12.990 ⇒ 00:46:15.069 Gabriel Lam: My thought is basically…

497 00:46:15.470 ⇒ 00:46:17.920 Samuel Roberts: When we write the…

498 00:46:21.650 ⇒ 00:46:22.990 Samuel Roberts: Is it this one?

499 00:46:24.440 ⇒ 00:46:25.010 Gabriel Lam: Yeah.

500 00:46:25.190 ⇒ 00:46:31.580 Samuel Roberts: Let’s just add another… column, maybe? That’s just participant emails.

501 00:46:33.410 ⇒ 00:46:36.879 Samuel Roberts: Just like we do with this, and then we can just parse that JSON later.

502 00:46:40.800 ⇒ 00:46:49.849 Casie Aviles: Yeah, I also mentioned to Gabe that I think the challenge should be for older meetings, we might not be able to backfill some of them.

503 00:46:50.510 ⇒ 00:46:53.880 Samuel Roberts: I think that’s… Probably fine.

504 00:46:54.350 ⇒ 00:46:58.330 Gabriel Lam: I think that’s fine, we just need one meeting for testing.

505 00:46:58.330 ⇒ 00:47:02.719 Samuel Roberts: Well, yeah, we could figure that out, too, if we needed to just do that, but I think the best thing is

506 00:47:03.760 ⇒ 00:47:09.719 Samuel Roberts: Going forward, like, the linear tickets shouldn’t be really probably generated from old meetings as often as new meetings anyway.

507 00:47:11.130 ⇒ 00:47:11.760 Gabriel Lam: Yeah.

508 00:47:12.270 ⇒ 00:47:16.750 Samuel Roberts: So, I think that’s fine. And in fact, I might just make that new column now.

509 00:47:21.590 ⇒ 00:47:29.390 Samuel Roberts: I’ll call it… Participants email. Participants… participant emails.

510 00:47:32.260 ⇒ 00:47:36.269 Gabriel Lam: I think it should be participants, generally, just for consistency.

511 00:47:37.350 ⇒ 00:47:37.780 Samuel Roberts: What works a week.

512 00:47:37.780 ⇒ 00:47:38.130 Gabriel Lam: support.

513 00:47:38.130 ⇒ 00:47:38.600 Samuel Roberts: participants.

514 00:47:38.600 ⇒ 00:47:39.640 Gabriel Lam: It’s a little…

515 00:47:40.670 ⇒ 00:47:46.450 Samuel Roberts: You’re right, you’re right, that’s totally fine. Alright, so then it’s gonna be a JSON… B…

516 00:47:48.060 ⇒ 00:47:52.049 Samuel Roberts: Not an array… we’ll just do the JSONB, right?

517 00:47:55.080 ⇒ 00:47:58.069 Samuel Roberts: Allow nullable is not unique. Okay, I think that’s fine.

518 00:48:07.980 ⇒ 00:48:10.459 Samuel Roberts: Can I just… did it do it? Yeah.

519 00:48:12.960 ⇒ 00:48:20.160 Samuel Roberts: Okay, so yeah, I think what we can do then is probably pull everyone’s emails and just write that one for now.

520 00:48:22.190 ⇒ 00:48:26.399 Samuel Roberts: And then… Casey, if you can update the…

521 00:48:28.330 ⇒ 00:48:33.999 Samuel Roberts: or… to just include… an array of emails from Zoom. I think that would…

522 00:48:34.960 ⇒ 00:48:37.819 Gabriel Lam: Is there a way for us to, like, just write into one cell?

523 00:48:37.820 ⇒ 00:48:39.169 Samuel Roberts: That’s what I’m about to do, yeah.

524 00:48:41.510 ⇒ 00:48:42.999 Samuel Roberts: We’re gonna just pull these.

525 00:48:46.590 ⇒ 00:48:53.829 Samuel Roberts: Let’s do this real quick. Okay, however, what are you gonna do?

526 00:48:55.300 ⇒ 00:48:57.129 Samuel Roberts: I’m gonna do it the old-fashioned way.

527 00:49:05.410 ⇒ 00:49:06.340 Samuel Roberts: Heading.

528 00:49:07.190 ⇒ 00:49:09.809 Samuel Roberts: And then going to… that’s not what I meant to do.

529 00:49:11.920 ⇒ 00:49:19.400 Samuel Roberts: We’re going to come to here, and we’re going to find… Oh, of course, that’s annoying.

530 00:49:22.880 ⇒ 00:49:23.669 Samuel Roberts: Oh my god, I am.

531 00:49:26.330 ⇒ 00:49:32.220 Samuel Roberts: Let’s say… Nope, I can’t, because we don’t have a full name. Damn it.

532 00:49:40.410 ⇒ 00:49:42.240 Samuel Roberts: Oh, we can do it this… we can do it this way.

533 00:49:46.540 ⇒ 00:49:48.300 Gabriel Lam: Make lowercase, add it all in the middle.

534 00:49:48.300 ⇒ 00:49:51.939 Samuel Roberts: by making it firstname.lastname at brainforge.com.

535 00:49:52.110 ⇒ 00:49:53.370 Samuel Roberts: about AI.

536 00:49:57.410 ⇒ 00:50:01.029 Gabriel Lam: I think the only one that might be a problem is Amber’s, but let me take a look.

537 00:50:01.030 ⇒ 00:50:04.039 Samuel Roberts: Yep, yep, I can fix that. I just, I wanted to make sure that we…

538 00:50:05.620 ⇒ 00:50:07.290 Samuel Roberts: And she is… what is it, S…

539 00:50:07.920 ⇒ 00:50:09.139 Gabriel Lam: Amber cereal.

540 00:50:09.790 ⇒ 00:50:10.700 Samuel Roberts: The room.

541 00:50:11.440 ⇒ 00:50:13.039 Samuel Roberts: But I don’t mess that up.

542 00:50:13.760 ⇒ 00:50:15.470 Samuel Roberts: And of course, I couldn’t find it on there.

543 00:50:20.030 ⇒ 00:50:21.010 Samuel Roberts: Good, okay.

544 00:50:22.540 ⇒ 00:50:23.729 Samuel Roberts: Perfect, perfect, perfect.

545 00:50:26.020 ⇒ 00:50:30.060 Samuel Roberts: And then we’re gonna go back to here, we’re gonna go back to…

546 00:50:30.380 ⇒ 00:50:32.900 Samuel Roberts: Here, and we’re going to do this.

547 00:50:36.960 ⇒ 00:50:37.760 Gabriel Lam: Wonderful.

548 00:50:37.760 ⇒ 00:50:38.330 Samuel Roberts: Okay.

549 00:50:38.770 ⇒ 00:50:40.130 Samuel Roberts: Now we can test.

550 00:50:42.180 ⇒ 00:50:43.190 Samuel Roberts: And then…

551 00:50:49.210 ⇒ 00:51:00.660 Samuel Roberts: Participants… It’s being called here… So participants are coming in from where, is what I need to remember this.

552 00:51:01.530 ⇒ 00:51:04.100 Samuel Roberts: Meeting.participants, we’re gonna go…

553 00:51:07.750 ⇒ 00:51:09.190 Samuel Roberts: Load meeting…

554 00:52:02.000 ⇒ 00:52:03.210 Samuel Roberts: I’ll see if I did it.

555 00:52:08.990 ⇒ 00:52:09.889 Samuel Roberts: just here…

556 00:52:31.080 ⇒ 00:52:34.269 Samuel Roberts: Let’s pass it in as well as a second argument.

557 00:52:39.810 ⇒ 00:52:41.859 Samuel Roberts: And now here, we’ll say…

558 00:52:43.830 ⇒ 00:52:48.300 Samuel Roberts: What are linear… oh, we don’t need the linear users anymore, do we? That’s what’s going on here.

559 00:52:49.400 ⇒ 00:52:50.140 Samuel Roberts: Right?

560 00:52:50.900 ⇒ 00:52:52.550 Samuel Roberts: Because we’re getting them from the data.

561 00:52:52.550 ⇒ 00:52:54.280 Gabriel Lam: Because we’re just directly getting them, yeah.

562 00:52:55.290 ⇒ 00:52:56.430 Samuel Roberts: So that’s fine.

563 00:52:58.260 ⇒ 00:53:02.890 Samuel Roberts: Then we’ll come here… Wait. Wait.

564 00:53:03.020 ⇒ 00:53:06.540 Samuel Roberts: Oh, this is Resolve Users and teams, so we still want to do this, okay.

565 00:53:10.100 ⇒ 00:53:18.990 Samuel Roberts: Participants to linear users, We don’t need this… we don’t need that… no, we do want that.

566 00:53:19.790 ⇒ 00:53:21.170 Samuel Roberts: You just want…

567 00:53:41.860 ⇒ 00:53:43.999 Samuel Roberts: No, I’m totally messing this up.

568 00:53:44.160 ⇒ 00:53:46.750 Gabriel Lam: I don’t even think we need parts of emails, right?

569 00:53:46.750 ⇒ 00:53:50.819 Samuel Roberts: No, that’s what I’m saying, I think that’s why I was like, I don’t think we need that at all, we just want… yeah.

570 00:53:51.460 ⇒ 00:53:52.480 Samuel Roberts: There we go.

571 00:53:52.880 ⇒ 00:53:54.280 Samuel Roberts: That’s what we’re looking for, right?

572 00:54:03.160 ⇒ 00:54:04.069 Samuel Roberts: E dot.

573 00:54:04.590 ⇒ 00:54:06.379 Samuel Roberts: Rim is not a box shape.

574 00:54:10.810 ⇒ 00:54:12.169 Samuel Roberts: I don’t even think this matters.

575 00:54:12.170 ⇒ 00:54:13.500 Gabriel Lam: We don’t need to trim.

576 00:54:13.960 ⇒ 00:54:20.120 Samuel Roberts: No, I don’t think we need to do this… any of this, actually. We probably are good. We just want participant emails to be emails.

577 00:54:24.150 ⇒ 00:54:31.540 Samuel Roberts: Unless I processed it wrong, and it’s not coming in as an array, but… Yeah.

578 00:54:32.290 ⇒ 00:54:32.960 Samuel Roberts: It’s do it.

579 00:54:37.060 ⇒ 00:54:40.820 Samuel Roberts: So we still want emails, because we want to do…

580 00:54:44.810 ⇒ 00:54:45.660 Samuel Roberts: Think.

581 00:54:48.140 ⇒ 00:54:48.840 Samuel Roberts: See?

582 00:54:57.260 ⇒ 00:54:59.550 Samuel Roberts: Alright, because it’s not doing it right…

583 00:55:00.500 ⇒ 00:55:03.380 Samuel Roberts: I say… oh, I know what’s going on here.

584 00:55:03.860 ⇒ 00:55:06.609 Samuel Roberts: Ugh, I’m sorry, I should have figured it out a second here.

585 00:55:33.370 ⇒ 00:55:35.320 Samuel Roberts: I just forgot to save the file.

586 00:55:35.770 ⇒ 00:55:36.300 Gabriel Lam: Credit.

587 00:55:39.130 ⇒ 00:55:42.250 Samuel Roberts: We don’t need… So I’m gonna dance.

588 00:55:54.230 ⇒ 00:55:55.170 Samuel Roberts: Excellent.

589 00:55:56.670 ⇒ 00:56:02.930 Samuel Roberts: Okay, so now we have Team Rose is good. I don’t think we want any of this, right?

590 00:56:04.710 ⇒ 00:56:07.539 Samuel Roberts: This is just doing that matching, which we don’t want to do anymore.

591 00:56:07.760 ⇒ 00:56:08.520 Gabriel Lam: No.

592 00:56:09.440 ⇒ 00:56:12.450 Samuel Roberts: I don’t… I think we need that…

593 00:56:14.040 ⇒ 00:56:18.509 Samuel Roberts: We just want to say Team Rose needs to get defined.

594 00:56:31.910 ⇒ 00:56:34.669 Samuel Roberts: Maybe I’m letting it go a little crazy, but let’s see what happens.

595 00:56:44.720 ⇒ 00:56:48.690 Samuel Roberts: We’re trying to match participants to linear users, and I think that’s good. We got that then.

596 00:56:49.400 ⇒ 00:56:52.409 Samuel Roberts: So now, we’re going to jump back to…

597 00:57:05.000 ⇒ 00:57:05.779 Samuel Roberts: Let’s trying to get real.

598 00:57:11.880 ⇒ 00:57:14.729 Samuel Roberts: Oh, wait, no, I forgot that was stopping.

599 00:57:17.650 ⇒ 00:57:19.089 Samuel Roberts: Team Table did not work.

600 00:57:25.650 ⇒ 00:57:30.979 Samuel Roberts: I think we don’t need this either, we just want to do the ignore emails, right? That’s the only thing that matters here.

601 00:58:02.260 ⇒ 00:58:05.700 Samuel Roberts: Yeah, we’ll just… To go out, do that.

602 00:58:08.120 ⇒ 00:58:08.950 Samuel Roberts: Alright, let’s see…

603 00:58:23.580 ⇒ 00:58:26.680 Samuel Roberts: Okay, I gotta go… oh, no, I got a little bit of time.

604 00:58:28.620 ⇒ 00:58:30.250 Samuel Roberts: Team Rose, okay.

605 00:58:31.200 ⇒ 00:58:32.440 Samuel Roberts: So that’s good.

606 00:58:33.650 ⇒ 00:58:37.380 Samuel Roberts: And we just want to ignore… Yeah.

607 00:58:39.420 ⇒ 00:58:41.439 Samuel Roberts: Alright, that’s progress.

608 00:58:44.480 ⇒ 00:58:48.230 Samuel Roberts: Oh, I didn’t save, but I think we’re good. This should be…

609 00:58:54.690 ⇒ 00:58:55.600 Samuel Roberts: Okay.

610 00:58:59.960 ⇒ 00:59:03.049 Samuel Roberts: Yeah, okay, so all that I was doing is just filtering out UTAMs.

611 00:59:03.550 ⇒ 00:59:04.580 Gabriel Lam: Wonderful.

612 00:59:04.790 ⇒ 00:59:09.030 Samuel Roberts: That’s good, so that’s doing it, so then from Team Table, should be fine.

613 00:59:09.700 ⇒ 00:59:15.490 Samuel Roberts: Miss… Although we’re breaking everything else, aren’t we, here?

614 00:59:16.150 ⇒ 00:59:17.140 Samuel Roberts: Wow.

615 00:59:21.710 ⇒ 00:59:23.070 Samuel Roberts: Yeah, okay.

616 00:59:23.850 ⇒ 00:59:28.379 Samuel Roberts: Let’s just keep going for now.

617 00:59:30.660 ⇒ 00:59:32.480 Samuel Roberts: We’ll fix that later when it breaks.

618 00:59:33.530 ⇒ 00:59:39.170 Gabriel Lam: I think if this… If we’re able to do this, then…

619 00:59:39.360 ⇒ 00:59:41.429 Gabriel Lam: In some ways, we can deprecate

620 00:59:42.680 ⇒ 00:59:44.189 Gabriel Lam: I don’t know if we are.

621 00:59:44.310 ⇒ 00:59:45.150 Gabriel Lam: No, we’ll fix it.

622 00:59:45.150 ⇒ 00:59:51.609 Samuel Roberts: No, I see what you’re saying. Yeah, I think you’re probably right. So now the question is, calculate common teams, match users…

623 00:59:52.530 ⇒ 00:59:56.320 Samuel Roberts: has at least a few things. So then masked users, we’re gonna…

624 00:59:58.670 ⇒ 01:00:03.690 Samuel Roberts: User.team… we don’t have a team ID, I don’t know why it thinks we have a team ID here already.

625 01:00:07.980 ⇒ 01:00:10.150 Samuel Roberts: Those are… we didn’t actually…

626 01:00:10.600 ⇒ 01:00:14.300 Samuel Roberts: look up in the linear, did we, the teams? That’s what we gotta do here.

627 01:00:18.170 ⇒ 01:00:23.510 Samuel Roberts: So here, I want to say… No, no.

628 01:00:24.910 ⇒ 01:00:26.619 Samuel Roberts: Here, I wanna go…

629 01:00:30.490 ⇒ 01:00:32.620 Samuel Roberts: Use the linear…

630 01:00:37.410 ⇒ 01:00:55.110 Samuel Roberts: the user ID… To find all the… to… look… these… Look up…

631 01:01:06.150 ⇒ 01:01:07.310 Samuel Roberts: Wow.

632 01:01:10.540 ⇒ 01:01:11.950 Samuel Roberts: See what happens there.

633 01:01:42.130 ⇒ 01:01:43.820 Samuel Roberts: It’s not gonna be right.

634 01:01:46.550 ⇒ 01:01:47.769 Samuel Roberts: So, doctor.

635 01:01:54.360 ⇒ 01:01:57.180 Samuel Roberts: Oh, it’s not gonna do anything, because we’re turning after, whatever, let’s see.

636 01:02:03.370 ⇒ 01:02:05.089 Samuel Roberts: Teams in scope.

637 01:02:05.290 ⇒ 01:02:06.130 Samuel Roberts: We’ll see…

638 01:02:23.000 ⇒ 01:02:24.440 Samuel Roberts: Yeah, okay, that’s funny.

639 01:02:25.390 ⇒ 01:02:32.240 Samuel Roberts: So now, this calculate… Should be it. Let’s get rid… U.

640 01:02:33.340 ⇒ 01:02:36.400 Samuel Roberts: And you… Sheep,

641 01:02:44.750 ⇒ 01:02:45.510 Samuel Roberts: Okay.

642 01:02:48.340 ⇒ 01:02:52.249 Samuel Roberts: This still seems to be… potentially right.

643 01:02:56.430 ⇒ 01:02:59.890 Samuel Roberts: Because it’s unioning all of the teams that we’re all on, right?

644 01:03:00.310 ⇒ 01:03:03.100 Samuel Roberts: But at least now it’s doing everyone in the meeting.

645 01:03:03.240 ⇒ 01:03:03.800 Gabriel Lam: Yup.

646 01:03:05.200 ⇒ 01:03:06.499 Samuel Roberts: So that kind of…

647 01:03:06.850 ⇒ 01:03:10.849 Samuel Roberts: Didn’t solve a problem that we’re looking at right now, but it did solve a problem in China.

648 01:03:10.970 ⇒ 01:03:11.970 Samuel Roberts: So that’s good.

649 01:03:11.970 ⇒ 01:03:15.580 Gabriel Lam: It sort of did, because now this one’s capturing…

650 01:03:16.330 ⇒ 01:03:21.630 Gabriel Lam: the right number of people, and so even if the union looked the same, it’s…

651 01:03:21.630 ⇒ 01:03:22.100 Samuel Roberts: Right.

652 01:03:22.100 ⇒ 01:03:23.420 Gabriel Lam: Are you unioning the same thing.

653 01:03:23.420 ⇒ 01:03:29.150 Samuel Roberts: It should look different. Exactly, that’s what I’m saying. I think we solved the problem, but we’re just not seeing the solution, because it was already kind of…

654 01:03:29.360 ⇒ 01:03:36.100 Samuel Roberts: everyone, like, all the teams were getting found, because even though it wasn’t getting Pranav or Clarence, we were still getting most of the teams.

655 01:03:36.100 ⇒ 01:03:37.020 Gabriel Lam: Right.

656 01:03:37.540 ⇒ 01:03:41.939 Samuel Roberts: So now the issue, though, is that these are… this is way more teams than is discussed during this meeting.

657 01:03:46.100 ⇒ 01:03:48.170 Gabriel Lam: But I think the… hmm…

658 01:03:49.110 ⇒ 01:03:52.159 Samuel Roberts: That’s how we ended up with the default, potential.

659 01:03:52.340 ⇒ 01:03:54.110 Samuel Roberts: Like, if I run this whole thing now.

660 01:03:57.560 ⇒ 01:03:59.949 Samuel Roberts: When it spits out, remember there was a…

661 01:04:04.540 ⇒ 01:04:08.069 Samuel Roberts: Did it not finish? Let’s just log the teams in scope again.

662 01:04:14.000 ⇒ 01:04:15.479 Samuel Roberts: Did I?

663 01:04:16.160 ⇒ 01:04:17.609 Samuel Roberts: Oops, I messed that up.

664 01:04:33.920 ⇒ 01:04:35.090 Samuel Roberts: Not helpful.

665 01:04:47.950 ⇒ 01:04:48.730 Samuel Roberts: Oh.

666 01:04:49.910 ⇒ 01:04:51.400 Samuel Roberts: What am I missing here?

667 01:05:08.030 ⇒ 01:05:09.790 Samuel Roberts: Why this is not working? What am I missing?

668 01:05:09.980 ⇒ 01:05:14.409 Samuel Roberts: We’re running that. It does… it logs something that has teams in scope.

669 01:05:15.420 ⇒ 01:05:19.970 Samuel Roberts: But we’re not actually getting it, so it was all users and teams, so that’d be this.

670 01:05:26.570 ⇒ 01:05:29.240 Samuel Roberts: That’s what we want. Just do both of those.

671 01:05:34.010 ⇒ 01:05:37.599 Samuel Roberts: And then my favorite thing to do to make sure that we actually get the right

672 01:05:38.300 ⇒ 01:05:42.089 Samuel Roberts: spot here, because I’m not sure where we’re actually stopping the code. Let’s do a bunch of that.

673 01:05:51.320 ⇒ 01:05:52.679 Samuel Roberts: So we are getting to here.

674 01:05:53.310 ⇒ 01:05:55.029 Samuel Roberts: That’s good news.

675 01:05:55.670 ⇒ 01:05:57.100 Samuel Roberts: What do we have here?

676 01:05:57.300 ⇒ 01:05:59.699 Samuel Roberts: We have the teams, we have the users. Okay, great.

677 01:06:01.190 ⇒ 01:06:08.970 Samuel Roberts: So now… Issues… It says, load context, where is that?

678 01:06:17.050 ⇒ 01:06:18.220 Samuel Roberts: Here, okay, cool.

679 01:06:19.870 ⇒ 01:06:24.299 Samuel Roberts: So I think we can probably just… See what happens now.

680 01:06:26.640 ⇒ 01:06:32.890 Samuel Roberts: That sounds… that sounds worse than it is, but I think I wanted to test… I was… that’s what I was trying to do, was get to this point.

681 01:06:40.440 ⇒ 01:06:44.300 Samuel Roberts: Okay, good. It’s actually doing the linear ticket stuff, I think.

682 01:06:47.840 ⇒ 01:06:48.790 Samuel Roberts: I hope.

683 01:07:08.260 ⇒ 01:07:09.990 Samuel Roberts: I wasn’t taken the song before, was it?

684 01:07:11.780 ⇒ 01:07:12.920 Samuel Roberts: On Wednesday?

685 01:07:17.430 ⇒ 01:07:18.559 Samuel Roberts: Oh, okay, cool.

686 01:07:18.560 ⇒ 01:07:19.670 Gabriel Lam: Wonderful.

687 01:07:20.550 ⇒ 01:07:21.800 Samuel Roberts: We’ll see.

688 01:07:23.330 ⇒ 01:07:25.020 Samuel Roberts: Create intermediate here, yeah…

689 01:07:25.050 ⇒ 01:07:28.160 Gabriel Lam: That’s pretty good. Shared download meeting, you’re doing the last slide.

690 01:07:31.560 ⇒ 01:07:35.369 Samuel Roberts: He’s on the right team. Lilo… Saw that, okay.

691 01:07:36.330 ⇒ 01:07:37.530 Samuel Roberts: That’s pretty good.

692 01:07:42.490 ⇒ 01:07:48.309 Samuel Roberts: Create. It’s creating a ticket about me mentioning creating.

693 01:07:52.220 ⇒ 01:07:53.209 Samuel Roberts: That’s pretty good.

694 01:07:54.480 ⇒ 01:07:57.130 Samuel Roberts: Oh, there we go, look at that. Okay.

695 01:07:57.600 ⇒ 01:07:59.699 Samuel Roberts: It did not update any, though.

696 01:08:00.990 ⇒ 01:08:04.599 Samuel Roberts: Which might be okay, based on what we were talking about? I don’t know.

697 01:08:10.160 ⇒ 01:08:15.549 Samuel Roberts: It is still doing it with that added context, I think, though, right? We are including that.

698 01:08:27.960 ⇒ 01:08:35.450 Samuel Roberts: Yeah, okay, we have that here. Okay, yeah, I mean, I think this might be… okay… I don’t like…

699 01:08:36.620 ⇒ 01:08:39.639 Samuel Roberts: A lack of, like, my lack of confidence there, but…

700 01:08:41.279 ⇒ 01:08:46.150 Samuel Roberts: I just don’t know if there were anything that, like, we discussed that was specifically to update, you know?

701 01:08:47.490 ⇒ 01:08:55.720 Samuel Roberts: So maybe, maybe we need to, like, let this, like, Monday after meetings.

702 01:08:55.740 ⇒ 01:08:57.339 Gabriel Lam: Very bunch of tests here.

703 01:08:57.649 ⇒ 01:09:02.449 Samuel Roberts: Now, once we have the emails, everything should work, and we can run this script.

704 01:09:03.090 ⇒ 01:09:08.350 Samuel Roberts: I’m not gonna push anything, obviously, because I don’t wanna break… the…

705 01:09:09.420 ⇒ 01:09:14.590 Samuel Roberts: actual linear flow if anyone’s using it, but I think… We can reconvene and test.

706 01:09:14.590 ⇒ 01:09:16.010 Gabriel Lam: look at.

707 01:09:16.010 ⇒ 01:09:17.789 Samuel Roberts: I can push that, no, let me push it.

708 01:09:17.790 ⇒ 01:09:19.989 Gabriel Lam: I think you can just push it. I…

709 01:09:19.990 ⇒ 01:09:21.580 Samuel Roberts: Well, so yeah, tracking the logs.

710 01:09:21.600 ⇒ 01:09:24.219 Gabriel Lam: no one’s using it, and so I feel like…

711 01:09:24.220 ⇒ 01:09:24.810 Samuel Roberts: Right, okay.

712 01:09:24.810 ⇒ 01:09:30.249 Gabriel Lam: I feel like the update… there’s, like, the update portion, which… I think the create portion is…

713 01:09:31.609 ⇒ 01:09:34.629 Samuel Roberts: Well, it’s also gonna be on this branch, so it’s totally fine to say, it’s us.

714 01:09:35.129 ⇒ 01:09:42.229 Samuel Roberts: But yeah, so what you can do is still use, if you want, all you have to do is use this script, which is…

715 01:09:42.659 ⇒ 01:09:44.069 Samuel Roberts: Pretty easy to run.

716 01:09:44.309 ⇒ 01:09:45.679 Samuel Roberts: Right, from NPM?

717 01:09:47.579 ⇒ 01:09:53.419 Samuel Roberts: And then test that and see if we get any updates working. And…

718 01:09:53.619 ⇒ 01:09:56.799 Samuel Roberts: If, like, nothing is ever updated, we’ll know that that’s a problem.

719 01:09:58.220 ⇒ 01:09:58.880 Gabriel Lam: Okay.

720 01:09:59.590 ⇒ 01:10:02.730 Samuel Roberts: And we can revise the prompt, probably, at that point.

721 01:10:03.740 ⇒ 01:10:07.430 Gabriel Lam: Yeah, because now the prompt is inside.

722 01:10:08.090 ⇒ 01:10:08.940 Gabriel Lam: GitHub.

723 01:10:09.690 ⇒ 01:10:10.410 Samuel Roberts: Yes.

724 01:10:12.660 ⇒ 01:10:13.530 Samuel Roberts: Okay.

725 01:10:15.900 ⇒ 01:10:24.580 Samuel Roberts: Okay, this was… Productive, even if it didn’t feel sick. I think,

726 01:10:27.830 ⇒ 01:10:29.830 Samuel Roberts: Yeah, okay, so let’s, let’s plan to do that.

727 01:10:30.140 ⇒ 01:10:33.410 Samuel Roberts: Or, you plan to do that Monday after the meetings are in?

728 01:10:33.670 ⇒ 01:10:34.190 Gabriel Lam: Yeah.

729 01:10:35.180 ⇒ 01:10:40.840 Samuel Roberts: Casey, do you think we’ll have the… Emails in here.

730 01:10:41.400 ⇒ 01:10:44.879 Casie Aviles: Oh yeah, I was… I was actually working on it already.

731 01:10:45.090 ⇒ 01:10:50.350 Samuel Roberts: Oh, okay, cool, cool, cool, yeah. If that’s the case, then yeah, sometime before Monday meetings, making sure that that logs.

732 01:10:50.640 ⇒ 01:10:53.259 Samuel Roberts: And then… we can run with it from there.

733 01:10:54.940 ⇒ 01:10:59.820 Samuel Roberts: Does that work, Gabe? Are we… I feel like it’s a little bit stalling, but I think it’s…

734 01:10:59.820 ⇒ 01:11:00.499 Gabriel Lam: Oh, it’s funny.

735 01:11:00.500 ⇒ 01:11:01.400 Samuel Roberts: the data.

736 01:11:01.400 ⇒ 01:11:08.380 Gabriel Lam: Yeah, I think… I think there’s the… Linear…

737 01:11:08.860 ⇒ 01:11:11.379 Gabriel Lam: portion, and then there’s a Slack portion of, like.

738 01:11:11.920 ⇒ 01:11:16.799 Gabriel Lam: If we dry run it, is it able to connect to… a Slack bite.

739 01:11:20.880 ⇒ 01:11:24.010 Gabriel Lam: And, like… You know, happy to have, like.

740 01:11:24.010 ⇒ 01:11:24.710 Samuel Roberts: Yeah.

741 01:11:24.710 ⇒ 01:11:30.809 Gabriel Lam: my… DM be the default pathway, and I’ll just, like, get spammed with a bunch of stuff.

742 01:11:31.010 ⇒ 01:11:32.920 Samuel Roberts: Yeah, yeah, we can, we can set that up. I think…

743 01:11:32.920 ⇒ 01:11:33.430 Gabriel Lam: clip.

744 01:11:34.280 ⇒ 01:11:37.750 Samuel Roberts: I think… yeah, that shouldn’t be too bad. I mean, this is… if this output is…

745 01:11:39.230 ⇒ 01:11:43.700 Samuel Roberts: is good. You know, this is just not doing the, like, actual…

746 01:11:44.300 ⇒ 01:11:46.529 Samuel Roberts: Writing anything to any tables or anything?

747 01:11:46.690 ⇒ 01:11:47.400 Gabriel Lam: Yeah.

748 01:11:47.740 ⇒ 01:11:52.249 Samuel Roberts: So we can just make sure to do that, and then trigger a bunch of Slack notifications for whoever it is.

749 01:11:54.950 ⇒ 01:11:55.950 Samuel Roberts: Okay.

750 01:11:56.110 ⇒ 01:11:57.180 Samuel Roberts: O?

751 01:11:57.980 ⇒ 01:11:59.340 Samuel Roberts: Excuse me.

752 01:12:00.020 ⇒ 01:12:01.609 Samuel Roberts: I need to make more coffee.

753 01:12:02.790 ⇒ 01:12:06.270 Samuel Roberts: And maybe grab lunch, I didn’t realize it was our… Good point.

754 01:12:07.630 ⇒ 01:12:08.290 Gabriel Lam: Alright.

755 01:12:09.130 ⇒ 01:12:11.809 Samuel Roberts: Alright, are we… are we good here, then? Is there anything else you want me to…

756 01:12:12.340 ⇒ 01:12:20.999 Gabriel Lam: I think we’re good here. I guess just a quick… if we have, like, 2 minutes to go over, like, if it was to go into Slack, what would…

757 01:12:21.110 ⇒ 01:12:26.379 Gabriel Lam: the implement, like, if you have any… Guidance on, like, technical implementation.

758 01:12:30.640 ⇒ 01:12:35.800 Gabriel Lam: I also know, Casey, you did a bunch of Slackbots before, so I guess it’s perfect.

759 01:12:36.150 ⇒ 01:12:38.319 Gabriel Lam: timing about, like, connecting.

760 01:12:38.320 ⇒ 01:12:43.759 Samuel Roberts: Are we… are we looking for, like, the tickets to just be, like, sent, and it’s, like, approve these kind of thing?

761 01:12:43.760 ⇒ 01:12:48.469 Gabriel Lam: Sort of. That’s basically it. It’s like, instead of having to go into the platform, then select the meeting.

762 01:12:48.470 ⇒ 01:12:49.290 Samuel Roberts: Yeah.

763 01:12:49.290 ⇒ 01:12:49.790 Gabriel Lam: You can just.

764 01:12:49.790 ⇒ 01:12:50.380 Casie Aviles: Hmm.

765 01:12:50.740 ⇒ 01:12:51.660 Gabriel Lam: one, like…

766 01:12:51.870 ⇒ 01:12:56.459 Gabriel Lam: we can assign people, but I think now, just to get the flow out, it could just be me.

767 01:12:56.810 ⇒ 01:13:00.369 Gabriel Lam: And… it doesn’t have to be a linear ticket, it could just be, like.

768 01:13:01.340 ⇒ 01:13:04.810 Gabriel Lam: The meeting returns that we see in the terminal, like, just to start.

769 01:13:05.390 ⇒ 01:13:05.999 Gabriel Lam: And then eventually.

770 01:13:06.000 ⇒ 01:13:11.920 Samuel Roberts: Yeah, there’s probably a way to do that. I don’t know from this script what the best way is.

771 01:13:13.580 ⇒ 01:13:17.040 Samuel Roberts: But we could… Like, what is in here?

772 01:13:18.660 ⇒ 01:13:19.420 Samuel Roberts: Slack.

773 01:13:19.420 ⇒ 01:13:22.179 Casie Aviles: What’s the flow going to be like with the SlackBot?

774 01:13:23.400 ⇒ 01:13:31.839 Gabriel Lam: Basically… what I… what people are saying, and what I’ve noticed is just, it’s…

775 01:13:34.270 ⇒ 01:13:48.289 Gabriel Lam: for linear tickets, the first thing is that it’s only been creating, and so people are like, oh, you know, it’s helpful for creating new tickets, but then either they don’t, like… I just create a bunch, and then I delete a bunch, or…

776 01:13:48.640 ⇒ 01:13:56.159 Gabriel Lam: I don’t know how this connects to, like, existing context, so I think that’s the linear portion. The next portion is just, like.

777 01:13:56.350 ⇒ 01:14:02.349 Gabriel Lam: I have to wait till the meeting ingests. By the time the meeting ingests, I might be doing something else. I forget to go to the platform and do it.

778 01:14:02.610 ⇒ 01:14:11.000 Gabriel Lam: And so what I feel like is most helpful is everyone checks Slack, everyone gets a DM, or, like, everyone gets a notification.

779 01:14:11.130 ⇒ 01:14:16.609 Gabriel Lam: And that is a way that we can move away from, like, generating linear tickets from the platform.

780 01:14:18.340 ⇒ 01:14:21.809 Casie Aviles: Okay, so it should be, like, automatic, right? And then…

781 01:14:21.810 ⇒ 01:14:23.400 Samuel Roberts: Yeah. Yeah.

782 01:14:23.400 ⇒ 01:14:24.219 Casie Aviles: Okay, okay.

783 01:14:24.220 ⇒ 01:14:24.900 Gabriel Lam: Yeah.

784 01:14:25.570 ⇒ 01:14:28.400 Samuel Roberts: Also, can we…

785 01:14:28.940 ⇒ 01:14:40.110 Samuel Roberts: or… I’m just kind of offloading this mental load to you, Gabe, I apologize, but something is not working with the cron jobs, syncing Slack, Linear, and Google.

786 01:14:42.170 ⇒ 01:14:49.849 Samuel Roberts: make a ticket, I guess, for… I’m saying it here, so maybe we’ll be able to do that with the thing. I just want a ticket to remind me to go in and check.

787 01:14:49.980 ⇒ 01:14:52.729 Samuel Roberts: what’s going on there, because I don’t have time to do it right now.

788 01:14:53.070 ⇒ 01:14:53.949 Gabriel Lam: Yeah, for sure.

789 01:14:54.440 ⇒ 01:14:56.030 Samuel Roberts: Okay, cool. Thank you.

790 01:14:56.350 ⇒ 01:14:59.520 Samuel Roberts: And then there was something else I was doing, I was about to pull…

791 01:15:01.450 ⇒ 01:15:07.200 Samuel Roberts: Alright, we’re gonna pull this Slack ID. We’re gonna test this right now and see what… if this works.

792 01:15:21.210 ⇒ 01:15:22.830 Samuel Roberts: And is that what it wants?

793 01:15:24.440 ⇒ 01:15:26.280 Samuel Roberts: Message, and then options.

794 01:15:26.680 ⇒ 01:15:27.510 Samuel Roberts: So…

795 01:15:35.450 ⇒ 01:15:37.349 Samuel Roberts: Refinitely earn one…

796 01:15:45.270 ⇒ 01:15:48.429 Samuel Roberts: Not working? Oh, there we go, I’m just being dumb.

797 01:15:51.050 ⇒ 01:15:53.700 Samuel Roberts: I wanna try this real quick and see what happens.

798 01:15:53.700 ⇒ 01:15:54.840 Gabriel Lam: Sure.

799 01:15:55.260 ⇒ 01:15:57.729 Samuel Roberts: I actually don’t know what exactly the…

800 01:15:58.640 ⇒ 01:16:05.200 Samuel Roberts: Let’s just do this and get rid of all this in here. I’m just gonna send… I’m gonna run this and see if you get a Slack notification, okay?

801 01:16:12.440 ⇒ 01:16:13.340 Samuel Roberts: Anything?

802 01:16:15.430 ⇒ 01:16:17.790 Gabriel Lam: Yup, I get it from Brainforge Assistant.

803 01:16:18.760 ⇒ 01:16:20.490 Samuel Roberts: Cool. Okay.

804 01:16:22.830 ⇒ 01:16:29.679 Samuel Roberts: Yeah, so we can definitely continue with this dry run, sending Slack messages as well, like, breaking up the linear tickets, we can experiment with that too.

805 01:16:29.790 ⇒ 01:16:30.670 Samuel Roberts: Yeah.

806 01:16:31.730 ⇒ 01:16:35.799 Samuel Roberts: So that works pretty well. I wasn’t sure if, like, running it from the script was gonna be enough, but…

807 01:16:36.440 ⇒ 01:16:37.140 Samuel Roberts: Yeah.

808 01:16:39.100 ⇒ 01:16:39.950 Samuel Roberts: Okay.

809 01:16:41.330 ⇒ 01:16:44.380 Samuel Roberts: I need to run to go make more coffee before my next meeting.

810 01:16:44.550 ⇒ 01:16:45.440 Gabriel Lam: Alright.

811 01:16:48.300 ⇒ 01:16:48.810 Gabriel Lam: Yeah.

812 01:16:48.810 ⇒ 01:16:51.729 Samuel Roberts: I feel better about this now,

813 01:16:53.720 ⇒ 01:16:59.460 Samuel Roberts: I think once we get those emails, that’ll be another… that’s, like, another little… like… piece of…

814 01:17:00.090 ⇒ 01:17:03.830 Samuel Roberts: Plaster over some of the cracks in the overall architecture, but…

815 01:17:03.970 ⇒ 01:17:05.690 Samuel Roberts: I think it’s a good one.

816 01:17:08.340 ⇒ 01:17:14.810 Samuel Roberts: Yeah, Casey, we were talking a little bit about, like, managing that team’s table and getting the linear IDs in was kind of the first thing I did on Wednesday.

817 01:17:16.250 ⇒ 01:17:21.049 Samuel Roberts: And then… We have the Slack IDs already from doing the case study assistant.

818 01:17:21.310 ⇒ 01:17:28.430 Samuel Roberts: but then the participants from the meetings was the other thing, so I think adding those emails will be a good, like, bridge.

819 01:17:28.800 ⇒ 01:17:30.950 Samuel Roberts: Is that participants table, Casey?

820 01:17:31.050 ⇒ 01:17:36.090 Samuel Roberts: Is it, is this getting… is this old?

821 01:17:37.810 ⇒ 01:17:38.460 Casie Aviles: Hmm.

822 01:17:39.430 ⇒ 01:17:43.170 Samuel Roberts: Is this getting used at all? It looks like nothing’s been created here for…

823 01:17:44.700 ⇒ 01:17:52.019 Samuel Roberts: Yeah, I don’t… I don’t think we’re maintaining… maintaining this. Okay, I… good. That’s what we kind of thought, I just want to make sure, because that’s… I think…

824 01:17:52.180 ⇒ 01:17:54.610 Samuel Roberts: Another step would be to do that, but I don’t…

825 01:17:54.880 ⇒ 01:17:57.940 Samuel Roberts: I think for now, just the emails is good enough for this purpose.

826 01:17:58.690 ⇒ 01:17:59.859 Casie Aviles: So you gotta think…

827 01:17:59.990 ⇒ 01:18:08.150 Casie Aviles: I made some changes now, so I’m just monitoring, like, new meetings that will come in, if you have the emails.

828 01:18:09.220 ⇒ 01:18:09.790 Samuel Roberts: Okay, cool.

829 01:18:09.790 ⇒ 01:18:13.529 Casie Aviles: I think there is one with Mustafa and, oh, yeah, that one.

830 01:18:13.650 ⇒ 01:18:15.130 Casie Aviles: That just gave me lightning.

831 01:18:17.080 ⇒ 01:18:17.940 Gabriel Lam: I see.

832 01:18:18.270 ⇒ 01:18:20.510 Samuel Roberts: No, different format… okay, we can make this work.

833 01:18:20.510 ⇒ 01:18:22.140 Casie Aviles: Oh, okay.

834 01:18:22.140 ⇒ 01:18:28.900 Samuel Roberts: No, it’s totally fine. Having the name is not a bad thing. I just need to update the code, because I had just dropped it, and it’s an array of emails, but don’t worry about it.

835 01:18:28.900 ⇒ 01:18:29.620 Gabriel Lam: Yeah.

836 01:18:29.620 ⇒ 01:18:33.750 Samuel Roberts: We can fix that Monday, too. Or, no, I should fix that before Monday, obviously.

837 01:18:36.310 ⇒ 01:18:42.090 Samuel Roberts: So, this is now in a… Okay, well, let’s just pull this meeting, I guess.

838 01:18:42.910 ⇒ 01:18:45.320 Samuel Roberts: We can test against that and see if nothing breaks.

839 01:18:50.590 ⇒ 01:18:53.740 Casie Aviles: But yeah, let me know if I should change the format.

840 01:18:54.140 ⇒ 01:18:54.710 Casie Aviles: instead.

841 01:18:54.710 ⇒ 01:19:00.510 Samuel Roberts: Yeah, no, I’d rather adapt the code and have that extra data. Oh, shit, I just sent you a Slack message, didn’t

842 01:19:01.420 ⇒ 01:19:02.829 Samuel Roberts: Let me do what I wanted.

843 01:19:02.830 ⇒ 01:19:05.580 Gabriel Lam: You can spam it, it’s not a problem.

844 01:19:05.580 ⇒ 01:19:15.110 Samuel Roberts: I’ll set up a script to just run that every minute later, when I have some free time for you, so you’ll just get… I wonder if they limit that. Like, if they see something’s just, like.

845 01:19:17.920 ⇒ 01:19:20.690 Samuel Roberts: Okay, so something bad happened here, that’s good. Okay.

846 01:19:21.940 ⇒ 01:19:25.410 Samuel Roberts: So… We need to go back to the…

847 01:19:26.680 ⇒ 01:19:27.660 Gabriel Lam: participant email.

848 01:19:27.660 ⇒ 01:19:30.459 Samuel Roberts: Participant’s email is being fed into here.

849 01:19:30.680 ⇒ 01:19:32.689 Samuel Roberts: Which is coming from…

850 01:19:35.910 ⇒ 01:19:40.219 Samuel Roberts: Load meeting, which is loading the meeting…

851 01:19:42.080 ⇒ 01:19:44.779 Samuel Roberts: Here, so then we want to fetch that.

852 01:19:45.950 ⇒ 01:19:48.960 Samuel Roberts: Christopher’s emails is actually gonna be a…

853 01:19:51.740 ⇒ 01:19:55.379 Samuel Roberts: It’s gonna be a… look at this, my TypeScript.

854 01:19:56.260 ⇒ 01:20:00.459 Samuel Roberts: This is… this is where it’s gonna be a string… string?

855 01:20:00.910 ⇒ 01:20:03.610 Samuel Roberts: That email string, that’s what I’m looking for right there, thank you!

856 01:20:04.070 ⇒ 01:20:06.549 Samuel Roberts: No, no, summary can be there, we want to move this.

857 01:20:12.420 ⇒ 01:20:15.370 Samuel Roberts: So now, something down here should break.

858 01:20:31.500 ⇒ 01:20:32.160 Samuel Roberts: What?

859 01:20:34.050 ⇒ 01:20:38.240 Samuel Roberts: What is P? Oh, we’re inside there, okay, good. I gotta get rid of the search.

860 01:20:42.280 ⇒ 01:20:45.829 Samuel Roberts: We do want to split, and that’ll give us an object.

861 01:20:47.810 ⇒ 01:20:49.479 Samuel Roberts: He is gonna be…

862 01:20:53.260 ⇒ 01:20:54.059 Samuel Roberts: Hold on.

863 01:20:54.240 ⇒ 01:20:55.289 Samuel Roberts: I don’t like this.

864 01:21:06.530 ⇒ 01:21:07.960 Samuel Roberts: We’re just gonna double check it.

865 01:21:21.750 ⇒ 01:21:23.600 Samuel Roberts: participant emails.

866 01:21:28.190 ⇒ 01:21:30.390 Samuel Roberts: That’s all. That’s literally all we want, I think.

867 01:21:35.810 ⇒ 01:21:36.730 Samuel Roberts: Right.

868 01:21:51.880 ⇒ 01:21:58.240 Gabriel Lam: Is there a difference if we put emails before string… Emails before name in the… In the const.

869 01:21:59.210 ⇒ 01:22:02.600 Gabriel Lam: Not gonna be an issue, or… Not really.

870 01:22:03.960 ⇒ 01:22:04.630 Gabriel Lam: the order.

871 01:22:04.630 ⇒ 01:22:08.219 Samuel Roberts: So I’m just not sure. This should just be gen… like, what is… this is outputting?

872 01:22:26.960 ⇒ 01:22:30.599 Samuel Roberts: Still not doing it, but this should be… yeah, email string…

873 01:22:32.290 ⇒ 01:22:34.900 Samuel Roberts: Oh, I know what I did. The return…

874 01:22:35.770 ⇒ 01:22:40.629 Samuel Roberts: Should actually be the email string. Okay, that’s just me being real dumb.

875 01:22:42.920 ⇒ 01:22:43.630 Samuel Roberts: Okay.

876 01:22:52.210 ⇒ 01:22:56.600 Samuel Roberts: Okay, good. We should probably add a little bit more logging in here, but that’s not a problem.

877 01:22:56.790 ⇒ 01:23:00.459 Samuel Roberts: So this at least now is using the right email, so we’re good, Casey.

878 01:23:00.610 ⇒ 01:23:02.239 Samuel Roberts: The way you put it is fine.

879 01:23:02.340 ⇒ 01:23:04.370 Samuel Roberts: And I think that’s… that’ll be better. Okay, cool.

880 01:23:04.750 ⇒ 01:23:06.450 Samuel Roberts: Record and communicate agreed.

881 01:23:06.690 ⇒ 01:23:09.719 Samuel Roberts: task hour estimates. Cool. Okay, whatever.

882 01:23:11.500 ⇒ 01:23:14.650 Samuel Roberts: Okay, so now those meetings should be in…

883 01:23:15.080 ⇒ 01:23:17.830 Samuel Roberts: Or the email should be coming in every time.

884 01:23:22.060 ⇒ 01:23:25.550 Gabriel Lam: Should we test the latest one, just for kicks? That’s exactly what I was thinking.

885 01:23:59.540 ⇒ 01:24:00.580 Samuel Roberts: Okay…

886 01:24:07.850 ⇒ 01:24:10.299 Samuel Roberts: Okay, more creation, no update, but…

887 01:24:19.760 ⇒ 01:24:22.310 Samuel Roberts: Operations, operations, operations. That’s all good, though, okay.

888 01:24:25.060 ⇒ 01:24:26.810 Samuel Roberts: Yeah, I think the…

889 01:24:27.870 ⇒ 01:24:33.389 Samuel Roberts: The test will be Monday during the AI meeting. Maybe I’ll call out some actual linear tickets.

890 01:24:33.700 ⇒ 01:24:34.380 Gabriel Lam: Yep.

891 01:24:35.430 ⇒ 01:24:38.789 Samuel Roberts: remind me specifically to do that, I guess, and be like.

892 01:24:38.790 ⇒ 01:24:39.790 Gabriel Lam: Yeah, or I can set up…

893 01:24:39.790 ⇒ 01:24:40.989 Samuel Roberts: I want to make sure we…

894 01:24:40.990 ⇒ 01:24:42.889 Gabriel Lam: I can set up, like, the cron…

895 01:24:43.280 ⇒ 01:24:47.710 Gabriel Lam: like, some of the tickets now, and so for Monday, we’ll for sure have things we need to update.

896 01:24:48.060 ⇒ 01:24:49.290 Samuel Roberts: Yes, perfect.

897 01:24:49.510 ⇒ 01:24:53.919 Samuel Roberts: And then even… even if not, we could just do a fake meeting, if we really need to.

898 01:24:54.370 ⇒ 01:24:59.519 Samuel Roberts: Okay, yeah, that sounds good.

899 01:24:59.750 ⇒ 01:25:04.019 Samuel Roberts: I gotta really run, cause there’s… yeah, I gotta… Meeting in 5 minutes, so…

900 01:25:04.020 ⇒ 01:25:04.740 Gabriel Lam: Awesome.

901 01:25:04.800 ⇒ 01:25:13.709 Samuel Roberts: Thanks, guys, appreciate the quick ask. Alright, yeah, no, I feel good about this. I think what will really be nice is once this is good to go, this… the Slack…

902 01:25:14.750 ⇒ 01:25:20.510 Samuel Roberts: messaging thing, we can try to make it a little more robust, because, like, what if the assignee is not right, you know?

903 01:25:20.510 ⇒ 01:25:21.070 Gabriel Lam: Joe.

904 01:25:21.670 ⇒ 01:25:23.330 Samuel Roberts: But we can figure that out.

905 01:25:23.490 ⇒ 01:25:26.149 Samuel Roberts: That’ll be fun to work on, because that’ll be a little more,

906 01:25:26.600 ⇒ 01:25:34.000 Samuel Roberts: Deterministic, less, dependent on the context of everything, so… Okay, cool.

907 01:25:35.670 ⇒ 01:25:36.490 Samuel Roberts: Awesome.

908 01:25:36.490 ⇒ 01:25:38.730 Gabriel Lam: Thanks, guys. Alright. Appreciate it.

909 01:25:39.040 ⇒ 01:25:41.090 Gabriel Lam: Have a good rest of your day.

910 01:25:41.090 ⇒ 01:25:42.430 Samuel Roberts: Yeah, you too.

911 01:25:42.950 ⇒ 01:25:43.930 Gabriel Lam: Alright, bye guys.

912 01:25:44.620 ⇒ 01:25:45.140 Casie Aviles: Bye-bye.

913 01:25:45.140 ⇒ 01:25:45.890 Samuel Roberts: Excuse me.