Good day Webflow Community,
I have an idea for a website that I would like to persue, but I don’t know if Webflow and it’s addons would make it possible.
So the idea is to create a site that schools can sign up to, and offer students the option to create a paid account with the school (very affordable and as a way for that school to gain income, as schools in my area struggle with funding).
[How I would like sign up to work]
The school would sign up for a school account, and they would keep a list of paying student email adresses (in a Google Sheets spreadsheet?). (The school will ask them for their email address, password and secondary email addresses for parent/guardian access.) The student would then go onto the site and then press log in. They would enter a ‘school code’ which is assigned to the school. (This is used as a school picker instead of having all the schools laid out, for privacy reasons) When they enter in a valid school code, it would ask them to enter in their details to log in. If their credentials are correct, it would take them to their ‘dashboard’, outlined in the next paragraph. The Google Sheets spreadsheet would keep track of a date that the student’s access expires, unless the student keeps paying for the service. If the student does not pay, they would either (not have an account with the school, since they have not applied in the first place or they stopped paying for the service (In which there should be a [Access = True] next to their name, or in a defined cell in the same row.) If Access = False, the student would not be given access and would be handed a Subscription Expired message.
This login service should be able to allow each student (once they are a paying student) to access their personal ‘dashboard’ (with an account/email address) where they would be able to see their test scores in a graph and history of results from tests etc. Their parents/guardians would also be able to see this dashboard (with secondary accounts/email adresses.) It would also provide information about upcoming school events, such as swim meet etc.
I think I would have to have this information (test scores, events etc.) in a Google Sheets spreadsheet, I don’t know if there is an easier way to do it.
Is this project of mine possible on Webflow? And can someone shed some light on addons/ integrations that would help me to do it?
Thanks for taking the time to read this,