🚀 go-pugleaf

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
(<=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=>)