Dave, Thanks for your help - what I've done is duplicated the Level Calc from the Names table, substituting the AMOUNT parameter with a custom SUM:LifetimePledge. This seems to be basing my Donor Level on the total Pledges both DUES and CONTRIBUTIONS - which is what we're looking for at this point - can't believe it actually worked! Thanks again...this listserv is fantastic. Andrea ****************************************************** Andrea Powers [EMAIL PROTECTED] The Eric Carle Museum of Picture Book Art 36 Main St. Northampton, MA 01060 (413) 586-8934 ****************************************************** -----Original Message----- From: Dave Shaw [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 6:05 PM To: TechRocks Support Subject: [support] Re: membership level based on contribution >I'm hoping this is a straightforward question...I want to change the >membership level to be based on total contributions and I had read in the >Support archives how to do this (I've included the text below) however I >don't know where to find the exact place to make the change. Sorry, it's not really a straighforward question. Member level is based on the amount of the _last_ dues payment, and the revision below changes that to be based on the _last_ payment coded as contribution, not the total. First thing to think about is whether you want member level to be determined by the year-to-date total of contributions or lifetime total. To do what you're looking for, you'd need to duplicate in the names file the calculation of Level Calc from the payments file for a new field, called Donor Level Calc or something like. This is a pretty complicated calculation using the Case() function and the values for minimum payment level and the name of the level set in the setup file. Have a look at these field definitions, review the section on calculated fields in the FileMaker user manual, and see if it's something you want to take on. >I have been >"messing" around with ebase for a few weeks now, but Filemaker is completely >new to me so it's been slow going. >Any help provided would be appreciated. -- -- Dave Shaw H4 Consulting tel: 206-954-7526 fax: 206-625-1338 ------------------ Reminder to each recipient: To change your list account preferences, go to http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] --------------------------------------------------------------------- ebase - Relationship Management for Nonprofits, http://www.ebase.org --------------------------------------------------------------------- ------------------ Reminder to each recipient: To change your list account preferences, go to http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------------------------------------------------------------------- ebase - Relationship Management for Nonprofits, http://www.ebase.org ---------------------------------------------------------------------
