Hi Russ,
We at Macpower-MUG in Pennsylvania have a FileMaker Pro database that has the following data entry fields for each person:
FirstName, Initial, LastName, Address1, Address2, City, State, ZIP, IDNumber, MembershipClass, LastYearDuesPaid, HomePhone, BusinessPhone, EmailAddress, DateCardIssued, DateReceiptIssued
The calculated fields are:
FullName = FirstName + Initial + LastName Address = Address1 + Address2 PaidMember = 1 if LastYearDuesPaid is current year CityStateZIP = City + State + ZIP DuesDue = 1 if LastYearDuesPaid is prior year CardIssued = 1 if DateCardIssued is the currentyear
We can select and sort by any combination of fields
Our reports are:
Data Entry Screen: all fields, one member per page Club Roster: LastName, FirstName, Address, CityStateZip, LastYearDuesPaid; paid members in columns sorted by last name Email List: FullName, EmailAddress; paid members in columns sorted by last name Contact List: FullName, Address, CityStateZIP, HomePhone, EmailAddress; current and last years members in columns sorted by last name ID Number List: FullName, Address, CityStateZIP, HomePhone, IDNumber, MembershipClass; current and previous members in columns sorted by ID number Dues Payment Report: FullName, MembershipClass, LastYearDuesPaid, PaidMember, CardIssued; all previous years members sorted by paid and last name Dues Receipt Records: FullName, LastYearDuesPaid, PaidMember, DateReceiptIssued Dues Notice: a letter sent out by email each year AuctionTally: a form to tally items members buy at group auctions
Other neat things is that FileMaker Pro can emails notices to members, email reminders to unpaid members, email dues receipts, make membership cards, etc.
You can get similar functionality with Numbers or Excel or AppleWorks except for sending emails.
I have been using this database for 19 years including in Boy Scouts, Rotary and not a MUG.
Cheers, Steve Henning, Membership
MacPower-MUG Users Group
|