Thanks! I tried it today and it works perfectly!
:-)
--
Beth Hynes
Parks & Trails Council of Minnesota
275 East 4th Street, #642
Saint Paul MN 55101
[EMAIL PROTECTED]
651-726-2457
----------
>From: Dave Shaw <[EMAIL PROTECTED]>
>To: "TechRocks Support" <[EMAIL PROTECTED]>
>Subject: [support] Re: Membership level quibble
>Date: Fri, Jun 1, 2001, 7:25 PM
>
>>Dave, that's not how my copy worked at the beginning either--but it's the
>>way it has worked ever since I made the change to an official "0" in the
>>Member Level value list.
>
> Now I see what's happening, thanks. The trick is to get FileMaker to
> wait until you commit the record to fill in the Level. Level Calc
> uses a Case() function to pick the level from setup to assign to the
> Level field. Seems to me if you put the whole Case() function in an
> If() statement, with the IsEmpty() function as the conditional, it
> would work.
>
> Try this: Change the field definition of the field Level Calc (in the
> paymnts_.102 file) to...
> If(IsEmpty(Amount),"",
> Case(
> Amount >= SETUP::LEVEL 1 MIN, SETUP::LEVEL 1 CODE,
> Amount >= SETUP::LEVEL 2 MIN, SETUP::LEVEL 2 CODE,
> Amount >= SETUP::LEVEL 3 MIN, SETUP::LEVEL 3 CODE,
> Amount >= SETUP::LEVEL 4 MIN, SETUP::LEVEL 4 CODE,
> Amount >= SETUP::LEVEL 5 MIN, SETUP::LEVEL 5 CODE,
> Amount >= SETUP::LEVEL 6 MIN, SETUP::LEVEL 6 CODE,
> Amount >= SETUP::LEVEL 7 MIN, SETUP::LEVEL 7 CODE,
> Amount >= SETUP::LEVEL 8 MIN, SETUP::LEVEL 8 CODE,
> Amount >= SETUP::LEVEL 9 MIN, SETUP::LEVEL 9 CODE,
> Amount >= SETUP::LEVEL 10 MIN, SETUP::LEVEL 10 CODE, ""))
>
>
>
>>
>>>>However my quibble is this: Every time I start a new dues payment ebase
>>>>automatically calls it a "$0" in the membership level field and doesn't
>>>>change the membership level, even after I enter the dues amount, unless I
>>>>click the update level button.
>>>
>>> First, that's not how my copy operates. Level is auto-entered from a
>>> calculation based on the payment value. It doesn't post a value until
>>> the payment amount is entered or you commit the record with a blank
>>> amount. You don't say anything about procedure, but I note that you
>>> should not commit the record (press enter or click outside a field)
>>> until the amount is entered.
>>>
>>>>It's becoming a pain to do. I've looked for a
>>>>way to do a multiply replace but the button seems to only work on one record
>>>>at a time.
>>>
>>> If by "multiply replace" you mean the FileMaker replace function,
>>> it's designed to replace values in many records at once. Again, you
>>> don't say what steps you're taking, but somehow you're closing the
>>> procedure without telling it to do the replace.
>>
>>What I meant was I wanted to update the member levels for multiple records
>>and that calculation is done by a button--and the button works only on a
>>single record at a time. Do you know a way to use the FM replace for a
>>calculation?
>>>
>>
>>>>And I don't want to have to remember to do a update all fields
>>>>everyday either. I thought FM would know the difference between a blank
>>>>field and a field with 0 in it. Any suggestions? Thanks in advance.
>>>
>>> Update all fields is something you should build into your regular
>>> schedule. As soon as you enter a payment your Fast Find fields are
>>> out of date. You need to run the update script after any major data
>>> entry or before you do a search that depends on these fields. I think
>>> it's easier to remember to do it before you go to lunch every day, or
>>> before you quit.
>>
>>I guess I'm balking at doing an update all fields at times I haven't had to
>>do it i.e. before this change took over. Because we have different letters
>>and promos for different levels of dues I have to run the update all fields
>>before I can print thank you letters--something I didn't have to do when
>>ebase autoentered correctly.
>>
>>
>> --
>>Beth Hynes
>>Parks & Trails Council of Minnesota
>>275 East 4th Street, #642
>>Saint Paul MN 55101
>>[EMAIL PROTECTED]
>>651-726-2457
>>
>>------------------
>>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
> ---------------------------------------------------------------------
>
------------------
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
---------------------------------------------------------------------
