🚀 go-pugleaf

In article <1992Aug14.090939.14131@nntp.uoregon.edu> srussell@cie.uoregon.edu (Steven Russell) writes:
>
>Ok, here's another question:  I want to be able to create a field
>that adds values from two other fields.  If field "A" contains the
>value 20, and field "B" contains 17, I want my proposed field to
>become 37.  So far, this is trivial, but I would like this same field
>to be selectable for manual data entry if both fields "A" and "B" are
>undefined.  If this is not possible, I will settle for having the
>field be selectable for data entry without depending on the values in
>fields "A" and "B".  Is this possible, or am I asking too much?  I've
>looked through the manual for help with this, but haven't found a way
>to make it work.
>
>--
>-Steven Russell
>srussell@uoneuro.uoregon.edu
>

How about this:  create a field "C" that has the data you'll put into your
calculation field if "A" and "B" are empty.  Then define your CalcField
with:

CalcField = if ((A = "") and (B = ""),C,A+B)

I've done something similar in a database here.  I then make C a non-printing
object in the layout definition, so that only the CalcField is printed.


Charles

----
Charles Albrecht                "Nonsense, they only say you can't survive
charlesa@ncar.ucar.edu           The Fire Swamp because no one ever has."
303/497-1828                        - Westley, The Dread Pirate Roberts

NCAR - Scientific Computing Division * P.O. Box 3000 * Boulder, Colorado  80307

The opinions you are about to have read are fictitious...
          ...any similarity to opinions living or dead is purely coincidental.

In <1992Aug14.090939.14131@nntp.uoregon.edu> srussell@cie.uoregon.edu (Steven Russell) writes:

>Ok, here's another question:  I want to be able to create a field
>that adds values from two other fields.  If field "A" contains the
>value 20, and field "B" contains 17, I want my proposed field to
>become 37.  So far, this is trivial, but I would like this same field
>to be selectable for manual data entry if both fields "A" and "B" are
>undefined.  If this is not possible, I will settle for having the
>field be selectable for data entry without depending on the values in
>fields "A" and "B".  Is this possible, or am I asking too much?  I've
>looked through the manual for help with this, but haven't found a way
>to make it work.

The only way you could do this would be to define your proposed field as a
calculation field, let the calculation run, and thenb redefine it as a
number field. But you would have to re-run the calculation on an irregular
basis.

-Geoff
--
geoffb@Dartmouth.EDU - Computing Support Consultant, Tuck School of Business
_____________________________________________________________________________
 Cerebus for Dictator in 1992!!    |    He doesn't love you, he just wants
     "Vote for me or else."        |           all of of your money.

In <1992Aug15.213459.13281@dartvax.dartmouth.edu> geoffb@coos.dartmouth.edu (Geoff Bronner) writes:

>In <1992Aug14.090939.14131@nntp.uoregon.edu> srussell@cie.uoregon.edu (Steven Russell) writes:

>>Ok, here's another question:  I want to be able to create a field
>>that adds values from two other fields.  If field "A" contains the
>>value 20, and field "B" contains 17, I want my proposed field to
>>become 37.  So far, this is trivial, but I would like this same field
>>to be selectable for manual data entry if both fields "A" and "B" are
>>undefined.  If this is not possible, I will settle for having the
>>field be selectable for data entry without depending on the values in
>>fields "A" and "B".  Is this possible, or am I asking too much?  I've
>>looked through the manual for help with this, but haven't found a way
>>to make it work.

>The only way you could do this would be to define your proposed field as a
>calculation field, let the calculation run, and thenb redefine it as a
>number field. But you would have to re-run the calculation on an irregular
>basis.
>geoffb@Dartmouth.EDU - Computing Support Consultant, Tuck School of Business

Huh???
 
Truthfully, the only way to accomplish this is as follows:
 
Field A & B are numbers
Field W = A + B (Calculation)
Field X = Number field with auto-increment serial number (Start at say 1)
Field Y = Number field with defined values of 0 and 50000 (arbitrary but large)
dfg
:wq
Field Z = X + Y
 
 
Field C = Number field which looks up within the same file and copies the
          contents of W into C when a new value in Z matches a value in X
 
In this case if you define Y as radio buttons and size the box so you can't
see the 0 and 50000, you have a little toggle switch to perform the lookup, so
you can type in field C, but whenever you toggle, the value will be replaced
with the actual calculation...
 
There are a couple ways to make it work a bit easier, but they are more complica
ted in the formula's and require a special procedure when entering data, this is
the most user friendly way...
 
(<=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=>)
Darren J. Wiebe                         | Internet:  djwiebe@ccu.umanitoba.ca
Box 141, Station L                      | AppleLink: CDA0010T
Winnipeg, Manitoba, Canada  R3H 0Z4     | Quote: 'scuse me,
Disclaimer:  Disclaimer!  I don't need  |            while I puke and die!
              no stinkin' disclaimer!   |                   -The Dead Milkmen
(<=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=>)