Anyone created an attendance tracker?

Ask the community
,
1

With coding access on Wix now, has anyone set up either a check-in database or other system for tracking student/client attendance?

I teach yoga and sell multi-class passes. It would be nice to have a check-in page on my site that either I could use or for self check-in to make it easier to see how many times a student has attended. Ideally, admin could reset the count when the student bought a new package.

I’ve looked at, and even used, several of the more popular CMS systems for studios and gyms. They offer a ton of features I don’t need and consequently charge way more than what I want to pay to just track attendance. Right now I use a Google sheet. I’d like something less cumbersome than using a spreadsheet.

Any guidance would be greatly appreciated.

2 Likes
2

Hi,

Here are a few steps to think about:

  1. What data do I need? (only name and number of classes left?)

  2. How will the database look?
    STUDENT NAME CLASSES LEFT
    Liran 30
    John 20

  3. How would you like to manage it? through the database grid? and admin page?
    Using the database grid is easy and very google sheet like.
    You can then add buttons to your site, that changes the database.
    You can also set permissions that will make sure that only the Admin can change the Database.

First thing’s first:
Create a new collection, and the fields you need (Student name, classes left, age, etc.).
Get some feeling about how to use the database sheet.

Then, have a look here about how to update the database using code.

Good luck!

Liran.

3

I appreciate your confidence in me but this project might be a bit above my pay grade. I created a collection and then I tried following the instructions at the link in your post.

Putting
//Add the following to the top of your code to import wixData: import wixData from ‘wix-data’;
import wixData from ‘wix-data’;
at the top of my code immediately generated an error
‘wixData’ is unused

Don’t know where to go from there so I’ll see if I can find a coder who’ll set this up.

But thank you for trying!

4

Hi,

This means that you’ve imported wixData module, but haven’t used it.
You’ll probably need to following three methods:
wixData.query() - to get info from collectiom
wixData.insert() - to add info to collection
wixData.update() - to update info in collection.

Liran.

5

Again, thank you. I tried plugging in the sample code for those methods into my site but was unable to adapt them to what I need. Mainly because my knowledge of coding is rudimentary.

My original post was prompted by the hope of finding a cut-and-paste option for an attendance tracker or something close enough that I could tweak the labels or fields to match what I needed. Thought something this simple would already be out there. Didn’t want to pay a coder to create something that was readily available for free. I already have something that works with my Google spreadsheet. It’s just not very elegant. For the price, I can live with that.

Eventually, the template for what I need will be out there. I’ll be patient and keep checking.

6

I want to make a form to take attendance.
I use repeater to draw information from a database.

I set filter to display the name of student of a particular class.
However, when I add checkboxes inside the repeater which are besides the student names, the checkbox cannot distinquish which students have attended. Any suggestion?