Meeting Title: ABC Standup Date: 2025-10-02 Meeting participants: Casie Aviles, Mustafa Raja, Amber Lin
WEBVTT
1 00:00:27.260 ⇒ 00:00:28.039 Mustafa Raja: How are you?
2 00:00:29.560 ⇒ 00:00:30.839 Casie Aviles: Yeah, doing good.
3 00:00:31.240 ⇒ 00:00:32.200 Casie Aviles: How about you?
4 00:00:32.900 ⇒ 00:00:35.069 Casie Aviles: Yeah, good. How was the…
5 00:00:35.710 ⇒ 00:00:39.509 Mustafa Raja: How was your, off days?
6 00:00:41.220 ⇒ 00:00:45.119 Casie Aviles: Yeah, I think, you know, I needed it.
7 00:00:45.120 ⇒ 00:00:45.930 Mustafa Raja: What did you do?
8 00:00:46.900 ⇒ 00:00:50.529 Casie Aviles: Well, I did a couple of things. I traveled to our…
9 00:00:50.530 ⇒ 00:00:51.300 Mustafa Raja: Oh, nice.
10 00:00:51.670 ⇒ 00:00:54.470 Casie Aviles: I traveled to the capital.
11 00:00:55.190 ⇒ 00:00:56.050 Mustafa Raja: Manila.
12 00:00:56.700 ⇒ 00:01:02.009 Casie Aviles: Yeah, went to see a show, and then went to see my friends after that.
13 00:01:02.610 ⇒ 00:01:03.360 Mustafa Raja: Nice.
14 00:01:03.900 ⇒ 00:01:06.290 Amber Lin: Awesome. What show did you see?
15 00:01:06.990 ⇒ 00:01:13.970 Casie Aviles: Oh, I saw a band, concert, I think it was, Smashing Pumpkins from…
16 00:01:14.250 ⇒ 00:01:15.220 Amber Lin: Huh.
17 00:01:15.730 ⇒ 00:01:17.119 Amber Lin: Let me see what…
18 00:01:22.850 ⇒ 00:01:27.700 Casie Aviles: Oh… What’s a 90s band.
19 00:01:28.330 ⇒ 00:01:30.070 Amber Lin: That’s pretty cool.
20 00:01:31.020 ⇒ 00:01:43.710 Amber Lin: Yeah. My parents are also coming, and I haven’t… I’ve not seen them in two years, maybe a little bit longer, so they’re coming today, and so I’ll be off, like, next…
21 00:01:44.120 ⇒ 00:01:46.329 Amber Lin: next Wednesday for a week.
22 00:01:48.080 ⇒ 00:01:49.460 Casie Aviles: Nice, yeah.
23 00:01:51.450 ⇒ 00:02:02.819 Amber Lin: Hmm. I have a few… yeah, I… I also have only seen my brother for, like, 2 times in his life, so we’ll see.
24 00:02:02.820 ⇒ 00:02:03.940 Casie Aviles: Really?
25 00:02:03.940 ⇒ 00:02:05.399 Mustafa Raja: How’s that possible?
26 00:02:06.560 ⇒ 00:02:09.660 Amber Lin: Because he is, he is 5, and…
27 00:02:10.570 ⇒ 00:02:19.470 Amber Lin: I went to college when he… right before, like, right after he was born, so I’ve only seen him for the two summers I was back home.
28 00:02:19.640 ⇒ 00:02:20.780 Mustafa Raja: Oh…
29 00:02:20.780 ⇒ 00:02:21.630 Amber Lin: Yeah.
30 00:02:21.920 ⇒ 00:02:39.300 Amber Lin: I am going to send a list of the agenda here. Actually, let’s start from the bottom. So… because I know we did a log of the changes, and I know it’s currently in Superbase, right? I just don’t know…
31 00:02:39.300 ⇒ 00:02:41.330 Casie Aviles: Where the clients can see it.
32 00:02:42.410 ⇒ 00:02:44.840 Casie Aviles: Hmm, okay, I see, I see.
33 00:02:45.980 ⇒ 00:02:52.559 Casie Aviles: I think… well, in that case, yeah, Superbase is not something that’s easily shareable to them, so…
34 00:02:54.420 ⇒ 00:02:56.160 Casie Aviles: Then… then I guess I would…
35 00:02:56.670 ⇒ 00:03:04.309 Casie Aviles: Proposed that it would… it should live somewhere on a… on a spreadsheet then, if that’s… Better for them.
36 00:03:05.790 ⇒ 00:03:06.370 Amber Lin: Oh…
37 00:03:07.880 ⇒ 00:03:11.800 Casie Aviles: be both on SuperBase and then also synced to a… Spreadsheet.
38 00:03:11.800 ⇒ 00:03:15.069 Amber Lin: How much effort would it take you?
39 00:03:17.180 ⇒ 00:03:21.529 Casie Aviles: I think that might, take me a point, or…
40 00:03:22.170 ⇒ 00:03:24.469 Casie Aviles: Yeah, let’s say around a point.
41 00:03:25.030 ⇒ 00:03:31.089 Amber Lin: Mmm, okay. Let me… let me assign that… oh, let me share my screen.
42 00:03:31.760 ⇒ 00:03:38.770 Amber Lin: Hmm… So, I made this ticket… So, let’s say…
43 00:03:47.750 ⇒ 00:03:48.520 Amber Lin: Okay.
44 00:03:50.960 ⇒ 00:03:59.570 Amber Lin: And, oh, wrong place. Okay, so that’s… that’s done.
45 00:04:00.060 ⇒ 00:04:09.879 Amber Lin: And then on the forms… On the form side… I wanna show you the…
46 00:04:10.290 ⇒ 00:04:17.030 Amber Lin: update that we can use to test our system, and I was trying to do it yesterday, but then I realized I
47 00:04:17.260 ⇒ 00:04:20.860 Amber Lin: I was running into some problems, so…
48 00:04:20.860 ⇒ 00:04:21.320 Casie Aviles: Okay.
49 00:04:21.320 ⇒ 00:04:33.800 Amber Lin: we have two things, essentially, of add these two people to the call station zips, delete this person from all of his whatever assignments, and then… because these…
50 00:04:33.960 ⇒ 00:04:46.300 Amber Lin: Hank and Steven, they have blocks specifically for, the caller station and this, this service, and it doesn’t apply to all of their
51 00:04:46.620 ⇒ 00:04:51.169 Amber Lin: all of their zips is only for the,
52 00:04:51.710 ⇒ 00:04:59.410 Amber Lin: For these zips in College Station. So there’s 3 things, and I want to go over each one of them, and how we can add them.
53 00:05:00.050 ⇒ 00:05:13.409 Amber Lin: Yeah, so the first one should be pretty straightforward, but my question is, when we select, say, the branch caller station, do we still have to enter all the zips, or is it just…
54 00:05:13.770 ⇒ 00:05:16.530 Amber Lin: If we select College Station, that’s fine.
55 00:05:17.750 ⇒ 00:05:23.450 Casie Aviles: Oh, how it works is we have to input, like, all the zips that we want it to be…
56 00:05:24.230 ⇒ 00:05:28.360 Casie Aviles: Yeah, we want to include, so it’s the branch and then the zips.
57 00:05:28.360 ⇒ 00:05:37.570 Amber Lin: Hmm, I see. So, I think one of their spreadsheets have the zip codes.
58 00:05:42.130 ⇒ 00:05:44.219 Amber Lin: Who? No, in-house?
59 00:05:44.670 ⇒ 00:05:45.510 Amber Lin: Huh.
60 00:05:47.290 ⇒ 00:05:48.220 Amber Lin: Nope.
61 00:05:49.790 ⇒ 00:05:50.890 Amber Lin: Hmm…
62 00:05:57.590 ⇒ 00:06:02.149 Amber Lin: Where do they have… where do we have all the zips for that zip code?
63 00:06:03.900 ⇒ 00:06:06.179 Casie Aviles: Is it the service areas?
64 00:06:07.800 ⇒ 00:06:08.130 Casie Aviles: Sure.
65 00:06:08.130 ⇒ 00:06:08.880 Amber Lin: Maybe.
66 00:06:08.880 ⇒ 00:06:09.420 Casie Aviles: Sure.
67 00:06:10.230 ⇒ 00:06:16.240 Amber Lin: Okay, so if we have… See if we just got… oh, I guess we just get all these…
68 00:06:16.950 ⇒ 00:06:18.850 Amber Lin: College Station.
69 00:06:18.980 ⇒ 00:06:20.020 Amber Lin: Yeah.
70 00:06:20.440 ⇒ 00:06:22.329 Amber Lin: Okay, that makes sense.
71 00:06:25.080 ⇒ 00:06:29.729 Casie Aviles: Because my assumption was that if, you know,
72 00:06:30.330 ⇒ 00:06:33.199 Casie Aviles: They may not be added to all the zips.
73 00:06:33.550 ⇒ 00:06:35.489 Amber Lin: Mmm, that’s true.
74 00:06:39.620 ⇒ 00:06:40.530 Amber Lin: Yeah.
75 00:06:42.940 ⇒ 00:06:47.960 Amber Lin: Okay. Okay, so that’s the first one, we could try adding that.
76 00:06:48.310 ⇒ 00:06:49.790 Casie Aviles: Okay, I’ll add them.
77 00:06:50.070 ⇒ 00:07:05.220 Amber Lin: Yeah, I ran into a problem yesterday, because I was trying to see where Hank currently services, or even Steven, where he currently services, and it seems like we’re currently not able to ask by person.
78 00:07:05.300 ⇒ 00:07:10.490 Amber Lin: Like, I tried to do Steven…
79 00:07:11.220 ⇒ 00:07:20.160 Amber Lin: And then it doesn’t really… it doesn’t always answer. I was like, this person… because I remember when we first started, we could ask, you know, we just put in a name.
80 00:07:20.160 ⇒ 00:07:22.259 Casie Aviles: Yeah, I think that…
81 00:07:22.260 ⇒ 00:07:26.100 Amber Lin: There might be, like, a conflict with one of the other…
82 00:07:26.100 ⇒ 00:07:29.809 Casie Aviles: data sources that we have, which is, like, the pest directory.
83 00:07:30.860 ⇒ 00:07:35.710 Casie Aviles: Maybe it’s using the best directory tool instead of, like, the db querying tool.
84 00:07:35.710 ⇒ 00:07:45.369 Amber Lin: I see. I think, in terms of that, I got the Paylocity link. We can…
85 00:07:46.410 ⇒ 00:07:59.989 Amber Lin: for the pest directory, we can tell them to just go to Paylocity, but we’ll try to answer, like, how do we distinguish between those two? Because sometimes people still ask for managers.
86 00:08:02.040 ⇒ 00:08:09.990 Casie Aviles: Like, you mean, like, how do we distinguish from questions that should be answered by the pest directory, and then the
87 00:08:10.100 ⇒ 00:08:11.189 Casie Aviles: the DB.
88 00:08:13.230 ⇒ 00:08:14.539 Amber Lin: Yeah.
89 00:08:15.750 ⇒ 00:08:16.420 Amber Lin: Because as I said.
90 00:08:17.120 ⇒ 00:08:22.689 Amber Lin: They all ask just one… just the name, and people just put in the name sometimes.
91 00:08:22.690 ⇒ 00:08:28.009 Casie Aviles: Yeah, right now, I don’t think we have a very strong logic to distinguish that, like…
92 00:08:28.620 ⇒ 00:08:38.570 Casie Aviles: So I need to probably improve the prompt and make it clearer, like, which specific question should be answered by the DB, and then which should be answered by the
93 00:08:38.820 ⇒ 00:08:39.900 Casie Aviles: Best directory.
94 00:08:40.989 ⇒ 00:08:47.189 Amber Lin: I see. So let’s see if there was a feedback… Nope…
95 00:08:54.309 ⇒ 00:08:56.969 Amber Lin: Yeah, I think we are…
96 00:08:58.439 ⇒ 00:09:08.299 Amber Lin: lacking on some lawn, inspectors, and then chem-free inspectors. We’ll talk about that in a bit. Let me add…
97 00:09:19.539 ⇒ 00:09:20.629 Amber Lin: Hmm…
98 00:09:26.479 ⇒ 00:09:40.259 Amber Lin: And client wants to… Route fall pest directory… 5 oxygen’s 2… this link.
99 00:09:40.449 ⇒ 00:09:46.689 Amber Lin: And that would include, I think, managers… Phone numbers…
100 00:09:49.589 ⇒ 00:09:56.809 Amber Lin: Supervisor… yeah, anything related to that? And DB questions would cover…
101 00:10:00.759 ⇒ 00:10:01.329 Amber Lin: Where…
102 00:10:01.330 ⇒ 00:10:05.140 Casie Aviles: Where does… yeah, where does someone… service.
103 00:10:06.970 ⇒ 00:10:09.850 Amber Lin: What services… okay.
104 00:10:10.030 ⇒ 00:10:11.580 Amber Lin: I’ll make that issue.
105 00:10:11.800 ⇒ 00:10:16.179 Amber Lin: Wait, that’s one, and then… let’s see…
106 00:10:20.080 ⇒ 00:10:21.640 Amber Lin: Okay, and then delete.
107 00:10:22.440 ⇒ 00:10:30.700 Amber Lin: This one. So, we’re trying to delete him from all of his current assignments. Is there a way we can do that?
108 00:10:32.870 ⇒ 00:10:39.449 Casie Aviles: We do have the, I believe, the delete form, so I’ll use that to delete him.
109 00:10:40.300 ⇒ 00:10:45.080 Amber Lin: It… but don’t we still have to enter the zip code?
110 00:10:45.480 ⇒ 00:10:46.850 Amber Lin: To do that?
111 00:10:47.430 ⇒ 00:10:49.260 Casie Aviles: Oh, yeah, yeah.
112 00:10:49.260 ⇒ 00:10:57.939 Amber Lin: Let me open this, and realistically, we don’t know what zips he’s servicing, we just want to delete all.
113 00:10:58.150 ⇒ 00:11:01.429 Amber Lin: Like, is there a delete all option?
114 00:11:03.060 ⇒ 00:11:05.680 Casie Aviles: No, it’s… you still have to, like…
115 00:11:06.460 ⇒ 00:11:09.430 Casie Aviles: Input, like, the zips, and then the branches.
116 00:11:09.430 ⇒ 00:11:14.990 Amber Lin: That’s a limitation we have with N8N at the moment.
117 00:11:15.150 ⇒ 00:11:22.610 Amber Lin: I see, so not… let me just say not possible with the form for, like, all-around deletion.
118 00:11:23.420 ⇒ 00:11:32.230 Casie Aviles: I mean… It’s possible, but the way it’s designed right now is… like…
119 00:11:33.690 ⇒ 00:11:36.899 Casie Aviles: With, you know, with selecting specific…
120 00:11:37.510 ⇒ 00:11:40.940 Casie Aviles: What do you call the specific branches and zips in mind?
121 00:11:42.820 ⇒ 00:11:48.410 Casie Aviles: Because it’s going to be just a SQL query to have it delete. Yeah.
122 00:11:48.500 ⇒ 00:11:51.050 Amber Lin: So it should be possible, but it’s gonna…
123 00:11:52.010 ⇒ 00:11:56.590 Casie Aviles: It’s gonna, you know, we’re gonna have to think about the design again,
124 00:11:59.880 ⇒ 00:12:01.260 Casie Aviles: of the form.
125 00:12:05.160 ⇒ 00:12:11.860 Amber Lin: Yeah, I think for now, we could run a query and just delete him.
126 00:12:12.360 ⇒ 00:12:14.709 Casie Aviles: Yeah, that’s what I’m planning to do right now.
127 00:12:15.890 ⇒ 00:12:19.839 Amber Lin: Okay, let me assign this to you, and then…
128 00:12:21.500 ⇒ 00:12:25.290 Amber Lin: I’ll make another ticket to adjust the delete form.
129 00:12:27.250 ⇒ 00:12:30.910 Amber Lin: And I will clean this up, I know this is… A lot.
130 00:12:32.000 ⇒ 00:12:33.619 Amber Lin: A form…
131 00:12:38.630 ⇒ 00:12:40.569 Amber Lin: Option to delete.
132 00:12:42.930 ⇒ 00:12:44.170 Amber Lin: Person.
133 00:12:55.590 ⇒ 00:12:56.490 Amber Lin: Okay.
134 00:12:57.120 ⇒ 00:13:11.990 Amber Lin: Alright, that’s the… that’s that. And then lastly, on the updates, is there a way we can add a notes section on their availability, such as, like, oh, this person has blocks at these times.
135 00:13:12.520 ⇒ 00:13:14.310 Amber Lin: Would that be possible?
136 00:13:15.990 ⇒ 00:13:25.319 Casie Aviles: Yeah, I think so, because we have, like, we have a note column. I added a note column to the assignments when I was designing the DB.
137 00:13:25.320 ⇒ 00:13:26.000 Amber Lin: Oh, great.
138 00:13:26.000 ⇒ 00:13:31.319 Casie Aviles: in case… Or, like, you know… Descriptions like that.
139 00:13:31.490 ⇒ 00:13:36.240 Casie Aviles: So, I guess it’s just a matter of… Actually having, like, the input.
140 00:13:36.240 ⇒ 00:13:37.940 Amber Lin: In the form? Oh, okay.
141 00:13:38.470 ⇒ 00:13:41.980 Amber Lin: And… forms.
142 00:13:58.130 ⇒ 00:13:58.850 Amber Lin: Great.
143 00:14:02.240 ⇒ 00:14:12.880 Amber Lin: Right. Next, I have… okay, that should be all the stuff related to the forms for now. We have just some…
144 00:14:15.400 ⇒ 00:14:24.230 Amber Lin: issues… let’s start with the zip codes one. I think I keep seeing… I… I group them into this project.
145 00:14:24.680 ⇒ 00:14:30.809 Amber Lin: And I’ve been keep seeing, like, chem-free inspectors have just not been returning. I’m not sure.
146 00:14:30.810 ⇒ 00:14:31.290 Casie Aviles: Sure.
147 00:14:31.290 ⇒ 00:14:38.479 Amber Lin: keeps… Not there, or just like that one, and then… the same thing.
148 00:14:38.670 ⇒ 00:14:46.490 Amber Lin: It’s like, are we missing that person? Are we not… And also, like, I checked…
149 00:14:46.590 ⇒ 00:14:53.710 Amber Lin: And it returns if I ask differently, but maybe it’s when we say chem-free that it gets confused.
150 00:14:54.670 ⇒ 00:14:59.889 Casie Aviles: Yes, so… The chem-free inspectors exist in the DB, but…
151 00:15:00.510 ⇒ 00:15:05.669 Casie Aviles: I believe, like, the problem here is how the query is being formulated.
152 00:15:05.670 ⇒ 00:15:07.039 Amber Lin: So I need to…
153 00:15:07.940 ⇒ 00:15:18.429 Casie Aviles: I need to keep testing and change, like, the prompt for the query to make sure that it’s able to actually ask for chem-free pests instead of
154 00:15:19.510 ⇒ 00:15:21.760 Casie Aviles: I mean, yeah, the chem-free inspectors.
155 00:15:21.940 ⇒ 00:15:22.550 Amber Lin: Okay.
156 00:15:22.550 ⇒ 00:15:23.260 Casie Aviles: I don’t know.
157 00:15:23.490 ⇒ 00:15:29.740 Amber Lin: Gotcha, okay. That’s… I am going to edit,
158 00:15:30.820 ⇒ 00:15:33.909 Amber Lin: Whatever. Once we do it, we can close the other ones.
159 00:15:34.020 ⇒ 00:15:37.450 Amber Lin: So that’s one thing.
160 00:15:37.750 ⇒ 00:15:45.120 Amber Lin: And then… the lawn zips. Yeah, I got a few feedbacks that the lawn zips are not, like…
161 00:15:45.520 ⇒ 00:15:48.579 Amber Lin: Long Tech Inspector…
162 00:15:52.340 ⇒ 00:15:57.059 Amber Lin: I also don’t… no, this is not a inspector.
163 00:15:59.720 ⇒ 00:16:11.279 Amber Lin: But I think we never end up added… never ended up adding the long sheet, because I forgot… I forgot about it.
164 00:16:11.280 ⇒ 00:16:19.430 Casie Aviles: Yeah, I don’t think I’ve added lots of lawn inspectors. I just added, like, the one from the spreadsheet hub.
165 00:16:19.430 ⇒ 00:16:24.710 Amber Lin: Yeah, let me go find the lawn one, and we can go add that.
166 00:16:24.830 ⇒ 00:16:40.129 Amber Lin: In the spreadsheet, so, that would be… lawn… documents, and that would be… This one, I think.
167 00:16:41.110 ⇒ 00:16:43.570 Amber Lin: Scheduling guide? Nope.
168 00:16:44.440 ⇒ 00:16:45.630 Amber Lin: issuing.
169 00:16:46.600 ⇒ 00:16:49.240 Amber Lin: Hmm…
170 00:16:53.510 ⇒ 00:16:55.440 Amber Lin: Like that.
171 00:16:56.780 ⇒ 00:16:57.700 Amber Lin: Oh.
172 00:16:57.840 ⇒ 00:16:58.980 Amber Lin: There we go.
173 00:16:59.570 ⇒ 00:17:08.369 Amber Lin: It’s, like, law… I think… I don’t know. Lawn… care? Lawn… commercial mowing?
174 00:17:09.720 ⇒ 00:17:13.999 Amber Lin: lawn mowing, commercial mowing, I think that’s what it means.
175 00:17:14.510 ⇒ 00:17:17.359 Amber Lin: So, I think, like.
176 00:17:17.480 ⇒ 00:17:30.480 Amber Lin: These are notes on when they’re available. It is so complicated. And then… commercial lawn mowing, residential mowing… okay.
177 00:17:30.650 ⇒ 00:17:38.050 Amber Lin: So we will… we’ll need to add this. Let me…
178 00:17:39.850 ⇒ 00:17:43.030 Amber Lin: Let me grab this… Coffee.
179 00:17:48.010 ⇒ 00:17:53.219 Amber Lin: I know you’re working on some other stuff, and Stella, do you have availability to help on some stuff?
180 00:17:55.180 ⇒ 00:17:58.229 Casie Aviles: No, I’m free here for ABC.
181 00:17:58.450 ⇒ 00:17:59.070 Amber Lin: Oh, okay.
182 00:17:59.070 ⇒ 00:17:59.650 Mustafa Raja: Okay.
183 00:18:00.230 ⇒ 00:18:06.150 Casie Aviles: I don’t really have… much to work on, because I only have today and tomorrow.
184 00:18:06.350 ⇒ 00:18:08.849 Amber Lin: Gotcha. At lawn…
185 00:18:09.670 ⇒ 00:18:12.430 Mustafa Raja: Yes, I have a similar case.
186 00:18:12.430 ⇒ 00:18:17.430 Amber Lin: Okay, makes sense. Add the lawn… Inspector sheet.
187 00:18:17.600 ⇒ 00:18:18.810 Amber Lin: needs…
188 00:18:19.890 ⇒ 00:18:31.099 Amber Lin: Like, clean up and add. I’ll just create these issues, and we can, like, delegate and assign between us.
189 00:18:31.100 ⇒ 00:18:31.640 Mustafa Raja: Okay.
190 00:18:31.820 ⇒ 00:18:34.559 Amber Lin: Same thing, chem-free.
191 00:18:44.880 ⇒ 00:18:47.499 Amber Lin: Same thing, so I’ll just put it on mute there.
192 00:18:47.850 ⇒ 00:18:50.999 Amber Lin: Yeah, this one. This one.
193 00:18:51.780 ⇒ 00:18:52.400 Casie Aviles: Yeah.
194 00:18:53.030 ⇒ 00:19:00.430 Amber Lin: Yeah, department… I’m working with Janiece to create… actually, that’s one of the topics I wanted to talk about.
195 00:19:00.620 ⇒ 00:19:09.939 Amber Lin: Is that… We keep getting questions about what department gets this, and the problem is that
196 00:19:10.350 ⇒ 00:19:28.759 Amber Lin: pests people only has access to the pest central dock that only has pest coverage, and so they have no clue… that Andy has no clue of who does trash bins, and so Andy’s not gonna get anything about trash bins, but she gets calls
197 00:19:28.840 ⇒ 00:19:39.149 Amber Lin: with upsells, and they’re like, oh, I also want trash bins, but she doesn’t know where to route it. So, we’re trying to create a master coverage that covers all departments.
198 00:19:39.300 ⇒ 00:19:45.069 Amber Lin: And I was… I wanted to ask you guys, how can everyone access the same
199 00:19:45.240 ⇒ 00:19:59.479 Amber Lin: thing, like, the same coverage list, because it can’t be in… like, one option, we can just copy and paste it in each of their central docs, or we create a separate source. Like, what do you guys.
200 00:19:59.480 ⇒ 00:20:00.330 Mustafa Raja: busting.
201 00:20:01.370 ⇒ 00:20:05.440 Mustafa Raja: So, how it is set up right now is, I think there…
202 00:20:09.750 ⇒ 00:20:11.300 Mustafa Raja: Yeah, this is weird.
203 00:20:12.940 ⇒ 00:20:13.820 Mustafa Raja: Okay.
204 00:20:14.420 ⇒ 00:20:20.290 Mustafa Raja: Copies. Let’s see if we can add filters to… our vectors tool.
205 00:20:25.120 ⇒ 00:20:28.040 Mustafa Raja: Okay, so everyone should have access to that, right?
206 00:20:28.950 ⇒ 00:20:33.760 Amber Lin: I guess we can attach an, casey, I guess we can attach a new…
207 00:20:33.790 ⇒ 00:20:43.439 Mustafa Raja: Vector, vector database, and have a document, over there, with no filters at all.
208 00:20:43.720 ⇒ 00:20:50.660 Mustafa Raja: So Andy always has access to it, whoever, whoever may be the person trying to query.
209 00:20:50.920 ⇒ 00:20:51.670 Mustafa Raja: What do you think about that?
210 00:20:51.670 ⇒ 00:20:52.300 Casie Aviles: Okay.
211 00:20:52.760 ⇒ 00:20:58.110 Casie Aviles: Yeah, so it’s going to be, like, a separate, like, central dock, but it’s for everyone? Is that…
212 00:20:58.110 ⇒ 00:20:58.590 Mustafa Raja: Yay.
213 00:20:59.530 ⇒ 00:21:00.390 Casie Aviles: Okay.
214 00:21:00.960 ⇒ 00:21:08.180 Mustafa Raja: Yeah, because, the other case would be that each central dog would have the same information, which is repetitive.
215 00:21:09.260 ⇒ 00:21:09.710 Casie Aviles: Yeah.
216 00:21:09.710 ⇒ 00:21:12.700 Amber Lin: It’s hard, because someone will update it here, and then the other one.
217 00:21:12.700 ⇒ 00:21:13.680 Mustafa Raja: Yeah, yeah.
218 00:21:13.790 ⇒ 00:21:19.069 Mustafa Raja: We’ll have to update it everywhere, even if it’s a small thing, right?
219 00:21:19.530 ⇒ 00:21:32.200 Amber Lin: Yeah, it’s not… it’s just, like, a few lines. Db, that… Everyone has… Axis, too. Okay.
220 00:21:32.200 ⇒ 00:21:34.490 Mustafa Raja: Yeah, this should be pretty simple to set up.
221 00:21:34.740 ⇒ 00:21:40.859 Amber Lin: Okay, so… Let me know once you’ve created that document.
222 00:21:40.990 ⇒ 00:21:44.830 Amber Lin: So, I’ll say tap.
223 00:21:45.060 ⇒ 00:21:50.730 Amber Lin: Amber in Slack, because I don’t check this enough, once…
224 00:21:50.980 ⇒ 00:21:53.810 Amber Lin: Document… I think it’ll be a Google Doc, right?
225 00:21:54.860 ⇒ 00:21:59.390 Mustafa Raja: Yeah, but do I know the content that needs to go into that doc?
226 00:21:59.810 ⇒ 00:22:04.439 Amber Lin: I think you can start with this, and then…
227 00:22:04.440 ⇒ 00:22:05.280 Mustafa Raja: It’s so…
228 00:22:05.280 ⇒ 00:22:08.020 Amber Lin: then I will go and add more.
229 00:22:08.410 ⇒ 00:22:11.349 Mustafa Raja: Okay, okay, yeah, yeah, I’ll set this up.
230 00:22:11.840 ⇒ 00:22:12.800 Amber Lin: Great.
231 00:22:13.480 ⇒ 00:22:14.610 Amber Lin: Mmm…
232 00:22:14.610 ⇒ 00:22:16.509 Mustafa Raja: And this, this ticket is…
233 00:22:17.530 ⇒ 00:22:22.070 Mustafa Raja: To also set up the vector store and connect it to, Andy, right?
234 00:22:22.800 ⇒ 00:22:24.659 Amber Lin: Huh? Sorry, what does that mean?
235 00:22:24.660 ⇒ 00:22:32.410 Mustafa Raja: I also need to, connect Andy with with this document.
236 00:22:32.410 ⇒ 00:22:33.480 Amber Lin: Yes, yes.
237 00:22:33.480 ⇒ 00:22:35.660 Mustafa Raja: So, let’s do…
238 00:22:36.630 ⇒ 00:22:38.609 Amber Lin: Check through, and then…
239 00:22:46.390 ⇒ 00:22:48.869 Amber Lin: How much time would this take? Like, an hour?
240 00:22:50.810 ⇒ 00:22:52.080 Mustafa Raja: Let’s do two points.
241 00:22:52.510 ⇒ 00:22:54.710 Casie Aviles: Yeah, maybe two. I just…
242 00:22:55.110 ⇒ 00:23:07.300 Amber Lin: Makes sense. Alright, that’s great, so that’s the first one. Talked about that, and then mechanical. I think we’re… we keep getting feedback of, oh, this… how…
243 00:23:07.400 ⇒ 00:23:19.259 Amber Lin: what’s the price to send out plumbing to this zip code? And after a bit, I figured it’s because they have specific prices for different zip codes.
244 00:23:19.940 ⇒ 00:23:20.860 Amber Lin: Link.
245 00:23:20.860 ⇒ 00:23:21.610 Casie Aviles: of…
246 00:23:21.610 ⇒ 00:23:24.419 Amber Lin: this cost. Some zip codes are that cost.
247 00:23:24.530 ⇒ 00:23:29.120 Amber Lin: When we’re adding it, do we see something?
248 00:23:31.740 ⇒ 00:23:38.189 Amber Lin: Do we see something on, like… Chem… bleh, sorry.
249 00:23:38.460 ⇒ 00:23:41.340 Amber Lin: Like, the prices for different zips?
250 00:23:41.870 ⇒ 00:23:45.349 Amber Lin: Do you think it’s anywhere? Because we’re not getting those questions right.
251 00:23:45.510 ⇒ 00:23:52.109 Mustafa Raja: So, part of the reason why that was wrong was,
252 00:23:52.650 ⇒ 00:23:57.519 Mustafa Raja: When they would ask for, plumbing, prices, and you would fetch up.
253 00:23:57.660 ⇒ 00:24:07.700 Mustafa Raja: the, electrical prices for… for them. I think if we, if we, if, if we improve the wording of
254 00:24:07.810 ⇒ 00:24:11.540 Mustafa Raja: Central dock, that might improve.
255 00:24:12.710 ⇒ 00:24:14.449 Mustafa Raja: The fetch.
256 00:24:15.420 ⇒ 00:24:19.620 Amber Lin: Hmm… Yeah, I…
257 00:24:20.060 ⇒ 00:24:23.549 Mustafa Raja: And this is something that I might have made a comment on.
258 00:24:23.680 ⇒ 00:24:26.710 Mustafa Raja: Because I was assigned… yeah.
259 00:24:26.900 ⇒ 00:24:35.829 Mustafa Raja: If we look into, ABC839, I’ve, I’ve investigated this, and added some content.
260 00:24:36.210 ⇒ 00:24:37.050 Amber Lin: Oh, okay.
261 00:24:37.850 ⇒ 00:24:43.140 Amber Lin: 8, 30, 30, mmm… 39?
262 00:24:43.140 ⇒ 00:24:43.890 Mustafa Raja: 839, yeah.
263 00:24:49.420 ⇒ 00:24:51.150 Amber Lin: Yeah…
264 00:24:51.320 ⇒ 00:24:56.500 Mustafa Raja: Yeah, so, okay, for this, this one was for residential and commercial.
265 00:25:01.460 ⇒ 00:25:04.670 Mustafa Raja: According to the commercial college, $74.
266 00:25:08.530 ⇒ 00:25:28.019 Mustafa Raja: Yeah, so this is for plumbing, right? The question was for plumbing, and what Andy does is it looks for… is it looking into electrical service fees? And it does not know that it’s looking into electrical prices, because it’s not included in the points, in the bullets. If we say over here…
267 00:25:28.830 ⇒ 00:25:42.070 Mustafa Raja: If we say… if instead of just saying, 4, and whatever, 4 residential, 4 commercial, instead we say electrical service fee for commercial, or electrical… electrical service fee…
268 00:25:42.780 ⇒ 00:25:44.769 Mustafa Raja: Residential, that will improve that.
269 00:25:45.250 ⇒ 00:25:46.290 Amber Lin: Okay.
270 00:25:46.860 ⇒ 00:25:48.439 Mustafa Raja: Yeah, it’s weird enough.
271 00:25:48.440 ⇒ 00:25:52.429 Amber Lin: If you’re plumbing, does Andy even know plumbing falls under electrical?
272 00:25:54.820 ⇒ 00:25:59.889 Mustafa Raja: No, no, Andy does not know that he’s looking into, electrical at all.
273 00:26:01.790 ⇒ 00:26:16.139 Mustafa Raja: Weird thing over here is that, the heading, in the metadata, if we look, we’ll see that it’s only, fees, not electrical service fees. I don’t know why that’s happening, that needs further investigation.
274 00:26:16.580 ⇒ 00:26:26.809 Mustafa Raja: So Andy doesn’t know it’s looking into, electrical. Andy thinks, okay, these are residential prices, these are commercial prices, they must be for plumbing.
275 00:26:29.840 ⇒ 00:26:33.070 Mustafa Raja: It infers… it infers that this is for plumbing.
276 00:26:36.040 ⇒ 00:26:37.260 Amber Lin: I see.
277 00:26:37.590 ⇒ 00:26:51.610 Mustafa Raja: So, we can make it better if we add, add the bullets, electrical service fees for residential, electrical service fees for commercial, so Andy will then definitely know, oh, this is for electrical, and I am asked for plumbing.
278 00:26:52.040 ⇒ 00:26:52.870 Amber Lin: Okay.
279 00:26:53.130 ⇒ 00:26:56.719 Mustafa Raja: Yeah, this is how, I think we can improve.
280 00:26:57.460 ⇒ 00:26:58.330 Amber Lin: Okay.
281 00:26:58.500 ⇒ 00:27:05.000 Mustafa Raja: And, Casey, what do you think? I think we should also increase What’s it called?
282 00:27:05.320 ⇒ 00:27:08.410 Mustafa Raja: The character length that we are embedding.
283 00:27:09.160 ⇒ 00:27:10.250 Mustafa Raja: per document.
284 00:27:10.680 ⇒ 00:27:14.290 Casie Aviles: Yeah, we could do that as well, so we could capture more context.
285 00:27:14.290 ⇒ 00:27:17.070 Mustafa Raja: Yeah, yeah, I think that’s… that’s also limiting.
286 00:27:17.190 ⇒ 00:27:18.560 Mustafa Raja: some context.
287 00:27:24.800 ⇒ 00:27:25.410 Amber Lin: Another way.
288 00:27:25.410 ⇒ 00:27:27.770 Mustafa Raja: This might be a big ticket, though.
289 00:27:27.770 ⇒ 00:27:29.650 Amber Lin: Yeah, I agree.
290 00:27:30.230 ⇒ 00:27:38.679 Amber Lin: Like, like, spreadsheet for that, or if we have more vectors and it’s the same thing.
291 00:27:39.190 ⇒ 00:27:45.100 Mustafa Raja: So the, in regards to how we can make this better, right?
292 00:27:45.620 ⇒ 00:27:46.460 Amber Lin: Yeah.
293 00:27:46.670 ⇒ 00:27:48.559 Mustafa Raja: So, I think…
294 00:27:49.110 ⇒ 00:28:05.259 Mustafa Raja: spreadsheet would be overhead, because just adding more context in the bullet should be able to cover that. I guess we can test it first, and then be sure about it before committing to spreadsheets.
295 00:28:05.730 ⇒ 00:28:07.960 Casie Aviles: But spreadsheets are a good idea.
296 00:28:13.400 ⇒ 00:28:20.660 Amber Lin: Let me see… It’s… it’s… I think it’s just that some of the… ugh, it’s like…
297 00:28:21.200 ⇒ 00:28:25.549 Amber Lin: For certain zip codes only, they don’t charge a fee.
298 00:28:25.980 ⇒ 00:28:27.839 Amber Lin: It’s so confusing.
299 00:28:28.780 ⇒ 00:28:29.490 Amber Lin: Okay, let me…
300 00:28:29.490 ⇒ 00:28:35.759 Mustafa Raja: Yeah, do we have that in the, this central doc?
301 00:28:35.760 ⇒ 00:28:39.059 Amber Lin: No, but let me go ask that…
302 00:28:49.290 ⇒ 00:28:51.440 Mustafa Raja: Oh yeah, this is the other ticket that I was looking to.
303 00:29:01.820 ⇒ 00:29:06.240 Amber Lin: Okay, great, I assigned it to her. To do…
304 00:29:07.720 ⇒ 00:29:15.030 Amber Lin: Alright, okay. Those were the main things I wanted to discuss. We’re at 30 minutes, and…
305 00:29:15.150 ⇒ 00:29:28.359 Amber Lin: In case you missed out, you guys think, and let me know, like, if you guys want to interchange the tickets, it’s totally fine. I will try and clean this up. There’s so many tickets here.
306 00:29:28.940 ⇒ 00:29:29.680 Mustafa Raja: Yeah…
307 00:29:29.680 ⇒ 00:29:33.450 Amber Lin: Ugh, I’ll probably, like, move some stuff next week.
308 00:29:33.760 ⇒ 00:29:39.899 Amber Lin: And… try and fix it, but a lot of it are repetitive, so hopefully we’re…
309 00:29:39.900 ⇒ 00:29:40.580 Mustafa Raja: Yet.
310 00:29:41.200 ⇒ 00:29:42.050 Casie Aviles: Okay, yeah.
311 00:29:42.050 ⇒ 00:29:42.590 Amber Lin: Okay.
312 00:29:42.590 ⇒ 00:29:45.540 Casie Aviles: Let’s work on this as much as I can for this week.
313 00:29:45.990 ⇒ 00:29:46.600 Amber Lin: Okay.
314 00:29:46.600 ⇒ 00:29:47.270 Mustafa Raja: Same.
315 00:29:47.670 ⇒ 00:29:49.379 Amber Lin: Yeah, thanks everyone.
316 00:29:49.960 ⇒ 00:29:50.590 Mustafa Raja: you…
317 00:29:50.590 ⇒ 00:29:51.460 Amber Lin: Great, bye!
318 00:29:51.460 ⇒ 00:29:52.000 Casie Aviles: Thank you.
319 00:29:52.000 ⇒ 00:29:52.560 Mustafa Raja: Hi.