Andy Laakmann
Comments
-
It sounds like you are not using the integrated billing (I see you are located in the UK) so whatever steps you are doing to "simulate" billing might be unique to your gym. If I had to guess, you ...
-
Option A Just create a single punch card customer record to represent the business and put 250 punches on it. I presume they will provide a periodic list of employees. Keep that behind the desk fo...
-
test
-
If you want JUST active members.... here is the SQL SELECT LEFT(zip,5) as zip, city, state, COUNT(*) AS total_count from customers where CURRENT_STATUS='OK' and CUSTOMER_TYPE='MEMBER' group by zip ...
-
Provided you have a punch card product... in the Email System, setup a Custom Action to be triggered when that product is purchased.
-
Include the following in the where clause and LAST_VISIT_DATE between '{STARTDATE}' and '{ENDDATE}'
-
There is now a standard zip/postal code report on the report tab, thus you may not need to use the custom SQL any more. And that report allows you to select the dates.
-
That starts to get tricky unfortunately. It is possible, but it goes beyond the scope of basic help to get that deep into SQL because it combines other tables.
-
There are over 100 related tables and probably 2500+ fields, a reference guide is WAY out of the scope. Sorry. I recommend you download Navicat for MySQL and explore the tables. Just be absolutel...
-
Sorry, not at this time but I'll add it to my todo list.
