Point Tracking and Redemption

Question

I run a volunteer program where we reward our volunteers with comp tickets to our events. We currently use a points based tracking system where they get 10 points for every hour volunteered. I was wondering if there was a way to create something in Airtable that would help us keep track of how many points our volunteers have earned and redeemed. So whatever would be created I would need a way to add points and subtract points with ease.

We allow our volunteers to bank their points to redeem and "upgrade" their tickets to better seats on the following scale:

Tier 3- 40 Points
Tier 2- 80 Points
Tier 1- 120 Points
Premium- 160 Points

It would be a bonus if the same base would allow them to request their redemption.

TheTimeSavingCo · Accepted Answer

I threw something together here that should help get you started

You've got a "Volunteers" table where each record represents a volunteer:

A "Logging" table to log how many hours a volunteer did, and a formula field to calculate what that is in points:

And a "Redemptions" table to set which person redeemed what type of ticket, plus a formula field to represent how many points that is:

And all of that info gets fed back into the "Volunteer" table via the rollup fields you can see in the original screenshot.

(You can duplicate the base to look at the formula fields and rollup field formulas)

It gets trickier after this because you mentioned wanting to let them request their redemption, but Airtable forms don't have a way for you to easily restrict an option based on data in their base, i.e., we can't stop them from selecting "Premium" even if they don't have enough points for it.

You could look for a third party form solution to help with this, or you could allow users to submit requests for redemptions that you then approve / reject manually perhaps?

This is fantastic! With a few modifications this is exactly what we were hoping for!

lterrazas · Answer

I threw something together here that should help get you started

You've got a "Volunteers" table where each record represents a volunteer:

A "Logging" table to log how many hours a volunteer did, and a formula field to calculate what that is in points:

And a "Redemptions" table to set which person redeemed what type of ticket, plus a formula field to represent how many points that is:

And all of that info gets fed back into the "Volunteer" table via the rollup fields you can see in the original screenshot.

(You can duplicate the base to look at the formula fields and rollup field formulas)

It gets trickier after this because you mentioned wanting to let them request their redemption, but Airtable forms don't have a way for you to easily restrict an option based on data in their base, i.e., we can't stop them from selecting "Premium" even if they don't have enough points for it.

You could look for a third party form solution to help with this, or you could allow users to submit requests for redemptions that you then approve / reject manually perhaps?

This is fantastic! With a few modifications this is exactly what we were hoping for!

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded