I run fitness classes. I want to track when customers come to class and be able to note if they haven't attended for a while.
I know that there are on line solutions, but these are all far too complex
I would like the solution to be in Google sheets, although please recommend if it can be done in another product.
While all the functionality can be done in sheets, i want it to be done with macros in a way that looks good.
There are three parts to this I require:
1) a process which records new customers along with their email addresses and mobile numbers.
2) a record attendance macro. Which first asks the instructor to record the class name and date, then records the customer names. I want the customers to be able to type their name, then to select it from a drop down. Only existing customers can be recorded. New ones need to be added prior to signing in.
3) a macro which sorts the customers by attendance and produces a list highlighting those that haven't been for a period of time ( say greater than 3 weeks but less than 8 weeks). This is exported as a text string to be inserted into my email .
I think this is all. I would be grateful to hear your ideas and comments.
GOOGLE SHEETS IS THE BEST TOOL FOR YOUR PARTICULAR USE CASE. ATTENDANCE SYSTEM and NEW CUSTOMER REGISTRATION with GOOGLE FORMS can be made. I have built MANY similar Google Sheets with many macros. I can build yours to Daha Fazla
Bu iş için 9 freelancer ortalamada £122 teklif veriyor
Hi i hope am the best choice for this project because of my experience and hard working , so please let me in. I can offer you a discount because of give this [login to view URL] me for more negotiations . Thank you