Article View: comp.sys.mac.databases
Article #470Re: FileMaker Pro v2.0 -How do you do IF-THEN tests?
From: Nick B Triantos
Date: Sat, 12 Dec 1992 04:18
Date: Sat, 12 Dec 1992 04:18
59 lines
3419 bytes
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!triantosReferences:
<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