>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
---------------------------------------------------------------------
