My.ADVISOR.com Sign-In
ID
Password

Member Center / Sign-Up
   
SUBSCRIPTION STATUS
If you are a subscriber to this publication, sign-in to access locked articles. To subscribe or renew go to www.AdvisorStore.com.
Go to Article

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,

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

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.

ARTICLE INFO

Web Edition: 2008 Week 41, Doc #19542

FREE ACCESS FREE ACCESS

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

Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
Portions copyright ©1983-2010 Advisor Media, LLC. 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, LLC 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
ztfmfd0810 osboj041-01 posted 2008-10-6 mod 03/15/2010 03:12:16 AM ztfmfd/ztfmfd
domino-144.advisor.com my.advisor.com 03/15/2010 05:50:36 PM