Article View: comp.sys.mac.databases
Article #191Re: Another FileMaker Pro question
From: Charles Albrecht
Date: Fri, 14 Aug 1992 14:58
Date: Fri, 14 Aug 1992 14:58
39 lines
2146 bytes
2146 bytes
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.
Technical Details
Message-ID:
<1992Aug14.145815.6357@ncar.ucar.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!gatech!ncar!niwot.scd.ucar.edu!charlesaReferences:
<1992Aug14.090939.14131@nntp.uoregon.edu>Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.mac.databases Path: arc1-ca.pugleaf.net!sparky!uunet!gatech!ncar!niwot.scd.ucar.edu!charlesa From: charlesa@niwot.scd.ucar.edu (Charles Albrecht) Subject: Re: Another FileMaker Pro question Message-ID: <1992Aug14.145815.6357@ncar.ucar.edu> Keywords: FMPro, Calc Fields, If(,,) Sender: news@ncar.ucar.edu (USENET Maintenance) Organization: Scientific Computing Divison/NCAR Boulder, CO References: <1992Aug14.090939.14131@nntp.uoregon.edu> Date: Fri, 14 Aug 1992 14:58:15 GMT Lines: 39