My.ADVISOR.com Sign-In
ID
Password

Member Center / Sign-Up
Go to Article
Advanced Search 

ADVISOR TIPS

Recreate the FileMaker Pro Status Area with a Web Viewer

This technique lets you separate the status area from the context of the current table.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor


I had an epiphany when, at the 2008 FileMaker Developer Conference, I saw Todd Geist's technique for recreating the status area using the Web Viewer. What the Web Viewer allows you to do, over traditional calculation field approaches, is remove the feature from the context of the current table. In other words, traditional calculation techniques require you to create calculation fields in each table to represent the found count or current sort order. For example, you might create the following formula in a calculation field:

Get(FoundCount)

If you set the storage options for the calculation to unstored, the result of the calculation will update as the found set changes. The only problem is, you have to create the same calculation field in every table where you want to recreate the status area. If you use the same techniques in a Web Viewer, you only have to create the formula once and copy and paste the Web Viewer from layout to layout and file to file, thus, abstracting the calculations from the table schema.

For starters, you first have to know how to reference HTML code without referencing an external file. It's actually quite simple, requiring a short piece of code at the beginning of your HTML:

data:text/html,

Recreate the FileMaker Pro Status Area with a Web Viewer

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.

    John OsborneTechnical editor John Mark Osborne is president and owner of Database Pros, offering FileMaker resources on the Internet. He is author of Scriptology, a speaker at FileMaker Developer Conferences and Macworld conferences, and a trainer for the Professional Training series created by FileMaker, Inc. http://www.databasepros.com jmo@filemakerpros.com

    Printer-friendly
    page layout

    Keyword Tags: FileMaker, FileMaker Development, FileMaker FileMaker Pro, User Interface

    ADVISORAMA
    All Hollywood corrupts, and absolute Hollywood corrupts absolutely.
    -- Edmund Wilson

    ARTICLE INFO

    FileMaker Advisor

    Web Edition: 2008 Week 41, Doc #19542

    Print Edition: October/November 2008

    FREE ACCESS FREE ACCESS

    SUBSCRIPTION STATUS
    You are not signed-in. If you are a subscriber to this publication, sign-in above to access locked articles. To subscribe or renew go to www.AdvisorStore.com.

    Subscribe to DATABASED.ADVISOR.com

    Get it all -- every current and past ADVISOR tech/business publication, now all-in-one subscription, with new articles and a huge reference library packed with expert advice, how-to and downloads. Subscribe now to get it all.

    DataBased.Advisor.com

    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

    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.
    Hosted by Prominic.NET Website powered by
    LOTUS SOFTWARE
    osboj041-01 posted 10/06/2008 modified 01/05/2009 03:44:23 AM ztfmfd/ztfmfd
    domino-144.advisor.com my.advisor.com 01/07/2009 11:38:33 AM