Skip to Content

Topic: FileMaker Layout Design

So, why is the Scriptology Theme Studio so helpful?

With its combination of useful tools and ever growing collection of attractive layouts, the value of the Theme Studio is pretty high. "I just wanted to save time when working in Layout mode - I wanted to do things faster." said Matt Petrowsky of ISO FileMaker Magazine.

The product pretty much speaks for itself as soon as you start to use it. Since it is itself, a FileMaker database, it centralizes all of your graphical efforts. This really impacts the design process...

More information >>

FileMaker Blogs

38 weeks 6 days ago

Troi File Plug-In 7 released for FileMaker Pro 12 | MacTech

You can now drag one or more emails from the Mail.app to the FileMaker window. The updated DragAndDrop example file reflects the Mail Drop functionality with an extensive example demonstrating the handling of single ...

...
38 weeks 6 days ago

Thread: Can't seem to resolve path of attachments - FileMaker Today

Not sure why I'm having so much trouble with this. I have saved a document for attachment to this path (at least I think it is): /Macintosh HD/Users/steve/Documents/SI_logo_highres-1.pdf For the path to the attachments in the ...

...
38 weeks 6 days ago

[ANN] PCI Announces New Features and ... - FileMaker Today

San Diego, CA - July 25, 2013 - Productive Computing, Inc., a Platinum member of the FileMaker Business Alliance, today announced the release of File Manipulator version 3.0.0.0. This new version has been greatly ...

...
38 weeks 6 days ago

How Do I Send Email to Multiple Recipients via ... - FileMaker Today

Hi, We use Filemaker here to track a number of databases. We've just created a new database, and with it's use I'd like to have FM send an email every time a new record is created and saved. How can I accomplish this? Thanks in advance!

...
38 weeks 6 days ago

FM pro 13 release in the next couple or so months? - FileMaker Today

Just considering my licencing and upgrading schedule, hence the speculation.

...
38 weeks 6 days ago

Thread: Problem Logging into Hosted Database - FileMaker Today

Hi All I am certain someone can answer this very quickly Issue: a user cannot log into a database hosted by FM 11 (NOT server) Setup: A .fm7 database hosted by FM Pro 11 on a mac with 2 users on a mac connecting to the ...

...
39 weeks 20 hours ago

Scripting multiple find requests + omits - Finding ... - FileMaker Forums

Scripting multiple find requests + omits - posted in Finding & Searching: I have a solution, which I would prefer to not display the toolbar (because it looks nicer, restricts functionality, etc.). I have a button to enter search mode, ...

...
39 weeks 20 hours ago

Insert File Script Step - Managing Scripts ... - FileMaker Forums

Insert File Script Step - posted in Managing Scripts: I can not for the life of me get this script step to work when defining a specific volume. I am simply trying to insert a document with this path - filemac: ...

...
39 weeks 20 hours ago

Unexpected login prompt - Security Concepts ... - FileMaker Forums

Unexpected login prompt - posted in Security Concepts: We run FMP11 Server Advanced (on Windows) with FMP 11 Clients. The server supports a large number of separate legacy databases which are closely interlinked to ...

...
39 weeks 22 hours ago

Thread: "Database not available" in IWP - FileMaker Today

I have a Filemaker Server 12 Advanced running a few databases with IWP. They have been running fine for a while, but suddenly I am now getting "Database not available", when I try to access through a browser. I get the first ...

...
39 weeks 1 day ago

Export to Excel creates empty rows - Importing ... - FileMaker Forums

Export to Excel creates empty rows - posted in Importing & Exporting: Hi I have an Order Management System. I create a Revenue Report based on the month and year given by the user. When this report is exported into excel, ...

...
39 weeks 1 day ago

How Can One Scale Bar Charts? - Charting ... - FileMaker Forums

posted in Charting: In the FileMaker Pro 12 Training Series they give a problem of displaying a list of salesmen, each with a bar chart. The problem with the solution is the charts are not scaled to each other so that a salesman ...

...
39 weeks 1 day ago

Extensible Stylesheet Language Transformation (XSLT)

I recently had a reason to use Extensible Stylesheet Language Transformations (XSLT) on a project and thought I would give a little tutorial and share some information on the topic. 

XSLT is a templating language used to create and transform XML documents, similar to the way that CSS files are used to transform HTML documents.  A notable difference, however, is that HTML tags are defined by the standard. 

When I want my CSS to target an HTML tag, the CSS knows what to look for because a tag will always look the same.  In XML, tags are not predefined.  That is to say, I can create an XML tag with whatever name I choose.  This forces XSLT to be more dynamic, and it achieves this dynamism through a tool called XPATH, which is used to traverse elements and attributes in XML.

In short, templates are created using XPATH that will match parts of the source XML document.  When it finds a match, XSLT will change the matched section of the source XML into your destination XML or XHTML document.

Now that you have a basic understanding of the concept behind XSLT, let’s get into a brief example.  Let’s say you have some software that tracks a library of books.  This software can give you an XML output of the library. 

You want to transform that XML dump into a format that can be published on your website.  We can use XSLT to accomplish this fairly easily.  A sample of the XML output that we have looks like this: 

<?xml version="1.0" encoding="ISO-8859-1"?>

Enders Game
Orson Scott Card
1985

Watchmen
Alan Moore
1987

The first thing to note is how to declare an XSL style sheet:

Putting this declaration at the top of our document will give access to the necessary XSLT features.  Then we will create an XSL Style Sheet to transform our XML into XHTML:

<?xml version="1.0" encoding="ISO-8859-1"?>

Nick's Book Collection

Title
Author
Year

This creates a fairly simple template that contains a foreach loop that will iterate each tag, retrieving the title, author, and year published values while placing them into HTML rows.  The only thing left would be to link to your XSL stylesheet in your XML document with a tag that looks something like this:

<?xml-stylesheet type=”text/xsl” href=”xslstylesheet.xsl”?>

Now when the browser loads your page, it will be a nicely formatted XHTML document. 

I hope this beginner example is helpful.  There is a lot more to XSLT and it can do some surprisingly powerful stuff.  This post should help you get a basic understanding of how it works so that you can start transforming your XML however you need.

Web
PHP/Web

XML
XSL
XSLT

...
39 weeks 1 day ago

FileMaker - reporting with automatic vertical headers - igeek

FileMaker allows for a great deal of control over the creation of reports. Aside from the main body part, we have layout parts such as title header, header, leading grand summary, sub-summary, trailing grand summary, footer ...

...
39 weeks 2 days ago

[ANN] New Version of SQLexplorer. More power ... - FileMaker Forums

[ANN] New Version of SQLexplorer. More power-user features. Still Free - posted in Product Announcements: The new version of SQLexplorer includes tools to review your query results and refine your query before pasting it ...

...
39 weeks 2 days ago

WAN caching sytems and FileMaker - Connectivity - FMForums

WAN caching sytems and FileMaker - posted in Connectivity: Has anyone had any experience using WAN optimization hardware, e.g. Silverpeak, with FileMaker? The basic idea is you have two dedicated machines at both ...

...
39 weeks 3 days ago

FileMaker in Architecture - Konstrukshon CPD Weblog

I use FileMaker for several reason, the most important being I want to keep a collection of information that's more or less in the same format, now you might be saying, well why not just stick with Evernote, simple, it will not act ...

...
39 weeks 3 days ago

Have Any FileMaker Runtime Solutions Been Accepted on the Mac ...

Have Any FileMaker Runtime Solutions Been Accepted on the Mac OS X App Store? - posted in Advanced & Developer Features: Hi, Ive read that there are tricks to get a FileMaker runtime solution consolidated into a single ...

...
39 weeks 4 days ago

Put in which file? - Value Lists - FMForums - FileMaker Forums

OK. I have two files one with GUI and one with the data. Now I want to make value lists but both files seem to be able to create the same value list in their own file using the table occurrence there but also can create a value list ...

...
39 weeks 4 days ago

Issue with fonts showing up on Mac - Layouts ... - FileMaker Forums

Issue with fonts showing up on Mac - posted in Layouts: Hello everyone, I cant figure this one out. I have some nice fonts I installed on my Mac. They are working and available in all the other programs on my Mac. However ...

...
39 weeks 4 days ago

Import from multiple tables of one file, select it ... - FileMaker Forums

Import from multiple tables of one file, select it only once? - posted in Importing & Exporting: Im hoping this is possible but trawling through the FMP documentation and forums here hasnt resulted in a solution to what Id like to ...

...
39 weeks 5 days ago

Summer of Software: Filemaker Pro 12 | andybartlett.com

Today was my first real attempt to build something useful in Filemaker Pro, and I made solid progress. My vision is to build a database that will allow me to maintain an archive of media mentions of Bemidji State coming into ...

...
39 weeks 5 days ago

SuperContainer returns error of -1 ... - FileMaker Forums

SuperContainer returns error of -1 - posted in SuperContainer by 360 Works: Many times when uploading files (using the plug-in not the web object) it returns and error of -1. It appears to complete the task of uploading so ...

...
39 weeks 5 days ago

Version Number Field - DocuBin by 360 Works ... - FileMaker Forums

Version Number Field - posted in DocuBin by 360 Works: Can you tell me what the version number field is? Version::Version Number gives me the number of times the record has been edited, but not the actual version ...

...
39 weeks 5 days ago

To write Stored Procedures in FileMaker - FQL or FileMaker Query ...

To write Stored Procedures in FileMaker - posted in FQL or FileMaker Query Language: Hi All, Is possible to write Stored Procedures in FileMaker? If yes, how can we write? Thanks in advance.

...