-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathproject1.html
146 lines (128 loc) · 5.85 KB
/
project1.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
<!DOCTYPE HTML>
<!--
Solid State by HTML5 UP
html5up.net | @ajlkn
Free for personal and commercial use under the CCA 3.0 license (html5up.net/license)
-->
<html>
<head>
<title>Catherine Pham's Projects</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no" />
<link rel="stylesheet" href="assets/css/main.css" />
<noscript><link rel="stylesheet" href="assets/css/noscript.css" /></noscript>
</head>
<body class="is-preload">
<!-- Page Wrapper -->
<div id="page-wrapper">
<!-- Header -->
<header id="header">
<h1><a href="index.html#projects_section">Catherine Pham's Projects</a></h1>
<nav>
<a href="index.html">Return Home</a>
</nav>
</header>
<!-- Menu -->
<!-- <nav id="menu">
<div class="inner">
<h2>Menu</h2>
<ul class="links">
<li><a href="index.html">Home</a></li>
<li><a href="generic.html">Generic</a></li>
<li><a href="elements.html">Elements</a></li>
<li><a href="#">Log In</a></li>
<li><a href="#">Sign Up</a></li>
</ul>
<a href="#" class="close">Close</a>
</div>
</nav> -->
<!-- Wrapper -->
<section id="wrapper">
<header>
<div class="inner">
<h2>Point Tacker Automation Project</h2>
<!-- <p>Phasellus non pulvinar erat. Fusce tincidunt nisl eget ipsum.</p> -->
</div>
</header>
<!-- Content -->
<div class="wrapper">
<div class="inner">
<h3 class="major">Description</h3>
<p>My inspiration for this project is rooted in the absurdly long amount of time that it would
take my SWE (Society of Women Engineers) chapter’s Recording Secretary to input our members'
attendance points into a public Google Sheets document. I decided that I wanted to write a
script to automate this process. Using JavaScript in Google Apps Scripts, I was able to
create a solution for our problem. </p>
<p>The script takes in the URL of the Google Form that was used as a Sign-In for the event and
the name of the event as input from the Google Sheet. Based on the data from the Google Form,
the script will automatically create a column for the event and populate points for existing
members, update exsiting member information, add new members as rows, recalculate Total,
Non-GBM, and GBM points, and color code the event column. This program reduced the time spent
on populating attendance points from 30 - 20 minutes to 1 minute - 30 seconds. </p>
<h3 class="major">Demo</h3>
<video width="100%" height=auto autoplay loop>
<source src="demos/points_tracker_demo.mp4" type="video/mp4">
</video>
<p>This first demo video is demonstrating how the user would input the Google Forms URL into the Apps Script.</p>
<video width="100%" height=auto autoplay loop>
<source src="demos/points_tracker_demo_2.mp4" type="video/mp4">
</video>
<p>Once the input is taken in, you can see the the Google Sheet automatically fill in the points,
add in new members, and recalculate GBM, non-GBM, and Total points, and more.</p>
<!-- <section class="features">
<article>
<a href="#" class="image"><img src="images/pic04.jpg" alt="" /></a>
<h3 class="major">Sed feugiat lorem</h3>
<p>Lorem ipsum dolor sit amet, consectetur adipiscing vehicula id nulla dignissim dapibus ultrices.</p>
<a href="#" class="special">Learn more</a>
</article>
<article>
<a href="#" class="image"><img src="images/pic05.jpg" alt="" /></a>
<h3 class="major">Nisl placerat</h3>
<p>Lorem ipsum dolor sit amet, consectetur adipiscing vehicula id nulla dignissim dapibus ultrices.</p>
<a href="#" class="special">Learn more</a>
</article>
</section> -->
</div>
</div>
</section>
<!-- Footer -->
<section id="footer">
<div class="inner">
<h2 class="major"> </h2>
<!-- <p>Cras mattis ante fermentum, malesuada neque vitae, eleifend erat. Phasellus non pulvinar erat. Fusce tincidunt, nisl eget mattis egestas, purus ipsum consequat orci, sit amet lobortis lorem lacus in tellus. Sed ac elementum arcu. Quisque placerat auctor laoreet.</p>
<form method="post" action="#">
<div class="fields">
<div class="field">
<label for="name">Name</label>
<input type="text" name="name" id="name" />
</div>
<div class="field">
<label for="email">Email</label>
<input type="email" name="email" id="email" />
</div>
<div class="field">
<label for="message">Message</label>
<textarea name="message" id="message" rows="4"></textarea>
</div>
</div>
<ul class="actions">
<li><input type="submit" value="Send Message" /></li>
</ul>
</form> -->
<ul class="icons">
<li><a href="https://www.linkedin.com/in/catherinepham2/" class="icon brands fa-linkedin"><span class="linkedin"></span></a></li>
<li><a href="https://github.com/catherinepham" class="icon brands fa-github"><span class="label">Github</span></a></li>
</ul>
</div>
</section>
</div>
<!-- Scripts -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/jquery.scrollex.min.js"></script>
<script src="assets/js/browser.min.js"></script>
<script src="assets/js/breakpoints.min.js"></script>
<script src="assets/js/util.js"></script>
<script src="assets/js/main.js"></script>
</body>
</html>