🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: FileMaker Pro v2.0 -How do you do IF-THEN tests?

#470
From: Nick B Triantos
Date: Sat, 12 Dec 1992 04:18
59 lines
3419 bytes
In article <1992Dec11.120606.520@news.wesleyan.edu> pzocco@falcon.wcc.wesleyan.edu (Paul Zocco) writes:
   ...
   So on my main contact layout, I have some Yes/No radio buttons for:

	   Member?		Yes/No
	   Speaker Req.?	Yes/No
	   Speaker Info?	Yes/No
	   Pilot School?	Yes/No,  etc.

   What I would like to do is have the radio buttons determine how you move  
   from layout to layout (or database to database.)  Depending on how the  
   Yes/No questions are answered on this contact screen, I'd like FileMaker  
   Pro to walk its way through the other layout screens (with user  
   interaction, of course).

Paul brings up an interesting idea, which I would propose is very much
possible, with a little work and a great new feature of FileMaker Pro 2.0.
What you can do is to create a calculation field that, based upon the
different combinations of "Yes"es and "No"s, creates a number.  Then, create
layouts named with each of these numbers, which you'd like for the
combinations to continue to.  Place a button on the layout with the "Yes/No"
questions called something like "Continue" that executes the script command
"Go to Layout", and use the option for going to a layout number specified by
a field. (It's there.  Look at it).  It's not something I've done to date,
but I see that the features are there to make this apparently possible.

   Also, is there a way to make a radio button act like a button that  
   performs an action?  That is, can you click on a radio button, have the  
   field it represents be set to Yes or No and still switch to another  
   layout?

This, actually, is also possible.  Create very small circles that look like
radio button sized doohickeys, and place them on the layout ON FRONT of the
actual "Yes/No" buttons.  (From the Arrange menu, choose "Move to Front").
Each of these buttons should be drawn with a black pen, and fill set to
NONE.  Then have each button execute scripts that will "Go to Field
<your-field>", and "Paste Literal 'yes'" or 'no'.  The scripts will
therefore be doing the same thing as clicking on the real radio buttons, but
since you're now executing a script, it should be possible to continue on
and do lots of other fun things.  The only caveat here:  I'm not sure that
you'll be able to Paste Literal into a radio button field, since there's
really no way to "Go to Field" to a formatted field.  Check it out, though,
and let us all know what you find.

Peace, happiness, and regular backups!


--
-Nick "I live down the street from Apple, isn't that special" Triantos

I may work in Claris Technical Support, but not when I'm logged in on
the Internet... 

-- 
-Nick "I live down the street from Apple, isn't that special" Triantos

I may work in Claris Technical Support, but not when I'm logged in on
the Internet... 
Technical Details
Message-ID: <TRIANTOS.92Dec11201834@netcom.Netcom.COM>
Path: arc1-ca.pugleaf.net!sparky!uunet!usc!wupost!csus.edu!netcom.com!netcom!triantos
References: <1992Dec11.120606.520@news.wesleyan.edu>

Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.mac.databases
Path: arc1-ca.pugleaf.net!sparky!uunet!usc!wupost!csus.edu!netcom.com!netcom!triantos
From: triantos@netcom.Netcom.COM (Nick B Triantos)
Subject: Re: FileMaker Pro v2.0 -How do you do IF-THEN tests?
In-Reply-To: pzocco@falcon.wcc.wesleyan.edu's message of 11 Dec 92 12:06:04 EDT
Message-ID: <TRIANTOS.92Dec11201834@netcom.Netcom.COM>
Sender: triantos@netcom.com (Nick B Triantos)
Organization: Netcom Online Communications Service
References: <1992Dec11.120606.520@news.wesleyan.edu>
Date: Sat, 12 Dec 1992 04:18:34 GMT
Lines: 60