Planet FileMaker

... helping to feed the FileMakers ...

Contact | Random URL | FM Help Daily | Forums

July 30, 2010

FileMaker, Inc. News Feed

eWeek: FileMaker Go is nudging iPhone and iPad into enterprise space

eWeek notes the availability of new FileMaker Go for iPhone and FileMaker Go for iPad and reports, "FileMaker is nudging the iPad and iPhone further into the enterprise space by bringing their database technology to the mobile devices' users. The company released FileMaker Go iPhone and FileMaker Go for iPad Tuesday, and the programs are now available through Apple’s iTunes App Store. With FileMaker Go, users can view, edit and search for information in FileMaker databases."

July 30, 2010 06:21 PM

New FileMaker Go is a Top-Ten iPad App for Work, says Datamation

Datamation.com today surveyed the world of iPad Apps for work, for business and IT professionals, and lists the new FileMaker Go as one of the top ten iPad Apps for work.

July 30, 2010 06:21 PM

Mashable sees FileMaker Go appealing to serious business users

Mashable.com looks at the new FileMaker Go for iPhone and FileMaker Go for iPad and finds them "further proof that mobile devices, both phones and tablets, are being taken more seriously by business users. As business adoption increases, more robust application support has followed ... You can do almost anything with the data that you could in the FileMaker Pro desktop app, including sorting, connecting to external SQL data sources and even running most of the scripts that work with FileMaker Pro."

July 30, 2010 06:21 PM

FMLayoutMode

Screenshots from FileMaker Go

There has been a lot of talk on the various FileMaker forums about how we can do demos on our laptops and projectors for FileMaker Go, without having to make people huddle around our iPhones/iPads. As far as I can find, the answer is “Too bad, kid.” (Any Alice’s Restaurant fans out there?) Apple does have an [...]

by Paul Spafford at July 30, 2010 04:39 PM

FM Success Tips

102_FM_Success_Tips

Lee Strong, with 20 years of database and FileMaker experience, and Dr. Andy Cohen, with 25 years experience in IT development for fortune 500 companies, discuss valuable tips and hard to find tricks which enhance developing applications in FileMaker Pro. Occasionally joining them is well known FileMaker blogger Dwayne Wright, developer of InBizness FileMaker solutions with tidbits taken from his wealth of experience and online materials. These guys give an informative overview of not only the hidden stuff but also consulting issues such as project definition, pricing and scope as well as a regular review of functions and script commands. They also make a point of having a lot of fun!

by FM Success Tips (fmst@sonic.net) at July 30, 2010 01:00 AM

July 29, 2010

Newest FileMaker Pro Custom Functions

MaxLength ( field, foundCnt )

maximum trimmed character count for a field in current found set - Submitted by Simon Brown

July 29, 2010 11:37 PM

HOnza’s Bits @24U

Indicate Progress in FileMaker Go and 11

When I was preparing a sample file for the How To Prevent Support Calls video I wanted to make it as cool as possible, so I decided to optimize it for FileMaker Go. I quickly discovered that I need a plug-in free alternative for the progress dialog.

 
I wanted something nice looking while still as easy to implement as 24U SimpleDialog Plug-InThat really was the kind of challenge I like. I started getting ideas only to deny each of them in the very next second:
 
  • New window displaying a special "progress bar" layout - not good for Go, problem with maintaining script's context.
  • Transparent web viewer in the front layer rendering CSS - too complicated to develop, may be hard to interact with objects behind the web viewer. I also thought that rendering HTML is a bit of overkill.
  • Collection of fields to display progress status and progress bar - the oldest approach, a little boring, and too difficult to copy across solutions.
 
Then I got this one which I implemented in the sample file: conditional formatting

 
In this implementation a single global text field displays the progress status, 10 text objects use conditional fill color to show the progress bar, 2 button objects use conditional fill color to serve as a dialog-like background and frame. To implement it into your solution you only need to copy one field, one group of layout objects and then update the progress field and refresh window from within your script. Fair enough, isn't it? Well, not for me... ;-)
 
So I asked myself - can I make it even simpler? And I got another idea: merge variable
 

Then I created the final implementation:
  • No plug-ins
  • No fields
  • No dependency on the database schema
  • A single layout objects group to copy
  • No modifications necessary
  • Driven by a single global variable: $$progress
  • Works in FileMaker Pro 11 and FileMaker Go

And here it is for you to take and use for free:

(even directly to iPhone or iPad with FileMaker Go installed)

How do you like it?

Permalink | Leave a comment  »

July 29, 2010 09:33 PM

The Philadelphia FileMaker User Group

FMPug discounted memberships – with locked rate

FMPug is offering discounted memberships at a LOCKED in rate, in perpetuity.  As of this moment, the rate is $50.00 US, which I believe is half the usual annual fee.  There are only a limited number of discounted rates available, after which a lesser discount tier becomes available.  When those get used up, it’s back to to the regular rate.

Here’s how it works:

Your locked in rate is based on the number of COMPLETED transactions. To avoid losing the current promotional rate” (ed: currently $50), “we urge you to complete this transaction sooner rather than later. Wait too long and it could be gone! ;-)

** YOU’RE LOCKED-IN FOR LIFE! ** Here’s where things get really exciting! By signing-up now, the promotional price is your rate for life! That’s right, providing your membership never lapses, the promotional price will be your annual FMPug renewal rate for life! Whether you’re a new member or a renewing member, you won’t pay a penny more. It’s just that simple.”

Go here:

https://www.fmpug.com/signup

Is it worth it?  You bet.  But if you need more than the product discounts, mailing lists and so on, here’s an extra perk:

The all new iPad!

Er…wait, I mean this:

I meant THIS iPad.

Yeah, that’s it.

FMPug will be giving away four iPads to FMPug members – two at the FileMaker Developer Convention in August, and two to FMPug members who couldn’t attend DevCon.  I hear there’s some kind of FileMaker GO thingy that runs on iPads now too.

by Colin Keefe at July 29, 2010 06:27 PM

FileMaker Explore | The Support Group

Webinar: FileMaker Web Publishing (UPDATED 2x)

UPDATE 2: The recording is now available at WebEx.

*****

UPDATE:  If you missed today’s webinar with James, a recording should be available shortly.  We’ll update this post once it goes live.  Thanks to all that attended!  If you had a question for James and didn’t get a chance to get it answered, post in here in the comments for him.

*****

With about 1.8 billion people going online every day, the Internet is the platform to expand your reach and connect with your target audience.  On Tuesday, July 13th, join The Support Group’s James Dcunha, System Engineer, as he explores connecting FileMaker to the Web in this web seminar hosted by FileMaker, Inc.

FileMaker provides the ability to securely connect your database with the World Wide Web using several options.  Demonstrating different systems ranging from a super-simple site using Instant Web Publishing to a full-fledged shopping cart using Custom Web Publishing and PHP, James will discuss the strengths and weaknesses of each publishing option and what you’ll need to make your FileMaker data accessible to the Internet.

This 1-hour webinar will be offered twice on Tuesday, July 13th.  Reserve your place now as space is limited.

Date and Time:
Tuesday, July 13, 2010—11:00 am EDT / 8:00 am PDT
Tuesday, July 13, 2010—2:00 pm EDT / 11:00 am EDT

by Chad Novotny (cnovotny@supportgroup.com) at July 29, 2010 06:00 PM

SkeletonKey Blog

Skeleton Key - FileMaker: Inspector Keyboard Shortcuts

FileMaker: Inspector Keyboard Shortcuts

I used to use the keyboard shortcut in previous versions of FileMaker Pro to get to the "object info" window. One of the things I didn't like about FileMaker Pro 11 is not being able to get to the inspector without using the mouse. Well, I just found out how to get to it without the mouse. You may have already known this, but if you did shame on you for not telling me :-)

FileMaker Pro 11 Inspector

read more

by chad.adams at July 29, 2010 04:12 PM

July 28, 2010

FMPro.org

SUI Solutions Releases SUI Calendar 1.3, Now Fully Compatible with FileMaker 11

SUI Solutions, a certified FileMaker Developer and member of the FileMaker Business Alliance, announced today the release of SUI Calendar Version 1.3, a FileMaker 11 compatibility update to its powerful application for FileMaker that allows team members to efficiently collaborate on events, meetings and tasks... - (SUI Solutions)

by Jennifer Metayer (Jennifer@suisolutions.com) at July 28, 2010 10:12 PM

Newest FileMaker Pro Custom Functions

DayCounter ( Date_Start ; Date_End; Days_of_Week )

Counts number of times a day or days occurs over a date range - Submitted by Joshua Morton

July 28, 2010 08:20 PM

FileMaker Explore | The Support Group

DevCon Preview Webinar: FileMaker and Google Apps (UPDATED)

UPDATE:  If you missed today’s webinar, a recording should be available shortly.  We’ll update this post once it goes live.  Thanks to all that attended!

*****

FileMaker Pro makes it easy to create solutions to implement logic, automation, and business rules.  Google Apps - the suite of applications for email, contacts, calendars, documents, etc. - makes it easy to set up an organization with back-office IT systems.  For those that use both tools, linking the two together is a natural wish.

On Wednesday, July 28th, yours truly will be presenting a special DevCon 2010 session PREVIEW web seminar, FileMaker and the Cloud: Integrating with Google Apps, hosted by FileMaker, Inc.  I’ll be discussing some of the reasons The Support Group switched to Google Apps, and how we continue to use our FileMaker solutions with data stored “in the cloud.”  I’ll explore the challenges of using API’s designed for web applications, and demonstrate authenticating and adding and retrieving “records” from Google Apps through a FileMaker interface.

Registration is limited so please register for ONLY one web seminar.

For more sessions like these, be sure to attend the FileMaker Developer Conference, August 15-18 in San Diego, California.  Register today: http://www.filemaker.com/devcon

by Chad Novotny (cnovotny@supportgroup.com) at July 28, 2010 08:17 PM

Geolocation with FileMaker Go

Elizabeth in San Francisco is one of many to ask this interesting FileMaker Go question:

Is there any way to get the latitude and longitude of the phone in FileMaker Go and store them in a database?

My first reaction was “unfortunately, no.”  FileMaker Go can’t access the GPS features of the iPhone, and since we can’t use plug-ins with Go, there’s no opportunity to add that feature.  But never say never, right? 

After a few more moments thought, the answer appeared: FileMaker can’t access the GPS… but Mobile Safari can… and FileMaker has the web viewer.  Ah, the web viewer—FileMaker’s Swiss Army knife—how we love you!

Here’s our solution, requiring one web viewer, one script (plus a few more for fun), and just a few fields.

UPDATE: Todd Geist is doing something similar.  I like that’s he’s capturing altitude…I’ll need to see what happens the next time I take a flight offering WiFi grin

I created a simple webpage that uses the HTML5 geolocation features used in Safari.

<!DOCTYPE HTML>
<html>
  <head>
    <script type="text/javascript">
      function handler(location) {
      var messageArea = document.getElementById("messageArea");
      messageArea.innerHTML="<p>Latitude: " + location.coords.latitude + "</p>";
      messageArea.innerHTML+="<p>Longitude: " + location.coords.longitude + "</p>";
      messageArea.innerHTML+="<p>Accuracy: " + location.coords.accuracy + "</p>";
      }
      navigator.geolocation.getCurrentPosition(handler);
    </script> 
  </head>
  <body>
    <div id="messageArea">
      Location unknown 
    </div>
  </body>
</html>

With a browser that supports HTML5 geolocation services, when the location is detected the the result of that page should something like:

Latitude: 42.3028843
Longitude: -71.3770951
Accuracy: 30

with the source code now appearing as:

<html>
<head>
  <script type="text/javascript">
      function handler(location) {
      var messageArea = document.getElementById("messageArea");
      messageArea.innerHTML="<p>Latitude: " + location.coords.latitude + "</p>";
      messageArea.innerHTML+="<p>Longitude: " + location.coords.longitude + "</p>";
      messageArea.innerHTML+="<p>Accuracy: " + location.coords.accuracy + "</p>";
      }
    navigator.geolocation.getCurrentPosition(handler);
  </script> 
  </head>
  <body>
    <div id="messageArea"><p>Latitude: 42.3028843</p><p>Longitude: -71.3770951</p><p>Accuracy: 30</p></div>
  </body>
</html>

Notice the change following <div id=“messageArea”>.

UPDATE: Depending on what browser you use to test this, viewing the source may or may not show you the alteration in the messageArea div.  With Safari, use the Web Inspector’s Elements tab, rather than View Source; with Firefox and the Web Developer extension, use the View Generated Source option in the toolbar.

Next, we place that same webpage source code in a FileMaker global text field.  We create a web viewer with the object name “web” and specify a calculated URL:

"data:text/html," & 
geolocation::code

Using a URL that starts with data:text/html, tells FileMaker to treat the following text as an HTML page.  Essentially, it allows us to render a page from source code without needing a server and an HTTP request.

Our script resets the web viewer, waits a small amount of time to make sure the page has had time to render, and then checks the results with the formula GetLayoutObjectAttribute ( “web” ; “content” ).  If we have a result that contains <div id=“messageArea”><p>Latitude, bingo!

Now it’s just a simple matter to use FileMaker’s text functions to parse out the latitude and longitude.  We’ll need to do a little extra work to handle Apple’s data detectors—Mobile Safari sees the latitude and longitude numbers as possible phone numbers, and places <a href=“tel:...”> tags around them (UPDATE: We’ve updated the sample file to account for Mobile Safari not always detecting latitudes and longitudes as possible telephone numbers; our script sometimes gave us double negatives).  Once we have the latitude and longitude stored, an additional simple script can open a map to show us our location:

Open URL [No Dialog; "http://maps.google.com/maps?q=" & geolocation::latitude& ",+" & geolocation::longitude]

by Chad Novotny (cnovotny@supportgroup.com) at July 28, 2010 01:27 PM

ZeroBlue Blog

FileMaker Server-side Scripting

Running scripts from FileMaker Server can dramatically reduce execution time. I have been an avid fan of server-side scripting since it was introduced in FileMaker 9. Now, with the introduction of FileMaker Go it is more important to take the burden away from the client and do as much processing on the server as possible. There’s no need to bog down a client when the server can take care of the task in the fraction of the time it takes to run from client. You can use server side scripting to automate record updates from external sources, prepare those pesky Monday morning reports so they are printed by the time everyone comes in or simply use it to update stored data instead of using calculations.

You can run FileMaker scripts or System Level Scripts or even combine them to run a script sequence now! This article deals with FileMaker scripting.

We tend to think, now that we have this feature, we can just build our scripts, run them from server and be done. This isn’t quite true…we have to follow up with the all-important troubleshooting period. At least in my experience, there is no server-proof script that can be installed on a server without further testing and digging and modifications.

So, I collected some pointers from my–and fellow FileMaker developers’–experience that might help you speed up your development when running scripts from server. Don’t be discouraged. You will be happy with the results. Jump in and put some of those tedious scripts on the server, so you and your users can forget about them.

Things to know:

  • Make sure all your script steps are server compatible (choose “Server” under “Show Compatibility”–bottom left corner of “Manage Scripts”).
  • The server runs the opening and closing routines, so you might want to revise your “onOpen” and “onClose” script to bypass some steps that are not relevant to the server.*
  • Globals are set. This may not be an issue, but might be worth paying attention to.
  • No need to script opening a new window, because the server does not execute the scripts from physical windows, but rather a virtual space.
  • If you are referring to an external file in Manage/External Data Sources, folder names have to be hard-coded in the string (such as file:/folder name/folder name/file name.fp7 or filewin:/ if you are on Windows Server).
  • Import locations can only be either:
    • the Documents folder within the Data folder under the FileMaker Server root on your server machine (you can use Get ( DocumentsPath) to get you the right path; Windows users, don’t forget to use the “filewin” prefix);
    • the Temp folder (you can use Get ( TemporaryPath) and see the notes above).
  • Watch the log after you set your script to run, it can only help you!
  • Set up notification emails so you can be aware if something went wrong (you can turn these off after awhile).
  • Errors reported are FileMaker errors, not server errors.

Some caveats:

  • Lack of instant feedback. Even though you test until death locally, new problems can arise when running from server. Put in error checking after every step. I would also highly recommend logging script times.
  • You have to disconnect the client that runs the server script if a script hangs.
  • The script will hang if you forget to put in the “Perform Find” script step (possibly other actions or lack of them can hang the script, as well).

That’s it for now, but I will be adding to this article, so feel free to check back on occasion.

* I usually set up an account called “fmserver” to run the scheduled scripts with. Then I edit my onOpen script to bypass the opening routine if the account is fmserver. That can cut down on time and avoid unnecessary script steps.

Credit: Steven Blackwell, Todd Geist

by ariley at July 28, 2010 09:44 AM

FMPro.org

FileMaker 11 Events in Denver, CO

MightyData has partnered with FileMaker Inc. to offer a FREE FileMaker 11 Product Briefing in Denver, CO, on Thursday, August 5. The event will be from 9:30am-11:00am at the Embassy Suites Southeast, 7525 E. Hampden Avenue, Denver, CO 80231... - (MightyData)

by Kirk Bowman (info@mightydata.com) at July 28, 2010 05:20 AM

FileMaker Business Alliance Assists 2X in Providing Seamless Application Delivery

2X Software today announced its membership in the FileMaker Business Alliance, a group of FileMaker-affiliated members receiving promotional benefits, sales resources and cooperative marketing opportunities. FileMaker Business Alliance members have a reach of over 200,000 FileMaker customers, with collaborative support directly from FileMaker, allowing 2X Software increased support in delivering FileMaker to customers powerfully and efficiently, regardless of location... - (2X Software Ltd)

by General information (info@2x.com) at July 28, 2010 05:17 AM

360Works Releases ScriptMaster 4 and ScriptMaster 4 Advanced, Newly Updated Multifunction FileMaker Plugin

This free plugin now includes 81 functions, enabling developers to effortlessly manipulate files and folders, encrypt and decrypt sensitive data, download web pages and submit online forms, push notifications to iPhone and other iOS devices, and incorporate XML Web Services, shell scripting and event/script triggering... - (360Works)

by David Nahodyl (david@360works.com) at July 28, 2010 05:16 AM

Huslik Verlag offers File Repair Service

Huslik Verlag GmbH, a long time FileMaker© Business Alliance Member and creator of FMDiff, announces a new FileMaker File Repair Service. Damaged files will be tested and we will report back what we've found... - (Huslik Verlag GmbH)

by Winfried Huslik (winfried@fmdiff.com) at July 28, 2010 05:08 AM

July 27, 2010

geist interactive

Transactions Cheat Sheet

FileMaker Go has focused a lot of attention on writing scripts that can survive disconnects without hosing your data.  Luckily this is pretty easy to do.  I need to do a really in depth article on transactions very soon, but in the meantime I thought I would throw up this cheat sheet to help people, since I keep seeing the same couple of little problems over and over again.  So here is a FileMaker Transaction Cheat Sheet.

read more

by toddgeist at July 27, 2010 10:53 PM

The FileMaker Collective

August Meeting Date Changed

We had a good time at our Little Things that Reap Big Rewards meeting on the 15th. More than one person left saying that a particular tip was worth all the time to come to all the meetings put together. What were they? You missed them.

No. Just kidding. They’re posted on the blog entry below.

NEW AUGUST MEETING DATE
Because we simply can’t wait to get talking about FileMaker’s newest products (well that and a scheduling conflict) we are changing the August meeting from the THIRD Thursday to the SECOND Thursday. We’re sorry if you had your heart set on the 19th, but this month (only, we hope) the Kentuckiana FileMaker Users Group will have their monthly rendezvous on the 12th! Same time, same location though.

DESIGNING FOR IWP
After Alan Bird’s presentation on Instant Web Publishing in June, Byron Songer is stepping up to show you how to prepare your solutions to work efficiently with your new-found power. From visual design issues to some of the under-the-hood things you’ll need to know, now you can take full advantage of the the absolutely easiest way to take your data to the web.

GO-GO FILEMAKER MOBILE APPS!
“What are these new FileMaker products you are talking about,” you ask? Well, last week FileMaker released their long-lusted-for apps that run on the iPhone, Touch and the iPad (called FileMaker Go)! We are having fun playing with our new toys, and you will too! Various members of the committee will share their experiences with these game-changing new tools and we’ll pass around examples to play with your very own self.

Get a look a the future of FileMaker!

TIME/LOCATION:
August 12, 1:00 pm to 3:30-ish
1234 S. Third Street, Louisville

Info & RSVP: http://fmpug.com/scheduleMeetings.php

DON’T FORGET, NEW MEETING DATE!

See you on the 12th!

by louisville at July 27, 2010 03:42 PM

July 15th Tips-and-Tricks Event

Discussion notes from June 15th meeting.
Filemaker tips and tricks (Brian)
  • SugarSync and DropBox - off-site backups with restore of last 3 if needed!
Freeze Window
This script step freezes the redraw of the window while scripts process in the background. It saves time like crazy! Processing 12000 took 32 seconds in “real time,” then with the “freeze window” it took 4 seconds! NOTE: It does not work in IWP.
Copy Records
You can copy a record in form view or list view. Choosing Copy from the Edit menu copies the current record in tab delimited format to the clipboard. Add the option (shift on a PC) and it copies the same data from the entire found set! It only copies the fields on the layout. Also we found that Excel has a character limit and would not accept all the data from a larger set so keep an eye our for that.
We discussed some find techniques and talked about one that would look for “James” in both the first name field and the last name field. You’d enter find mode, then type “James” in first name then create a new find request and type “James” in the last name field. When you hit enter it will find all the records that had “James” as either the first name or the last.
Dates search >[Data] is the same as [Date]…
Put quotes around more-than-one-word searches to find exact matches like =”of the”
Bill demonstrated using auto-enter calcs to format entries–such as phone numbers and social security numbers–no matter what format the user entered it in. Phone number formatting is a simple start of the talk that leads into using Custom Functions to handle them.
On a side topic, Bill showed a custom function that generated HTML5 primitives (boxes, circles, triangles) in a FileMaker web viewer object!
Lotsa cool stuff!

by louisville at July 27, 2010 03:37 PM

geist interactive

FM GO Geolocation

UPDATE: I just added a new screen that shows your location too

So I have come up with a method to get Geolocation data into FileMaker.  I am using only native FileMaker scripting and layouts. 100 percent pure FileMaker goodness, made from all natural organic free range sustainable scripts.  No web services, no FileMaker Server, and of course no plug-ins.

I have put up a demo file and I would love it people would log in and try it out.  Once I make sure the bugs worked out I will release it in some form.   Here is the info.

read more

by toddgeist at July 27, 2010 03:40 AM

July 26, 2010

FileMaker Thoughts

A READER ASKS: FileMaker And SCRUM Management Tools

© 2010 Dwayne Wright - dwaynewright.com
From Dwayne Wright PMP - Certified FileMaker 10, 9 & 8 Developer
EMAIL: info@dwaynewright.com     TWITTER: dwaynewright

A READER ASKS
I came across your blog while searching for scrum tools.  I am looking for a scrum database tool that would allow me to implement scrum on a product development project, generate performance reports and share the backlog with the team.  Most of what I see being offered is large, enterprise applications, hosted or server based.  Too much for me.  Can you direct me to anything you've come across or even developed yourself?  I'm on a MAC with filemaker, so MAC based and filemaker is my preference.

-------
DWAYNE RESPONDS
Although I’ve reviewed SCRUM material, I haven’t been part of a development team using that methodology. To be quite honest, I’ve had a devil of a time finding FileMaker based workgroups that have used any official project management methodology to a high degree.

Most FileMaker development houses use their own tools to manage the GTD aspects of their business. The only tool that I’ve used is BaseCampHQ and I know that many other FileMaker developers have used it as well. I’ve used it to varying degrees of success for projects worked on remotely. I also introduced it to a 12 week project management practicum class at Bellevue College and we knocked a project out of the park for the non-profit organization HopeLink.

There isn’t any level of connectivity between BaseCampHQ and FileMaker.  If you can be more specific about your needs, I could do some more research for you and share those results on my blog. 

by [Your Name Here] at July 26, 2010 01:09 PM

FMLayoutMode

FileMaker Go is here!

All right, so it’s been almost a week, and I still haven’t posted about FileMaker’s new product. I’ve been busy, okay? Busy figuring out how to use the coolest product ever! FileMaker Go is a new iPhone, iPod Touch, iPad app that you can use to either run standalone FileMaker databases, or access databases being hosted by [...]

by Paul Spafford at July 26, 2010 03:50 AM