I have seen a couple of threads that touches on this topic but no concrete path to solve what I want to achieve.
I’m building a client app for a dance studio where a user can purchase different packages to attend dance classes eg: Full Term (6 weeks), Casual Class (Single class), 10 Class Pass, etc…When a purchase is complete the details of the purchase are copied to a separate sheet called ‘
Purchases_Completed’ including the number of classes included in the purchased package eg; 6 (full term), 1 (single class), 10 (class pass)
I have also created a calendar view of all scheduled classes with the ability for a user to “Check-in” (via a form button, which when submitted creates an item on a sheet called ‘
Every time a user ‘checks-in’ into a class, I want to decrease the number by -1 in the corresponding column of the ‘