Meeting Title: ABC Zips Database Sync Date: 2025-09-11 Meeting participants: Awaish Kumar, Casie Aviles
WEBVTT
1 00:01:26.730 ⇒ 00:01:27.950 Casie Aviles: AOE.
2 00:01:30.090 ⇒ 00:01:30.920 Awaish Kumar: Hello?
3 00:01:31.230 ⇒ 00:01:32.450 Casie Aviles: Oh, how are you?
4 00:01:32.890 ⇒ 00:01:34.479 Awaish Kumar: I’m good, how about yours?
5 00:01:35.290 ⇒ 00:01:39.799 Casie Aviles: Yeah, doing good. Hopefully the weather is better there now.
6 00:01:41.910 ⇒ 00:01:44.780 Awaish Kumar: Yeah, today’s good.
7 00:01:47.350 ⇒ 00:01:48.799 Casie Aviles: Yeah, I hear it’s.
8 00:01:48.800 ⇒ 00:01:49.150 Awaish Kumar: Hold on!
9 00:01:49.580 ⇒ 00:01:51.300 Casie Aviles: Raining a lot, yeah.
10 00:01:51.920 ⇒ 00:01:53.600 Awaish Kumar: Where do you live?
11 00:01:54.100 ⇒ 00:01:55.520 Casie Aviles: Philippines.
12 00:01:55.920 ⇒ 00:01:58.229 Awaish Kumar: No, no, I mean, like, which city in the Philippine?
13 00:01:58.780 ⇒ 00:02:04.820 Casie Aviles: Oh, it’s a… it’s a province, so I’m far away from the capital. I’m somewhere in the north.
14 00:02:07.360 ⇒ 00:02:10.750 Awaish Kumar: Okay. Is it a nice place to visit?
15 00:02:11.560 ⇒ 00:02:23.270 Casie Aviles: I think it’s… it’s very quiet, so there’s not a lot to do here. But in other places, there are beaches, so those are nicer.
16 00:02:25.160 ⇒ 00:02:28.810 Casie Aviles: My place is not the most tourist-friendly.
17 00:02:30.240 ⇒ 00:02:31.360 Awaish Kumar: Oh, okay.
18 00:02:33.820 ⇒ 00:02:40.229 Awaish Kumar: Yeah, I just want to visit, like, live like a local, not just as a visitor.
19 00:02:41.250 ⇒ 00:02:48.580 Casie Aviles: Yeah, that’s true, I mean… Yeah, like, the problem sometimes is, you know, you’d get, like.
20 00:02:48.740 ⇒ 00:02:52.570 Casie Aviles: Tourist traps, you know, like, expensive.
21 00:02:52.570 ⇒ 00:02:53.290 Awaish Kumar: Yeah, yeah.
22 00:02:53.290 ⇒ 00:03:05.169 Casie Aviles: Just because you’re a tourist, but yeah. I think it’s all… it’s fine here, it’s just, you know, very quiet, there’s not a lot of stuff to do here in my area. It’s nice for living, but…
23 00:03:05.460 ⇒ 00:03:08.790 Casie Aviles: Not for visiting, I guess.
24 00:03:09.510 ⇒ 00:03:10.190 Awaish Kumar: Okay, okay.
25 00:03:10.190 ⇒ 00:03:12.069 Casie Aviles: But you… Is that yours?
26 00:03:12.430 ⇒ 00:03:15.050 Awaish Kumar: Is it… are there any mountains?
27 00:03:16.390 ⇒ 00:03:22.930 Casie Aviles: Yeah, actually, this place is very mountainous. I guess there are some…
28 00:03:23.330 ⇒ 00:03:26.939 Casie Aviles: Indigenous people here, also, that you could also…
29 00:03:27.610 ⇒ 00:03:33.130 Casie Aviles: learn about, I think it’s mostly that, you know, mountains,
30 00:03:33.910 ⇒ 00:03:37.529 Casie Aviles: Okay. Lots of rice fields. Yeah.
31 00:03:40.230 ⇒ 00:03:48.250 Awaish Kumar: Okay, so, like, what do you normally, like, how do you…
32 00:03:49.520 ⇒ 00:03:54.760 Awaish Kumar: Like, what is a common, like, the… Trade, or…
33 00:03:54.880 ⇒ 00:03:56.950 Awaish Kumar: Like, what normally people do there?
34 00:03:57.960 ⇒ 00:04:05.920 Casie Aviles: Oh, in my area, so since we’re in the province, we’re quite agricultural, so that’s why I mentioned there are…
35 00:04:06.100 ⇒ 00:04:10.670 Casie Aviles: A lot of rice fields here, so a lot of people are farmers.
36 00:04:12.030 ⇒ 00:04:12.700 Awaish Kumar: Okay.
37 00:04:13.090 ⇒ 00:04:18.290 Casie Aviles: And then… Yeah, unlike in Manila, where
38 00:04:18.529 ⇒ 00:04:23.090 Casie Aviles: I think most of the Filipino team members live in
39 00:04:23.780 ⇒ 00:04:27.059 Casie Aviles: Manila is, like, our capital, so there’s a lot of…
40 00:04:29.320 ⇒ 00:04:35.859 Casie Aviles: That’s urban, you know, it’s a more urban place, so there’s a lot of malls, shopping malls, yeah, cars.
41 00:04:35.940 ⇒ 00:04:40.349 Awaish Kumar: How do you, like, people live normally in Philippine, like, in joint families, or…
42 00:04:40.740 ⇒ 00:04:43.920 Awaish Kumar: Alone, or… What’s the culture?
43 00:04:44.340 ⇒ 00:04:51.269 Casie Aviles: Yeah, it’s more like joint families here, so right now I’m actually with… living with my parents, but…
44 00:04:51.540 ⇒ 00:04:53.849 Casie Aviles: Before, I used to live alone.
45 00:04:54.100 ⇒ 00:04:57.560 Casie Aviles: But, yeah, I chose to just stay here since…
46 00:04:58.080 ⇒ 00:05:03.150 Casie Aviles: We’re a very small family, yeah. But yeah, normally it’s joint families.
47 00:05:03.790 ⇒ 00:05:05.350 Awaish Kumar: You shame like us, right?
48 00:05:07.680 ⇒ 00:05:13.420 Awaish Kumar: So, like, Pakistani, also, like… Well, we live in joint families.
49 00:05:14.210 ⇒ 00:05:17.149 Casie Aviles: Oh, thanks. So you’re with your family as well?
50 00:05:17.340 ⇒ 00:05:19.300 Awaish Kumar: Yeah, yeah, from my parents, like…
51 00:05:19.770 ⇒ 00:05:24.329 Awaish Kumar: like, it’s… it’s… it’s not a concept, like, in Europeans, like, that you live with…
52 00:05:25.170 ⇒ 00:05:30.479 Awaish Kumar: That’s true. You’re living with your parents, or you’re living… like, we’re just living together, living in one home, right?
53 00:05:30.620 ⇒ 00:05:31.480 Casie Aviles: Mmm.
54 00:05:31.480 ⇒ 00:05:40.509 Awaish Kumar: your father is earning, that’s good. If he’s not, like, you’re taking care of her anymore, that’s also okay, right? So we don’t have this European concept of.
55 00:05:42.410 ⇒ 00:05:42.880 Casie Aviles: Right.
56 00:05:42.880 ⇒ 00:05:46.830 Awaish Kumar: at homes for kids, like, It’s a different, like, culture, like…
57 00:05:47.330 ⇒ 00:06:01.510 Casie Aviles: Yeah, same here in the Philippines. Although, yeah, some… some kids are starting to be more westernized, right? And so they also kind of want to live by themselves. But traditionally, we are also.
58 00:06:02.600 ⇒ 00:06:04.009 Casie Aviles: Yeah, we just live as…
59 00:06:04.010 ⇒ 00:06:08.369 Awaish Kumar: Yeah, traditionally, traditionally, everybody used to live like that, right?
60 00:06:08.370 ⇒ 00:06:09.110 Casie Aviles: Yeah.
61 00:06:09.110 ⇒ 00:06:18.030 Awaish Kumar: Europeans also, like, a few years back were, like, conjoined families, but now, They’re evolved to…
62 00:06:18.510 ⇒ 00:06:23.360 Awaish Kumar: They have made the systems such that they prefer to live or not.
63 00:06:24.280 ⇒ 00:06:25.419 Casie Aviles: That’s true, yeah.
64 00:06:31.700 ⇒ 00:06:32.610 Awaish Kumar: Okay, yeah.
65 00:06:32.610 ⇒ 00:06:33.590 Casie Aviles: Yeah.
66 00:06:34.220 ⇒ 00:06:35.050 Awaish Kumar: Hmm…
67 00:06:35.470 ⇒ 00:06:37.970 Casie Aviles: Alright, yeah, thank you for the chat.
68 00:06:38.150 ⇒ 00:06:41.479 Casie Aviles: I was just, sharing my screen here.
69 00:06:41.960 ⇒ 00:06:45.839 Casie Aviles: For… this is, like, what I’m just showing is…
70 00:06:46.370 ⇒ 00:06:53.969 Casie Aviles: the work that I’ve done so far, so… I think… Let me just go through…
71 00:06:57.090 ⇒ 00:06:59.580 Casie Aviles: Yeah, the schema Visualizer, so…
72 00:07:00.460 ⇒ 00:07:10.740 Casie Aviles: Right now, we have these tables, so I’ve created, like, our primary tables would be the people table, we’ve got services and locations.
73 00:07:11.320 ⇒ 00:07:17.029 Casie Aviles: And then we also have roles, which should contain, like, if you recall the…
74 00:07:17.780 ⇒ 00:07:23.250 Casie Aviles: Like, if they’re an inspector or a technician, so… and then we have the assignments. Okay.
75 00:07:23.250 ⇒ 00:07:29.620 Awaish Kumar: I… I just wanted to say that, like, we don’t have a very big database, so why, like…
76 00:07:29.810 ⇒ 00:07:33.780 Awaish Kumar: Don’t we just put a role in, in people’s…
77 00:07:35.380 ⇒ 00:07:38.870 Awaish Kumar: table, like, each person and their role, role ID,
78 00:07:39.650 ⇒ 00:07:44.719 Awaish Kumar: Like, although your structure is good, like, makes much more sense.
79 00:07:45.020 ⇒ 00:07:48.190 Casie Aviles: But just because we have… we don’t have, like.
80 00:07:48.550 ⇒ 00:07:50.519 Awaish Kumar: really large data. We only have…
81 00:07:50.700 ⇒ 00:07:55.869 Awaish Kumar: A few… maybe a hundred… a thousand rolls, or 500… maybe 5,000 rolls.
82 00:07:56.520 ⇒ 00:07:56.890 Casie Aviles: Okay.
83 00:07:56.890 ⇒ 00:08:02.130 Awaish Kumar: Well, that, like… If we have simplified infrastructure, it will be easier to carry.
84 00:08:02.740 ⇒ 00:08:03.270 Awaish Kumar: language.
85 00:08:03.270 ⇒ 00:08:04.260 Casie Aviles: Mmm.
86 00:08:04.260 ⇒ 00:08:09.190 Awaish Kumar: Instead of writing drawings and all of that stuff in a query, if you just make a simple table.
87 00:08:09.380 ⇒ 00:08:12.950 Awaish Kumar: It could just… Without drawing, we can write a query, right?
88 00:08:14.200 ⇒ 00:08:17.840 Casie Aviles: Yeah, okay, yeah, that makes sense. I think that’s something I can…
89 00:08:19.500 ⇒ 00:08:24.110 Casie Aviles: update here. So, basically, we just moved the rules to people.
90 00:08:24.520 ⇒ 00:08:25.220 Awaish Kumar: Yeah.
91 00:08:25.920 ⇒ 00:08:32.010 Casie Aviles: Okay, but I’m wondering, like, what if people have multiple roles, so…
92 00:08:32.179 ⇒ 00:08:40.179 Casie Aviles: Because these are just two roles for now, and I think maybe we’ll have more in the future. Like, right now we just have Inspector and…
93 00:08:40.490 ⇒ 00:08:46.159 Casie Aviles: technician, but some… I believe we might have, like, more roles in the future.
94 00:08:48.420 ⇒ 00:08:51.150 Casie Aviles: And people in multiple rows.
95 00:08:51.990 ⇒ 00:08:54.900 Awaish Kumar: I agree with Jar, like, we could have the…
96 00:08:55.130 ⇒ 00:09:01.650 Awaish Kumar: Yeah, that’s what I’m saying. Like, in… what I’m… I was suggesting in that case, you… what will happen is.
97 00:09:02.070 ⇒ 00:09:07.049 Awaish Kumar: We just have two rows for the same person, right? In a people’s tab.
98 00:09:07.450 ⇒ 00:09:13.110 Awaish Kumar: So, person name, And kind of role name will become a primary key.
99 00:09:13.310 ⇒ 00:09:19.609 Awaish Kumar: But, like, But that’s okay, right? We don’t need to change. Like, it’s not a very…
100 00:09:20.900 ⇒ 00:09:21.370 Casie Aviles: Okay.
101 00:09:21.370 ⇒ 00:09:23.859 Awaish Kumar: I, like, something…
102 00:09:25.780 ⇒ 00:09:33.219 Casie Aviles: Okay, yeah, because I wanted… the idea here is, like, I wanted the people here to be unique.
103 00:09:33.220 ⇒ 00:09:33.680 Awaish Kumar: Oh, my God.
104 00:09:33.680 ⇒ 00:09:34.360 Casie Aviles: Yeah.
105 00:09:34.360 ⇒ 00:09:39.930 Awaish Kumar: Yeah, I understand, like, you… what you… what you’re dealing… I’m not…
106 00:09:40.030 ⇒ 00:09:44.210 Awaish Kumar: Again, that, like, the structure is good. I’m just saying that…
107 00:09:44.730 ⇒ 00:09:47.219 Awaish Kumar: like, there are two things. One is.
108 00:09:47.580 ⇒ 00:09:56.229 Awaish Kumar: normalization, right? And another thing is denormalization, and normally, when we have small data, we want to
109 00:09:56.520 ⇒ 00:10:01.960 Awaish Kumar: Minimizes the complexity and speed up the query retrieval time.
110 00:10:02.520 ⇒ 00:10:06.280 Awaish Kumar: Because we don’t… Care about storage here, right?
111 00:10:06.420 ⇒ 00:10:14.570 Awaish Kumar: So, that’s why. What I’m saying is based because of that, but that’s okay, like, if you’ve already implemented that, we’ll just go with this.
112 00:10:15.690 ⇒ 00:10:16.480 Casie Aviles: Okay.
113 00:10:16.580 ⇒ 00:10:20.750 Casie Aviles: Yeah, alright, I’ll maintain this then. Yeah, I was just…
114 00:10:21.110 ⇒ 00:10:25.590 Casie Aviles: Thinking about this, when it… when… And it will have more…
115 00:10:25.590 ⇒ 00:10:27.729 Awaish Kumar: Okay. We just,
116 00:10:28.270 ⇒ 00:10:37.799 Awaish Kumar: But yeah, structure is good. I already reviewed it, so it looks good. I didn’t want to discuss that. I just want to… if you have any questions, I just want to answer that, plus
117 00:10:38.720 ⇒ 00:10:44.130 Awaish Kumar: I want to discuss how we are going to handle future incoming requests.
118 00:10:44.600 ⇒ 00:10:45.210 Awaish Kumar: Excellent.
119 00:10:45.210 ⇒ 00:10:47.579 Casie Aviles: Yes, yes. Okay, so…
120 00:10:47.810 ⇒ 00:10:55.230 Casie Aviles: Yeah, like, for now, when I edit this, I have to go to Assignments, and I have to add, like, a new row here.
121 00:10:56.060 ⇒ 00:11:03.149 Casie Aviles: And… So far, what we know is that we’ll be getting the data from the forms, so…
122 00:11:03.990 ⇒ 00:11:09.030 Casie Aviles: Okay. Do you think that we should, like, create an automation that will…
123 00:11:09.340 ⇒ 00:11:15.820 Awaish Kumar: Yeah, yeah, so… Okay, I… Yeah, we can discuss here. I don’t have your,
124 00:11:16.930 ⇒ 00:11:21.520 Awaish Kumar: whiteboard, but I can write it here, if you… if you can see my screen.
125 00:11:22.120 ⇒ 00:11:22.820 Casie Aviles: Yes.
126 00:11:23.100 ⇒ 00:11:31.520 Awaish Kumar: Okay, so, like… For example, somebody formed… filled a form.
127 00:11:32.360 ⇒ 00:11:35.340 Awaish Kumar: Right? This should be the flow, right?
128 00:11:36.580 ⇒ 00:11:41.639 Awaish Kumar: If you can just scroll down to an empty page, so we can see my drawing.
129 00:11:44.010 ⇒ 00:11:52.439 Awaish Kumar: Yeah, if… so we have a form that a user fills in, right? Now, this data goes to the Google Sheet, right?
130 00:11:54.790 ⇒ 00:12:01.609 Awaish Kumar: This data forms will go and get stored in somewhere, right? In a Google Sheet or something.
131 00:12:02.930 ⇒ 00:12:04.930 Casie Aviles: Yeah, I think they manually do that.
132 00:12:05.640 ⇒ 00:12:07.619 Casie Aviles: the… the clients.
133 00:12:08.760 ⇒ 00:12:12.400 Awaish Kumar: No, no, like, for example, if I build a Google form.
134 00:12:12.970 ⇒ 00:12:16.000 Awaish Kumar: At the end, my data is going to be stored somewhere, right?
135 00:12:16.220 ⇒ 00:12:17.390 Casie Aviles: Yes, yes, yes.
136 00:12:17.770 ⇒ 00:12:24.890 Awaish Kumar: So, like, are there forms, Google forms, or how they… like, where do they fill form?
137 00:12:28.330 ⇒ 00:12:32.920 Casie Aviles: So… You’re asking, like, who is filling out the forms?
138 00:12:32.920 ⇒ 00:12:37.090 Awaish Kumar: No, no. What that’s… like, is it a Google form, or what it is?
139 00:12:37.430 ⇒ 00:12:39.859 Casie Aviles: Yeah, yeah, it’s a Google form. This is.
140 00:12:39.860 ⇒ 00:12:43.529 Awaish Kumar: Like… Yeah. So, like, for each Google form.
141 00:12:43.850 ⇒ 00:12:49.739 Awaish Kumar: there is something connected in the back, right? Where you… where did the data goes, right?
142 00:12:49.740 ⇒ 00:12:50.760 Casie Aviles: Yes, yes.
143 00:12:51.080 ⇒ 00:12:56.629 Awaish Kumar: And with… so I’m asking that, does it… it gets stored to a Google Sheet or somewhere else?
144 00:12:58.310 ⇒ 00:13:02.809 Casie Aviles: Just Google Sheet. I don’t think it’s being stored somewhere else at the moment.
145 00:13:02.810 ⇒ 00:13:10.759 Awaish Kumar: Google Sheet, right? So, for example, I fill that form, and I submit the form. That entry will go to a Google Sheet, right?
146 00:13:11.510 ⇒ 00:13:12.230 Casie Aviles: Yes.
147 00:13:13.060 ⇒ 00:13:19.240 Awaish Kumar: Okay, now what I want to do is that when we have the data in Google Sheet, I want to build a Python script
148 00:13:21.420 ⇒ 00:13:22.130 Awaish Kumar: Right?
149 00:13:23.110 ⇒ 00:13:24.530 Casie Aviles: Yeah, another script.
150 00:13:25.370 ⇒ 00:13:28.020 Awaish Kumar: Python script.
151 00:13:29.230 ⇒ 00:13:35.099 Awaish Kumar: Here, running maybe daily, on, if they are not, like, they don’t want
152 00:13:35.690 ⇒ 00:13:43.180 Awaish Kumar: If they want, like, they are making updates in an hourly base, then we might run it on an hourly basis, but…
153 00:13:43.590 ⇒ 00:13:55.390 Awaish Kumar: like, we can define the cadence based on the client requirement, if they want to run it hourly or daily, but, like, we will have some Python script, which, what it will do is, basically.
154 00:13:55.810 ⇒ 00:14:03.280 Awaish Kumar: it will read that… the data from Google Sheet, Right? And, basically.
155 00:14:03.640 ⇒ 00:14:07.610 Awaish Kumar: Separates this data in the form
156 00:14:08.870 ⇒ 00:14:11.630 Awaish Kumar: our databases. So, for example.
157 00:14:11.880 ⇒ 00:14:17.830 Awaish Kumar: from Google Sheet, we could even,
158 00:14:18.050 ⇒ 00:14:21.490 Awaish Kumar: Like, read the entire sheet, or…
159 00:14:21.680 ⇒ 00:14:26.000 Awaish Kumar: Yes. And we can just convert them in,
160 00:14:27.300 ⇒ 00:14:33.970 Awaish Kumar: And, like, in all the tables you have, like, people… Data…
161 00:14:34.170 ⇒ 00:14:37.760 Awaish Kumar: Right, so whatever is stored in people data table.
162 00:14:37.940 ⇒ 00:14:40.960 Awaish Kumar: We will just get all of the data from here.
163 00:14:41.630 ⇒ 00:14:47.220 Awaish Kumar: Into a separate kind of a, maybe, data frame, and then we run observed queries, right?
164 00:14:48.070 ⇒ 00:14:48.770 Casie Aviles: Yes, yes.
165 00:14:48.770 ⇒ 00:14:52.179 Awaish Kumar: We will run observed queries, so it will just update the…
166 00:14:53.170 ⇒ 00:14:55.749 Awaish Kumar: existing ones, or insert the new ones.
167 00:14:55.860 ⇒ 00:14:58.570 Awaish Kumar: For… for example, for a person, if a
168 00:14:59.030 ⇒ 00:15:05.330 Awaish Kumar: Mobile number or an email is updated, We can just, update that.
169 00:15:05.440 ⇒ 00:15:10.500 Awaish Kumar: And, if, we have really,
170 00:15:10.740 ⇒ 00:15:19.070 Awaish Kumar: new people, we insert that in the table. Similarly, we have all other Service, assignments, all these tables.
171 00:15:19.420 ⇒ 00:15:19.950 Casie Aviles: Yes.
172 00:15:19.950 ⇒ 00:15:24.740 Awaish Kumar: So, our script will basically convert this Google Sheet
173 00:15:24.870 ⇒ 00:15:32.030 Awaish Kumar: Into, the chunks of data, which are… Which are basically…
174 00:15:32.210 ⇒ 00:15:37.599 Awaish Kumar: Needed, for our database, and transform it in the way
175 00:15:37.790 ⇒ 00:15:39.850 Awaish Kumar: We want to store it in our database.
176 00:15:40.040 ⇒ 00:15:43.660 Awaish Kumar: And then we, like, we start with… so it will transform the data, right?
177 00:15:44.000 ⇒ 00:15:47.650 Awaish Kumar: Yeah. So, like, a Google Sheet will have all the fields.
178 00:15:47.750 ⇒ 00:15:51.300 Awaish Kumar: everything in there. But now we want…
179 00:15:51.640 ⇒ 00:15:55.320 Awaish Kumar: It will have, like, people’s data, service data.
180 00:15:55.460 ⇒ 00:16:00.780 Awaish Kumar: service areas, or things like that, right? And if… and we want to manage the connections as well.
181 00:16:01.010 ⇒ 00:16:07.970 Awaish Kumar: So, for example, like, we need to… so a person,
182 00:16:08.510 ⇒ 00:16:22.969 Awaish Kumar: Like, assignments, for example. A person is assigned to a service area, so it will have entry and assignments as well. So, in Google Sheet, we don’t… we don’t basically get this in a form we are storing in a database. In the Google Sheet, you will see
183 00:16:23.280 ⇒ 00:16:28.370 Awaish Kumar: person name, for example, Casey, maybe technician, and then
184 00:16:28.620 ⇒ 00:16:34.590 Awaish Kumar: service area, something, and so, we will create
185 00:16:34.740 ⇒ 00:16:41.539 Awaish Kumar: We will observe the service area, we will observe the people. Now we will have to assign… create an assignment as well.
186 00:16:41.830 ⇒ 00:16:46.690 Awaish Kumar: So that normally is not available on Google here. We know there’s an entry
187 00:16:46.810 ⇒ 00:16:54.530 Awaish Kumar: for a person, for some service area, we know there’s an assignment. So we’ll just re… we will maintain the connection in our script.
188 00:16:55.400 ⇒ 00:17:02.500 Awaish Kumar: And, create, like, all those assignment entries and insert it into our assignments table.
189 00:17:02.610 ⇒ 00:17:05.180 Awaish Kumar: In a similar fashion, like, there are…
190 00:17:05.550 ⇒ 00:17:09.039 Awaish Kumar: In an observed format, so we don’t duplicate, right?
191 00:17:09.460 ⇒ 00:17:10.030 Casie Aviles: Yes.
192 00:17:10.030 ⇒ 00:17:16.079 Awaish Kumar: For the same person, if there’s… the same assignment is already available in the table, we just skip that.
193 00:17:17.089 ⇒ 00:17:22.400 Casie Aviles: Okay, yeah, that makes sense. So, the Python script will handle, like, Creating the…
194 00:17:22.400 ⇒ 00:17:28.390 Awaish Kumar: script will… so a Python script will have all these different functions, Like.
195 00:17:29.110 ⇒ 00:17:31.270 Casie Aviles: For each individual task, right?
196 00:17:31.450 ⇒ 00:17:35.120 Awaish Kumar: Yes. And then people handle service area, location.
197 00:17:35.500 ⇒ 00:17:40.789 Awaish Kumar: And, assignments, and all of these things. So we’ll have multiple functions.
198 00:17:41.070 ⇒ 00:17:46.970 Awaish Kumar: which basically… Handle all these things, and then you will run it by… in order.
199 00:17:48.000 ⇒ 00:17:52.460 Awaish Kumar: Step by step in an order, so that… so people entries there.
200 00:17:52.610 ⇒ 00:17:56.839 Awaish Kumar: First, like, all the primary tables are populated first, and then the
201 00:17:57.330 ⇒ 00:18:02.610 Awaish Kumar: All the, like, the drive day was, like, Assignments and others are populated.
202 00:18:03.860 ⇒ 00:18:06.390 Casie Aviles: Okay, yeah, that makes sense to me.
203 00:18:07.690 ⇒ 00:18:15.760 Casie Aviles: Right, so it’s just really getting from the form, getting into Google Sheets, and then Python will process it.
204 00:18:15.920 ⇒ 00:18:20.350 Awaish Kumar: Yeah, so from form to the Google Sheet is handled by…
205 00:18:20.720 ⇒ 00:18:24.099 Awaish Kumar: Because they already… the client already have forms.
206 00:18:24.250 ⇒ 00:18:27.369 Awaish Kumar: there is some Google Sheet already there, so…
207 00:18:27.980 ⇒ 00:18:31.319 Awaish Kumar: That flow is already happening,
208 00:18:31.740 ⇒ 00:18:40.339 Awaish Kumar: we just want… we maybe just want to update that. Maybe there are a few fields missing in the form, or something. If you want to enhance the form, you can
209 00:18:40.460 ⇒ 00:18:41.280 Awaish Kumar: Suggested.
210 00:18:41.280 ⇒ 00:18:42.090 Casie Aviles: Yeah.
211 00:18:42.090 ⇒ 00:18:47.950 Awaish Kumar: If, like, some fields are missing in the form, we could say, okay, let’s add a few more entries, or…
212 00:18:48.390 ⇒ 00:18:53.490 Awaish Kumar: If the data which is coming in the form using a…
213 00:18:53.710 ⇒ 00:18:56.529 Awaish Kumar: It’s coming in a format which is not really
214 00:18:56.640 ⇒ 00:19:01.849 Awaish Kumar: easy for us to transform. You can even suggest them, like, let’s change it in a drop-down.
215 00:19:02.150 ⇒ 00:19:06.689 Awaish Kumar: I don’t know, some… yeah, or something like that. If…
216 00:19:07.450 ⇒ 00:19:16.870 Awaish Kumar: If that makes sense, you could suggest the changes in a form such that that changes comes in a Google Sheet, but that’s not a necessary
217 00:19:17.610 ⇒ 00:19:20.469 Awaish Kumar: That’s not, like, something we should… we…
218 00:19:20.780 ⇒ 00:19:27.900 Awaish Kumar: Should do, it’s, it’s like, if it is easier for you, To make the transformations,
219 00:19:30.900 ⇒ 00:19:49.239 Awaish Kumar: to, like, to put it in database, so if it makes things easier, then you should suggest. Otherwise, we should just keep it as it is. Data will flow in Google Sheets. Now, our task is to bring that data from Sheet, transform it, and put it in database.
220 00:19:50.290 ⇒ 00:19:51.370 Casie Aviles: Alright, yeah.
221 00:19:51.490 ⇒ 00:19:53.469 Casie Aviles: That makes sense, yeah.
222 00:19:55.200 ⇒ 00:20:03.670 Casie Aviles: Okay, so… this will… yeah, this will be mostly just absurting. And if we’re going to, like, delete…
223 00:20:04.030 ⇒ 00:20:09.460 Casie Aviles: some data, then that would be on our side already, right? It won’t be here.
224 00:20:10.150 ⇒ 00:20:20.110 Awaish Kumar: Yeah, I’m like, why would we delete? Like, that will also be from the client, right? They… if someone fills out that, okay, this person has left, right?
225 00:20:20.890 ⇒ 00:20:21.320 Casie Aviles: Yeah.
226 00:20:21.320 ⇒ 00:20:30.240 Awaish Kumar: this person has left working with us. So, in that case, we also have to get requests from somebody outside, like, somebody has to fill the form.
227 00:20:30.830 ⇒ 00:20:40.510 Awaish Kumar: That this person has left, or this person is not… no longer servicing this, service area, and we…
228 00:20:40.620 ⇒ 00:20:53.039 Awaish Kumar: We want to delete that entry, or somebody switches from one service area to another, or something like that. So, any update, delete entries will be coming through some kind of form as well.
229 00:20:53.170 ⇒ 00:21:00.469 Awaish Kumar: So, person name… Like, first name, last name, and the…
230 00:21:01.270 ⇒ 00:21:07.129 Awaish Kumar: If it is a deletion, it can maybe select the action, what needs to be done, delete.
231 00:21:07.920 ⇒ 00:21:14.590 Awaish Kumar: what assignment needs to be deleted. We can maybe give it a drop-down in the form.
232 00:21:14.910 ⇒ 00:21:20.420 Awaish Kumar: If we want to delete all the assignments, or only one of the assignments, or…
233 00:21:20.850 ⇒ 00:21:30.640 Awaish Kumar: If we want to update the zip code for a person, somebody moved from some area to another area, so we have to think of all these scenarios.
234 00:21:31.040 ⇒ 00:21:34.100 Awaish Kumar: And get this data in a form from the client.
235 00:21:35.670 ⇒ 00:21:43.420 Casie Aviles: I see, yeah. Yeah, yeah, that makes sense. So they have, like, just one place to request all the updates and the edits.
236 00:21:43.630 ⇒ 00:21:44.790 Awaish Kumar: Yeah, like, it can…
237 00:21:45.110 ⇒ 00:21:51.140 Awaish Kumar: it doesn’t matter, it doesn’t need to be, maybe, same form, like, we could have two forms, right?
238 00:21:51.620 ⇒ 00:21:58.400 Awaish Kumar: For… entering new entries, another form could be maybe for…
239 00:22:00.430 ⇒ 00:22:03.790 Awaish Kumar: Another form could be for deletion.
240 00:22:03.790 ⇒ 00:22:06.439 Casie Aviles: And third form could be for updates.
241 00:22:06.440 ⇒ 00:22:09.010 Awaish Kumar: So we could maintain 3 different forms.
242 00:22:09.250 ⇒ 00:22:10.470 Awaish Kumar: So we know, like.
243 00:22:10.930 ⇒ 00:22:24.349 Awaish Kumar: all the entries coming in insertion form, we just have to insert, deletion, we just have to delete. The updates one will be much more, complex, because we don’t know what user might want us to update, maybe we have to update
244 00:22:24.810 ⇒ 00:22:26.580 Awaish Kumar: Based on zip code.
245 00:22:26.730 ⇒ 00:22:32.239 Awaish Kumar: We might have to move person from one area to another area based on zip code.
246 00:22:32.440 ⇒ 00:22:35.500 Awaish Kumar: We might have to, update the…
247 00:22:35.690 ⇒ 00:22:44.679 Awaish Kumar: look, for example, service area, we might have to create one service area, but keep other service areas, right? Things like that.
248 00:22:44.680 ⇒ 00:22:45.340 Casie Aviles: Yes.
249 00:22:46.320 ⇒ 00:22:47.210 Casie Aviles: Okay.
250 00:22:48.330 ⇒ 00:22:54.489 Casie Aviles: Alright, I think I… yeah, I get… yeah, I understand, like, the overall picture now, so…
251 00:22:55.130 ⇒ 00:22:57.760 Casie Aviles: Yeah, I think this is good,
252 00:22:58.020 ⇒ 00:23:03.600 Casie Aviles: I guess next steps for me is to actually write, like, a document for this, so…
253 00:23:03.600 ⇒ 00:23:04.380 Awaish Kumar: Yeah.
254 00:23:04.380 ⇒ 00:23:10.959 Casie Aviles: I will be taking our meeting transcript, and then I will use that to write the document, and then I will…
255 00:23:10.960 ⇒ 00:23:12.919 Awaish Kumar: There are two things, right? Number one.
256 00:23:13.100 ⇒ 00:23:19.929 Awaish Kumar: Ride an ocean dock. Number two, write this Python script, because…
257 00:23:20.610 ⇒ 00:23:23.540 Awaish Kumar: data in the Google Form is coming for new
258 00:23:23.920 ⇒ 00:23:30.450 Awaish Kumar: people, right? So, that’s the number one priority, right? We should have a Python script ready for that.
259 00:23:30.660 ⇒ 00:23:31.780 Awaish Kumar: Oh, man.
260 00:23:32.430 ⇒ 00:23:35.530 Awaish Kumar: And, like, other forms, that could be the…
261 00:23:35.880 ⇒ 00:23:40.759 Awaish Kumar: Third, and then number 3, right? And deletion and updates could be number 3.
262 00:23:47.180 ⇒ 00:23:48.000 Awaish Kumar: So,
263 00:23:48.360 ⇒ 00:23:56.910 Awaish Kumar: So, creating a Notion document should be a first priority, create and writing a Python script for insertion, second priority.
264 00:23:57.350 ⇒ 00:24:02.490 Awaish Kumar: And then creating flows for updating and deleting would be third-party.
265 00:24:06.480 ⇒ 00:24:08.039 Casie Aviles: Alright, yeah, this is good.
266 00:24:12.020 ⇒ 00:24:14.159 Casie Aviles: Alright. Yeah, this is very helpful.
267 00:24:16.650 ⇒ 00:24:21.189 Casie Aviles: Okay, yeah, I think, yeah, this is pretty good,
268 00:24:22.170 ⇒ 00:24:27.039 Casie Aviles: I will start to ticket some of these out, and also let Amber know.
269 00:24:27.770 ⇒ 00:24:32.970 Casie Aviles: Okay. And if I have any other questions, I’ll just let you know, okay?
270 00:24:32.970 ⇒ 00:24:34.449 Awaish Kumar: Yeah, just like me.
271 00:24:35.080 ⇒ 00:24:38.880 Casie Aviles: Alright, I guess that’s it. Thank you very much, Always, for the time.
272 00:24:39.570 ⇒ 00:24:40.230 Awaish Kumar: Thank you.
273 00:24:40.510 ⇒ 00:24:41.030 Casie Aviles: Am I?