My.ADVISOR.com Sign-In
Username
Password
Sign Up 
Go to Article
Advanced Search 

ADVISOR ANSWERS

Complex Multi-Column Publishing in FileMaker Pro

Discover a solution to a complex printing problem.

 DOWNLOAD (131,966 bytes) -- Get the code for the complex publishing technique.
By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor

UNLOCKED -- This article is provided to subscribers of FILEMAKER ADVISOR or DATABASED ADVISOR or FILEMAKER ADVISOR. To subscribe or renew, go to Advisor Store.

Q: I have a database that prints out cards for a quiz game. On one side of the card is a question, and on the back of the card is one of three symbols, depending on the question type. My layout prints 10 cards per page. I've had difficulty getting the card backs to sort so they make a set of backs that prints on the back of my questions. Also, because different questions require different symbols, I need to have the symbols flipped to the other side of the page. For example, if the top left question is a type A question, and the top right question is a type B question, the other side of the page has to have B on the left and A on the right. Getting this last part to work has been especially difficult. Can you help?

A: Wow. First off, we just want to say for the record that what you're asking is the hard way to do your printing. The easy way is to make a separate table for each question type, or even just print found sets of each question type so you don't have to worry about matching the card backs to the question.

However, if you have time to burn and are up for a challenge, this task is surprisingly rigorous. Given a database of 30 questions numbered 1 through 30, you must have 30 identically numbered blank questions for a total of 60 records. You'll use this second set to print your card backs. You have a relationship set up so a card back record relates to its identically numbered question record and can determine which type of question it is. For the purposes of this discussion, we'll say questions can be of type A, B, or C and the back conditionally displays a symbol for A, B, or C.

Here we've come to the first challenge. You're using a single layout to print questions and card backs. One side of the page must print the question number, the question text itself, four possible answers, and a graphic that illustrates the question. The other side of the page must be entirely blank except for the question type symbol. You have to pile all these elements on top of each other on the card layout, and store the labels for answer choices 1, 2, 3, or 4 in a global field and conditionally display them in a calculation field that hides the choice labels if the question is blank.

You can do it fairly simply with:

z_LabelDisplay = Case ( not IsEmpty (Question) ; z_Labels )

This calculation returns a container result, because the labels are stored in the container field z_Labels (which uses global storage so it's available to all records).

Complex Multi-Column Publishing

No reader comments ... yet.

    What do YOU think about this topic? Share your advice and thoughts using this form.

    Your Name

    REQUIRED : PUBLIC

    Your E-Mail

    REQUIRED : PRIVATE

    Job, Company

    OPTIONAL : PUBLIC

    City, State, Country

    OPTIONAL : PUBLIC

    Your Web Site

    OPTIONAL : PUBLIC

    Your Comment

    Please help everyone by keeping your comments on-topic, using clean language, and not defaming or making personal attacks.


    Your e-mail address is required, but it will not be displayed to the public or given to anyone. See our Privacy Policy. Comments become visible after they pass our spam filter, and spammers and abusers are permanently blocked. Please report spam or abuse.

    Chris MoyerChris Moyer is president and CEO of The Moyer Group, a FileMaker Pro consulting and training firm with offices in Atlanta, Chicago, and San Francisco. Chris is a technical editor of FileMaker Advisor Magazine.

    Robert BowersBob Bowers is CEO of Soliant Consulting, and co-author of three books on FileMaker Pro, including Special Edition Using FileMaker Pro 7. Bob is one of a handful of trainers authorized to teach the FileMaker Professional Foundation Training Series. Bob has been a speaker at several FileMaker Developer Conferences, and was awarded the FileMaker Fellowship Award in 2002.

    Printer-friendly
    page layout

    Keyword Tags: FileMaker, FileMaker Development, FileMaker FileMaker Pro

    ADVISORAMA
    Who first figured out that an artichoke is edible -- and how to eat it?

    ARTICLE INFO

    FileMaker Advisor

    Web Edition: 2008 Week 10, Doc #19410

    Print Edition: April/May 2008, Page 5

    SUBSCRIBER ONLY ARTICLE LOCKED


    File: Get the code for the complex publishing technique.
    DOWNLOAD: 131,966 bytes

    Subscribe to FileMaker Advisor Magazine

    Read the advanced guide to creating custom business database solutions with FileMaker software. Subscribe now to gain access to all the archives and downloads.

    FileMaker.Advisor.com

    Subscribe to Advisor Basics of FileMaker Pro

    Learn the fundamentals of using FileMaker Pro software. Every issue gives you step-by-step instructions on creating the databases you need. Subscribe now!

    FileMaker.AdvisorBasics.com

    Secrets Of The Top Experts -- Now!

    See exactly how to do it, step-by-step, in Advisor Academy CDs created by the top experts. Click to see what you can learn right now.

    AdvisorAcademy.com

    Free E-Newsletters

    Keep up! Hot News, How-To, Tips & Tricks, Expert Advice, and more. Click to request your's free.

    AdvisorUpdate.info

    Need Know-How Now?

    What direction are you going with your business? Advisor Guides are packed with the answers you need to work smarter. Can you afford to fall behind?

    AdvisorStore.com

    Showcase Your Smarts

    Submit your tips, techniques and advice and let Advisor promote your business and build your career. Show the world what you know!

    AdvisorTips.com

    Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
    Portions copyright ©1983-2008 Advisor Media, Inc. All Rights Reserved.
    Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
    ADVISOR®, the ADVISOR logo, and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, Inc. in the United States and/or other countries.
    Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
    moyec074-02 posted 03/03/2008 modified 05/12/2008 03:42:38 AM ztfmfd/ztfmfd
    domino-144.advisor.com my.advisor.com 05/16/2008 02:52:21 PM