Filemaker Info
Follow
Find
128.7K views | +2 today
Filemaker Info
Your new post is loading...
Your new post is loading...
Scooped by David Anders
Scoop.it!

What's up with that, FileMaker?

What's up with that, FileMaker? | Filemaker Info | Scoop.it
  A client is upgrading to FileMaker 13 this weekend, both clients and server.  In preparation, we have upgraded the databases from 11 to 13 on test machines and laid the groundwork for a succ...
more...
No comment yet.
Scooped by David Anders
Scoop.it!

Non-Breaking Reporting Groups | FilemakerHacks

Non-Breaking Reporting Groups | FilemakerHacks | Filemaker Info | Scoop.it

Today we're going to look at a reporting challenge that comes up from time to time, and a technique that can be useful to have in your developer bag of tricks. 

demo file, Non-Breaking-Groups

more...
No comment yet.
Scooped by David Anders
Scoop.it!

FileMaker Function of the Week: Left, Right and Middle

FileMaker Function of the Week: Left, Right and Middle | Filemaker Info | Scoop.it

Text parsing pops up a lot when migrating data from an old system to a new one, or even when you realize that your data just needs some grooming. Whatever the impetus, Left, Right, and Middle are the cornerstones of text manipulation in FileMaker. All three simply extract a portion of the text you supply. Let’s start with Left and Right.

more...
No comment yet.
Scooped by David Anders
Scoop.it!

JavaScript Portals for FileMaker - SeedCode

JavaScript Portals for FileMaker - SeedCode | Filemaker Info | Scoop.it
SQLexplorer has always displayed your query results in a “JavaScript Portal” in a web viewer , and this was born from a pretty simple requirement. Since you can choose different columns for your SQL query, having pre-formatted fields in a traditional portal often didn’t “look right.” We thought that with a “simple” JavaScript grid we’d be able to dynamically set column widths as well as apply some basic formatting, i.e. text floats left and numbers float right.
more...
No comment yet.
Scooped by David Anders
Scoop.it!

Identifying Duplicate Values Using a Self-Join Relationship | FileMaker

This procedure identifies "extra" instances of duplicated records. You specify the criteria that determine which is the primary record.

This procedure uses a self-join relationship and a calculation field referencing the relationship to determine which records are duplicates.

more...
No comment yet.
Scooped by David Anders
Scoop.it!

The Self-Join Relationship: What it is and some examples of how to use it | FileMaker

A self-join is a relationship in which both match fields are defined in the same table. Define a self-join to create relationships between records in the same table. Use a self-join in a portal on a layout of the current table to display a subset of data that's in the current table, such as all the employees of each manager.

more...
No comment yet.
Scooped by David Anders
Scoop.it!

Automation in FileMaker Pro - Overview and Troubleshooting | FileMaker

Getting started with scripting

Differences between server based scripting and client scripting
FileMaker 13 Script Step Compatibility
General information about the Perform Script on Server script step
List of web compatible script steps
Miscellaneous script tips
Modeless script editing in FileMaker Pro
Planning scripts with FileMaker Pro
Script steps introduced in FileMaker Pro 10 and FileMaker Pro 10 Advanced
Script steps introduced in FileMaker Pro 13
Script time limits
Script triggers available in FileMaker Pro
Script triggers introduced in FileMaker Pro 13
Server side scripting with FileMaker Server
Understanding and using Script Triggers

more...
No comment yet.
Scooped by David Anders
Scoop.it!

Watermark Background | Clickworks

Watermark Background | Clickworks | Filemaker Info | Scoop.it
More and more invoices are sent as a PDF to customers. One of the drawbacks when sending your invoices digitally is that you loose the look and feel of a stationery on a printed version. Not anymore! Since FileMaker 13 we can use an image as (watermark) background for your PDF version of a print. In that way the PDF and printed versions will look the same!
more...
No comment yet.
Scooped by David Anders
Scoop.it!

The Scarpetta Group | FileMaker Development and Consulting

The Scarpetta Group | FileMaker Development and Consulting | Filemaker Info | Scoop.it
AppleScript OS X Notifications from FileMaker - How use FileMaker Pro 13 with the Perform AppleScript script step to create OS X notifications.
more...
No comment yet.
Scooped by David Anders
Scoop.it!

Updated Virtual Host for FMS13 guide and tool | DataManix

The new tool is now completely unlocked and does not use plugin anymore.  Also new in this version is support for SSL.

You can download the new version HERE

more...
No comment yet.
Scooped by David Anders
Scoop.it!

Reading FileMaker Crash Reports | DB Services

Reading FileMaker Crash Reports | DB Services | Filemaker Info | Scoop.it
Learn how to read crash reports to better understand what is causing your FileMaker database to crash. Examples included for both Windows and Mac crash reports.
more...
No comment yet.
Scooped by David Anders
Scoop.it!

FileMaker Support Methodology | FileMaker

The 6 categories are as follows:

  1. Solution: The FileMaker database / PHP / XML solution. This could be a single file, or multiple files making up a single solution.
  2. Application: The FileMaker applications affected by the issue. FileMaker Pro, FileMaker Server, or a combination of both.
  3. Operating System: The operating systems involved in the issue.
  4. Hardware: The system hardware involved in the issue.
  5. Network: Network topography, network hardware, ports, and network software.
  6. 3rd party: 3rd party FileMaker plug-ins, other applications that interface with FileMaker, other applications running on the system such as virus scanners...
more...
No comment yet.
Scooped by David Anders
Scoop.it!

▶ FileMaker Web Seminar: Idea to iPad - Job Ticketing System - YouTube

FileMaker Web Seminar: Idea to iPad - Job Ticketing System
more...
No comment yet.
Scooped by David Anders
Scoop.it!

Finding and deleting duplicate records in FileMaker Pro | FileMaker

During normal usage of a FileMaker Pro database you may find you have accumulated unwanted duplicate records.  If your database has only a few records, you can manually sift through the records, identify the duplicated records visually, and deal with them accordingly.  But if you have many records in your database, a visual check is not viable.  Fortunately there is an easy way to find duplicate records in a FileMaker Pro database regardless of how many records your database may contain.

more...
No comment yet.
Scooped by David Anders
Scoop.it!

Using self-join relationships to summarize data in Browse mode | FileMaker

Summarizing information is usually done with a summary field in a sub summary part. However, you can create a relationship to calculate summary information. Utilizing a technique that flags the first record of a series, we can extract the summary information in the first record only. This field can then be summarized to produce a Total of summary data.

more...
No comment yet.
Scooped by David Anders
Scoop.it!

Understanding and creating many-to-many relationships in FileMaker Pro | FileMaker

Understanding and creating many-to-many relationships in FileMaker Pro | FileMaker | Filemaker Info | Scoop.it

A relational database consists of data and information organized into different tables.  A table is used to define a specific, single group of information, like a table of customers for a business or a table of products that the business sells.  Each record in that table should include a “key field.”  A key field is a field or combination of fields that uniquely identify a record (row) in a table.  A key field can be referred to as a "primary key" and a "foreign key."  A "primary key" is a key field that is in the same table as the record it identifies.  A "foreign key" is a key field that identifies a record in another table.  Understanding the difference between a primary key and a foreign key will be useful when dealing with many-to-many relationships in FileMaker Pro.

more...
No comment yet.
Scooped by David Anders
Scoop.it!

Connecting to a file via FileMaker Go | FileMaker

Connecting to a file via FileMaker Go | FileMaker | Filemaker Info | Scoop.it

Opening a shared / hosted file using FileMaker Go

The method for opening a shared / hosted solution in FileMaker Go is the same regardless if the solution is being shared / hosted by FileMaker Server or FileMaker Pro.

more...
No comment yet.
Scooped by David Anders
Scoop.it!

FileMaker Plug-in Mayhem

FileMaker Plug-in Mayhem | Filemaker Info | Scoop.it
  I started working with FileMaker 13's new Install Plug-In File script step recently after watching Matt Petrowsky's video on this subject.  

When FileMaker is started, it reads all three locations in this order:

  • Legacy Location
  • Old Location
  • New Location
more...
No comment yet.
Scooped by David Anders
Scoop.it!

Unlocking Hidden Error Messages in the ExecuteSQL Function

r the field Tasman_URL from a table occurrence named zdev_Settings. This table only has a single record, so we do not require a WHERE clause in the query.
more...
No comment yet.
Scooped by David Anders
Scoop.it!

Working with JSON data in FileMaker

JSON however doesn’t parse easily with FileMaker’s text handling functions. And using a WebViewer has a number of complications, the main one being the awkwardness of getting data in & out of the WebViewer. Some other solutions only parse JSON, but don’t encode it. So I am going to propose yet another way.

more...
No comment yet.
Scooped by David Anders
Scoop.it!

Old Timey Insult Generator - FileMaker Database | Free

Old Timey Insult Generator - FileMaker Database | Free | Filemaker Info | Scoop.it
A FileMaker database that generates amusing, archaic insults.

http://fullcityconsulting.com/wp-content/uploads/2014/12/Insults.fmp12.zip

more...
No comment yet.
Scooped by David Anders
Scoop.it!

Pricing - Mandrill from MailChimp

Pricing - Mandrill from MailChimp | Filemaker Info | Scoop.it
Mandrill is a new way for apps to send transactional email. It runs on the delivery infrastructure that powers MailChimp.

Your first 12,000 emails per month are always free

more...
No comment yet.