Embedded Files
Simple google sheets login-in system database
Simple google sheets login-in system database
The purpose of this project was to create Demo of a sign-in system that would log user data each time they came into the makerspace. My version was only a proof of concept that logged to google sheet. A team then used my design to create a sign in system with a few more features! I did full stack on this project!
Entering a new username will parse the sheet to check if there are any matching users
if there are no matching users in the database, the sign in system will then ask you some questions to collect userdata
This data is essential for when we would ask for money from the university. Having statistics about the amount of users and the type of users we have makes a huge difference!
Here is the git to this program.
It will not work without setting up your own Google Cloud console.
More about google sheets Java API at: https://developers.google.com/sheets/api/quickstart/java
The new user's data is added!!!
if you enter a username that has already been entered before. The program will parse through the sheet to match it to the "profile" that the user created the first time they logged in
This way a user will not need to reenter a bunch of data each he/she logs in
The user's number of visits will then be retrieved by the software and updated each time they sign it to track how often they are in the space.
The java API for google sheets is rather complicated and very busy with the amount of library references you need. It was a fun challenge to teach myself how to tackle a project like this where I handle everything. I had never really done anything front end before, in class we were taught about JAVAFX but never how to actually use it, as the programs that we did with them most of the code was provided for us. I had to figure out all the technical complications of having a program written for console out be implemented into a new output using html and JAVAFX.
Page updated
Google Sites
Report abuse