🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac.databases
Article #191

Re: Another FileMaker Pro question

#191
From: Charles Albrecht
Date: Fri, 14 Aug 1992 14:58
39 lines
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!charlesa
References: <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