>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.
Cool, glad it helped. Thanks for the followup - it's a help for
everyone to be able to see solutions like this that stretch
capabilites.
Cheers,
>
>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
>---------------------------------------------------------------------
--
--
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
---------------------------------------------------------------------
