Community Videos, Tips, & Techniques, Articles.

At FileMaker, we have more than two decades of experience in helping people work better by making powerful technologies accessible to workplaces of all sizes. And now I’m thrilled to accelerate this mission in my new role as CEO. Dominique Goupil has led this company for twenty years. As he steps down into retirement, he leaves a legacy of high product quality and impeccable integrity. I’m grateful to everything Dominique has done for the company, and I’m looking forward to building on this foundation. It’s an exciting time for FileMaker. We’re seeing top and bottom-line growth. Last year, we introduced the Workplace Innovation Platform category. We are accele…

View File FileMaker Workplace Innovation Platform Security Building Blocks The FileMaker Workplace Innovation Platform has evolved over the past fifteen years since the release in 2004 of FileMaker® Pro 7 to encompass now a robust suite of security features to protect the Confidentiality, Integrity, Availability, and Resilience of organizational data. This same set of Security Building Blocks also helps to provide protection to organizations from a wide variety of risks including business continuity, regulatory sanctions, criminal and civil liability, and reputational damage. Submitter St…

The new version of the popular hardware integration plug-in now adds support for iOS Prague, CZ — February 25, 2019 — 24U has released 24U Phidgets Plug-In 3.1 for FileMaker Pro 14 through 17. The popular plug-in for integrating FileMaker solutions with hardware devices, such as relays, environmental sensors, RFID, and more, now brings support for iOS and re-designed examples. What's new in version 3.1 Version for iOS lets custom FileMaker apps control Phidgets directly from iPhone or iPad Better and nicer examples for exploring 24U Phidgets Plug-In even on iPhone or iPad Benefits of the new feature Having the plug-i…

FileMaker Inc has released 3 templates. Job Tracking Event Management Memberships https://www.filemaker.com/templates/

herrfriedrich.com, a FileMaker Platinum member is pleased to announce the dotfmp.berlin 2019 - The next Un-Conference for all types of Developers on higher levels. The 7th edition will feature again some of the most brilliant minds in FileMaker development, not only from all over Europe but also from the rest of the world. Since dotfmp is the only fully English-speaking FileMaker event in Europe, this is the chance to meet and share on a unique and personal level. It will be held from 6 - 8 June 2019 at the GLS Campus in one of the most vibrant areas in Berlin, accompanied by the informal and famous get-together in the oldest Beer garden on the afternoon of the …

A filter to de-dupe a portal. UniqueValues11.zip

If you've ever worked with multiple windows in FileMaker, either as a developer doing some troubleshooting or working in a multi-window database, you know it can be time consuming to open all those windows again and reposition them. This sample database demonstrates a technique that stores the names, layouts, and positions of your open windows, and re-opens them the next time you open the database. Download the demo and give it a try. FF_Window_Saver.fmp12

Testing FileMaker Network Performance Part 1 Get up to speed with the FileMaker Video Training Course! FileMaker is a cross-platform relational database application from FileMaker Inc. https://en.wikipedia.org/wiki/FileMaker Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro17.php Customer relationship management, processes implemented to manage a company's interactions with customers and prospects https://en.wikipedia.org/wiki/CRM Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 28 years of FileMaker exp…

I am running Filemaker Pro 16 and I use FMSP 4.6.6b1 Should I upgrade to Filemaker 17? And, is it easy to import all of my data (records) from FMSP 4.6.6b1 into FMSP 6? For the time being everything is working fine on FMSP 4.6.6b1. I also had some changes made for me on FMSP 4.6.6b1

We have a new fix for Google Maps in FMSP & the FMI Contacts Starter Solution Vid 1 - Getting your API Key: Vid 2 - FMI Contacts Starter Solution Fix Vid 3 - FMSP Fix Get up to speed with the FileMaker Video Training Course! FileMaker is a cross-platform relational database application from FileMaker Inc. https://en.wikipedia.org/wiki/FileMaker Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro17.php Customer relationship management, processes implemented to manage a company's interactions with customers and prospects https://en.wikipedia.org/wiki/CRM Experience Richard's…

We are having a hard time solving a problem involving one Mac (High Sierra) running Filemaker 17 (Advanced tools enabled). There is a webviewer which displays a page depending on the URL in a field. This has been working for years. The client has three Macs, all running FM17 and using FM17 Server. On two of the machines the pages show as normal. On the client's own machine the page does not show. Activity can be seen in the bottom bar of the webviewer as if the page is loading and, sometimes, one sees the URL flash up there. He has gone back to using FM16 as that works normally. This gets stranger. After many attempts to get to the root of this I put URLs from …

Hi every one, I’d recently been asked by a client to build an alternative method for FileMaker Quick find. The native FileMaker quick find use word-based search while there are lots of situations that users need to search for only a part of a word like a wildcard search. Also, you can not use FileMaker Quick Find on solutions that requires hiding the status area or when you open your solution on FileMaker go. Here is a blog post explaining two different techniques used to achieve a user-friendly quick find solution in FileMaker: https://iavenue.ca/filemaker-quick-find-alternative/ I hope these methods can help you with deve…

Under-the-hood video: http://bit.ly/2RWLt7t Sample File: http://bit.ly/streetsample How to setup Google Account: http://bit.ly/googlecloudsetup Get up to speed with the FileMaker Video Training Course! FileMaker is a cross-platform relational database application from FileMaker Inc. https://en.wikipedia.org/wiki/FileMaker Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro17.php Customer relationship management, processes implemented to manage a company's interactions with customers and prospects https://en.wikipedia.org/wiki/CRM Experience Richard's dynamic and exciting teaching format, while learning…

Hi All, I have requested this before but have not come to a solution yet. I have a container with a PDF insert. when selected, the user must be able to read the PDF attachment At this stage the PDF is not opening. It displays the PDF file name with the PDF logo only If I insert a picture it does display

I'm hoping this will be of help to someone. In my environment I use CWP to receive SMS status updates from our SMS gateway, allow customers to opt out of SMS marketing messages, and receive Balance requests from customer via SMS. I use two small PHP scripts, one for handling the SMS status messages and one for receiving customer requests (Opt-out or Balance). The problem I've encountered (and not fixed yet) is that sometimes the link between CWP and the FileMaker DB goes south. The php scripts can detect this, but the submitting party (all these requests come from our SMS gateway) can't alert me that there is a problem. So, in order to detect whether the en…

If you're working offline on your iPhone or iPad, this may improve your data sync between FM Go and FM Server. Many FM Go sync options try to sync too much data at once, and this can be problematic, even with a fast internet connection. Instead of connecting to the FileMaker server, this technique uses PHP scripts on a web server to push and pull data from FileMaker Server. This can result in faster data transfer. Read more

You can use plug-ins to make simple modifications to Word documents, but if you need something more flexible, use these techniques. Here's the full article: http://www.filemakerforever.com/articles/139

I rewrote a timepicker I liked (originally lifted from calendar5 by Readdle). It is now 'tableless', I almost had it 'scriptless' but could not get a refersh to happen, regardless, enjoy RIVET timepicker.fmp12.zip

Here's a handy tool for testing cURL requests in FileMaker. I've included some examples from Twilio, Dropbox, SendGrid and others: http://www.filemakerforever.com/articles/138 FF_cURL_Sandbox.fmp12

Leverage all the advantages of Dropbox for storing your files, and keep them accessible and organized from within FileMaker! Using the Insert From URL script step in FileMaker 16 and later, it is fairly simple to integrate a FileMaker database with Dropbox. Download the demo file for some ideas on how to set this up: http://www.filemakerforever.com/articles/133 This file includes an API settings screen that helps configure CURL options, and it also creates a log record for every API call made. This is very helpful for troubleshooting API calls.

Summer is over and our weekly FileMaker webinars are back! Our first one is this Thursday at 11am PDT, on “Relationships for Beginners”. Register Here: https://attendee.gotowebinar.com/register/6892433068111504642 We will spend 30 minutes covering a specific topic. Then the last 30 minutes will be an open Q&A on any topic. Topic List: Sept 13th: Relationships for Beginners Sept 20th: Find Records, Date Ranges, and Special Operators Sept 27th: Conditional Formatting (Can I making something Red?) Oct 4th: Automation (Repetitive Tasks can become Scripts) Oct 11th: Reporting & SubSummaries Oct 18th: Merge Fields and Hiding Objects (Harry Potter …

If you love FileMaker but are new to JSON, download this free educational tool and start learning! http://www.filemakerforever.com/articles/134

360Works' MirrorSync 5 - FileMaker Sync - FileMaker Training - FileMaker Experts - FileMaker Videos https://youtu.be/E7DOZHSgfzw 360Works' Deploy: https://youtu.be/S45NwYX80Xs 360Works' MirrorSync 4: https://youtu.be/at9asdCJ5hU 360Works' Clustering & Replication: https://youtu.be/bQlGHrNtHCg Get up to speed with the FileMaker 17 Video Training Course! FileMaker is a cross-platform relational database application from FileMaker Inc. https://en.wikipedia.org/wiki/FileMaker Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro17.php Customer relationship management, processes implemented to manage a…

Hi everyone, i'm posting here my first public solution. The main idea is to code an application unable to access to other FIlemaker File and get tables and index sizes. Everything is explain on the first template, please let me know what are you thinking about this. Thanks. Tom size_calculator_demo.fmp12 User : User without password

Using InsertByurl command i found that it wait 60 sec. before it tell you about an error. using this curl you can manage the timeout: --max-time <sec> then if you need a shortest timeout example 3 sec.: --max-time 3 the error is 1629 in case of timeout.

FileMaker Coaches' Corner - Tip 12 - FileMaker and Dynamic Charting Maps - Fusion Charts https://youtu.be/6VHgi1xYN-0 Download the sample file here: http://bit.ly/fmtofusioncharts Get up to speed with the FileMaker Pro 17 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 27 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference ,Richard will teach you all the ins and outs of building FileMaker S…

FileMaker Coaches' Corner - Tip 11 - Improve Performance - FileMaker - FileMaker Experts https://youtu.be/5D2qoA_S7u8 Get up to speed with the FileMaker Pro 17 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 27 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference ,Richard will teach you all the ins and outs of building FileMaker Solutions. The course is 50 hours of video content! Richard ha…

http://79.8.125.79:8080/fmi/webd/BigWify This is my IOT, the hardware is based on its web server located in the sd card and it doesn't need plug in, just http get. Working in progress....

Here is a nice UI element that I lifted from another app. RIVET expanding popover.fmp12.zip

View File Federated Identity Management, Zero Trust, And The FileMaker Platform Federated Identity Management is one of the most important concepts in modern Information Security Services. What is it, and how do developers and administrators implement it? What problems does it solve? How does it relate to the FileMaker Platform? Submitter Steven H. Blackwell Submitted 07/09/2018 Category White Papers FM Version Not Applicable

Good evening. I apologise in advance if this is not the most appropriate room for this discussion but I thought that somebody can move it if need be. I have had FMPA 17 on my Mac (High Sierra) since it was released - both worked fine for me - currently running 17.01.143. Perhaps over-ambitiously, I decided to load up the Beta of Mojave on my production machine. (did you just hear the fail tone?). When I start to work in layouts or scripts, the application crashes abruptly. The Mojave SP2 was released today and the Mac runs even better overall, but FM still dies a sudden death. Has anybody else experienced this? If so, is there a work around (and please d…

FileMaker 17 and FMSP 6 Webinar - FileMaker 17 Training - FileMaker News https://youtu.be/YB1sdWFbbsE Get up to speed with the FileMaker 17 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro17.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions. The course is 50 hours of video content! Richard has been involved w…

View File FileMaker® Server 17: Admin Console, Admin CLI, And Admin API Extensive discussion of new methods for administering FileMaker Server. Jointly authored with Wim Decorte. Submitter Steven H. Blackwell Submitted 05/15/2018 Category White Papers

View File FileMaker® Server 17: Server Monitoring Functionality Discussion of new processes for monitoring FileMaker Server. Jointly authored with Wim Decorte. Submitter Steven H. Blackwell Submitted 05/15/2018 Category White Papers

View File FileMaker® Server 17 And SSL Certificates: Configuration And Use Information about new SSL processes and options. Jointly authored with Wim Decorte. Submitter Steven H. Blackwell Submitted 05/15/2018 Category White Papers

We're happy to announce: #FileMaker Icon Replacements – dotfmp.berlin 2018-Edition https://www.herrfriedrich.com/de/goodies/ Right in time for whatever comes next…

(SYLVANIA, OH, USA, March 2018) - New Leaf Data, LLC is excited to announce the immediate availability of FM Inventory Starter (FMIS). Built on the FileMaker platform, FMIS is an ideal starter application for organizations and teams with inventory management needs, including: • Manufacturers • Distributors • Warehouses • Procurement Teams • Sales Teams FMIS includes the tables and fields needed for an inventory management solution. FMIS also has over 40 desktop layouts, including 3 templates. FMIS is extremely flexible. FMIS is not an off-the-shelf solution. Minimal scripting ensures that your organization can define your own…

FileMaker Coaches' Corner - Tip 10 - Directed Workflow In this video, Jonathan Lai explains and demoes Directed Workflows. Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 27 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference ,Richard will teach you all the ins and outs of building FileMaker Solutions. The course is 50 hours of video content! Richa…

In this Coaches' Corner tip, Richard Carlton challenges you to go learn how to use RESTful services! Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 27 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions. The course is 50 hours of video content! Richard has been involved wit…

FileMaker Coaches' Corner-Tip 8-Converting from fp7 to fmp12-FileMaker-FileMaker Experts Download the free PDFs to see FileMaker’s documentation: http://bit.ly/2nSg7BM Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 27 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference ,Richard will teach you all the ins and outs of building FileMaker Solutions. The…

FileMaker Coaches' Corner - Tip 7 - Slide Panel & Button Bar https://youtu.be/pjLL38KIkZo Download the free sample file here: http://bit.ly/2E2lAO1 For this Coaches’ Corner tip, Myles Debski demonstrates how to use a slide panel & button bar as an alternative to trying to hide a tab panel. http://fmstartingpoint.com/downloadform2.php http://www.fmcoachescorner.com Most Recent Upload https://goo.gl/Dbn9fm Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while …

For this Coaches’ Corner tip, MacKenzie Jew demonstrates how to use the Range operator in Find Mode and the benefits that this has. You can follow along with the demo by getting a free copy of our starter solution, FM Starting Point. http://www.fmcoachescorner.com http://www.fmstartingpoint.com Most Recent Upload https://goo.gl/Dbn9fm Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 2…

FileMaker Coaches' Corner - Tip 5 - Portal Record Moving via Sort https://youtu.be/pVt432ZlTVs For this Coaches’ Corner tip, Kristian Olsen explores using sorts to move a portal record up or down. The key is Sorts! Grab the sample file here: http://bit.ly/2FTJn3k http://www.fmcoachescorner.com Most Recent Upload https://goo.gl/Dbn9fm Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. …

Hierarchical JSON Viewer / Editor By Andy Persons & Doug West One of the standout new features of FileMaker Pro 16 is native support for the JSON data-interchange format. In addition to providing easy integration with a host of online services, it also provides developers with the tools to create robust hierarchical structures for use entirely within FileMaker. This hierarchical JSON viewer / editor file provides some tools for visualizing, manipulating, and leveraging JSON text. Features Automatically creates a representation of any JSON text as a hierarchical portal of records, where individual elements can be expanded and collapsed Dynamica…

For this Coaches’ Corner tip, Kristian Olsen demos a simple technique for creating a popup menu in which you can make multiple selections. Very useful! Grab the sample file here: http://bit.ly/2qTSttq FileMaker Coaches' Corner - Tip 4 - Editable Popup Menu - Custom Function https://youtu.be/HGw_nkhU58A www.fmcoachescorner.com Most Recent Upload https://goo.gl/Dbn9fm Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced …

For this Coaches’ Corner tip, John Boubonis demos a simple technique for creating a multi-page Invoice. You can follow along with the demo by getting a free copy of our starter solution, FM Starting Point: www.fmstartingpoint.com www.fmcoachescorner.com You can download FM Starting Point from this link: http://fmstartingpoint.com/downloadform2.php FileMaker Coaches' Corner - Tip 3 - Multipage Invoices - Multipage Printing https://youtu.be/DSXcIWZebqg Most Recent Upload https://goo.gl/Dbn9fm Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.…

For this Coaches’ Corner tip, Jonathan Lai demos a simple technique for creating a hierarchical portal i.e. a portal with dynamic sub-summaries. You can actually display or hide sub-summary groups! Very cool technique. Link to the demo file used in the video: http://bit.ly/2zaI9zo FileMaker Coaches' Corner - Tip 2 - Portal Filtering - Portal Sorts https://www.youtube.com/watch?v=JJiQ-50Hps8 www.fmcoachescorner.com Most Recent Upload https://goo.gl/Dbn9fm Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's …

Hello Everyone, I've written a PowerShell script to allow you to get a free SSL certificate from Let's Encrypt to use with FileMaker Server. You can schedule this to run every few months and renew your certificate automatically. Now there's no reason to keep using that default certificate. Check out the post for instructions! How to Use Let’s Encrypt SSL Certificates with FileMaker Server | Blue Feather - FileMaker Developer, Android, Web EDIT: One compatibility note for everyone - While it looks like it's all compatible with FileMaker Pro 13-15, only FileMaker Go 15 is compatible. FileMaker Go 14 is unable to connect with these certificat…

Most of my medium to heavy scripts are now performed on server. To give the users some feedback while they wait, I wanted a method that was simple and subtle. In this example I ; added a popover button with '+' icon set the feedback message in the popover title bar formatted, sized and positioned the popover added a OnObjectEnter script tigger to the popover in the script I add a PSoS step with Wait for completion set to 'On' last step of script is Close Popover

File Name: NavSystem File Submitter: jdu98a File Submitted: 07 Sep 2011 File Updated: 06 Oct 2011 File Category: Samples FM Version: 11 I wanted to see how far I could take the idea of using global repeating container fields to store layout objects, specifically for navigation buttons. This is what I came up with. All image and text values that are displayed on the layout for navigation are stored in an "Objects" table. The benefit of this is that any layout that has the needed global repeating fields on it will display the same navigation buttons and text. Want to add more buttons? Just go to the Objects layout (click the grey globe but…

How to Connect FileMaker to PayPal - Webinar Promo https://youtu.be/wurBUS7GOFY Thursday, Nov 9th | 1-2pm PDT Register here: http://bit.ly/2iRDaOn The Sample File will be released at the webinar. Question: Where is the Paypal Sample file? A: It will be released Thursday Nov 9th at the Webinar Question: Is the Webinar going to be Recorded? A: Yes. It should be available approx 48 hours after Webinar is complete. Question: Is there a Cost to this? A: No. There is no plugin, and the Sample File is FREE. However, you will need FileMaker Pro 16 or Go 16 Question: Does Paypal Charge for this Service? A: No, it is FREE. …

After voting up the 'Time Picker' suggestion in Filemaker's new Product Ideas, I thought perhaps I could just simplify the method of input without a picker and without punctuation. - enter times using only numbers. - AM/PM is determined by the Workday Starting Hour. - use punctuation to override. NOTE: - the Workday Starting Hour only considers hours 1-12 right now. - I have added a 'clamp' in the time fields auto-enter calc to the keep the start and end times logical. Enjoy and please post any improvements RIVET_rapid_time_entry_v1.zip

Hi all, it took a while to get this done but now I'm pleased to announce the "DevCon 2015" edition of a pack of Replacement icons for Filemaker from 11 to 14… well, to save work it is for the next version too (not sure if it's called 15 ;o) Download is FREE Have fun pixi

We got a new video for you about our latest functions for FileMaker 16. While talking to other developers at dotfmp conference in Berlin, a few developers told me about the new card window feature in FileMaker 16 lacking a few details in functionality. A quick check showed that a plugin could of course monitor mouse clicks and trigger a script if a click is done outside a given area. The new EventMonitor.SetCardWindow function allows you to define where the card is and which script to trigger in case of a click. This script can than clear the trigger with EventMonitor.ClearCardWindowand close the card.Please try next week the new plugin and this feature and let me know ho…

Hi All, I am happy to present the FmDynamix project, including cfCall () and #load (), my new 2 custom functions .... In an interest to further test FileMaker more and more ... I tried to give you a presentation of this new method, as explicit as possible, I hope to have succeeded ! You have the description and the presentation here, and take before the file demo : fmx_FmDynamix_Presentation.fmp12 I hope that this file will give you the urge to see this method, I do not think I have view of similar thing I hope that this "modularity" will please you and will give some ideas, feel free to test and give me your comments ! Thanks for your interest Agnès …

Here is a trick I use on popovers, since its difficult to place an object edge to edge on them without activating the scroll bars. select the object set fill to gradation pull the left and right gradation handles tight towards each other

A silly game - or ... ? Psychic.fp7.zip

Repeating fields are legacy feature in FileMaker however they do have their uses. I was trying to create a report with columns that would slide up to the height of the maximum field the problem with using regular fields and turning on any borders on the fields the sliding up of all above or directly above did not produce the desired result some columns would be shorter then others and the lines would not be consistent from the top of the body to the bottom. In this case the columns are all the same width so I thought the use a calculation will be able do the trick. With the final result sliding up to the height of the largest column, with a lit…

The deadline for submitting Program Proposals for the 2017 DevCon is fast approaching: just a little over a week left. There is a new format for this year. There is more information here: https://community.filemaker.com/community/devcon-2017/pages/about-devcon-2017 Steven H. Blackwell

for those using lauchbar's wonderful snippet feature, here are all the functions for the BaseElement plugin BaseElements_snipits.zip

When i use a local robot to create pdf files or other, i have a problem when the connection go down, filemaker loose every reference to the remote file. The only way is to close the file and open again, i solved this problem on Mac using this apple script. 1) The AS check the connection if ok open the file. 2) If the connection go down then the AS close the file and wait until the connection is up, at that time it reopen the file. 3) if you close the file then the applescript quit it self. I am not a Apple script developer, i assembled it using few examples, then probably isn't well done but it work. --------------------------------------…

Just a basic sketch with (almost) no frills. Compare previous implementations: Excelisys Hierarchical Portals: http://www.excelisys.com/tips-tricks-filemaker-downloads.php Mikhail Edoshin: http://edoshin.skeletonkey.com/ HierarchicalPortal11.zip

Just with installing 6.4pr8 (or newer) MBS Plugin, you get a new context menu in your script workspace. You can activate / deactivate script lines, copy, cut and paste. Enjoy! See picture

Some familiar FileMaker faces in this video:

2016_fmp_iconPack_v2.zip

Hi all, If anyone else is using Parallels 12 on a Mac this may be of use to file away somewhere. I run my development FM 15 Server in an OS X El Capitan Parallels environment. Host machine is OS X Server, VM is OS X. FileMaker Server runs on the VM. Generally works well for me. Upgraded to Parallels 12 when it came out a few weeks ago. Had to replace my backup drive as it wasn't big enough. The new drive is 4 tb, USB 3.0. The Host computer would see the drive but when I tried to attach it to the VM it would vanish - neither the VM or Host would see it, nor would Disk Utility on either side. Only way to get it back was to reboot the Host…

A while back I wanted to see if I could emulate the UI of Reeder3. While not very practical, there is a bit of an illusion that is kind of interesting. The sample has two layouts. The one you see in the gif and another with actual data. Enjoy RIVET 3 panel slider.zip

I have 4 layouts for a form that we print and the script goes to the layout for the form 4/6/8/12 depending on the data (wells) in the record. It turns out they need to batch print and its convoluted to write a print a script to switch layouts in an automated fashion. So I had revised it by using hide object when and stacked all the elements up on the layout but it turns out to be rather ugly in layout mode. this was using repeating fields in order to get the desired data to show. But then i decided on a better method - using button bars and hide objects. This essentially does the same thing but much easier to see in layout mode. Now I ca…

I needed a way to notify users that the server just received X number of new emails as I am using a server side plugin (360Works) to fetch mail every few minutes. However unless someone actually does something that triggers a script they have no visual notification in the database to know there is new mail waiting. Or they have to leave outlook/mail open just to hear the chime. I would like to introduce to you Boxcar http://www.boxcar.io an app/service that uses the push notification protocol to alert you on your iPhone with audible alerts, visual banners, badges, to see when an important event happened. The setup is this: Sign up for Boxcar - you can cho…

http://www.soliantconsulting.com/labs/2016/05/filemaker-15-executive-summary

Yet another way to quickly create multiple requests, one for each searched field. Requires version 10. Note that the list of fields to search could be created automatically by placing the fields on a layout (of another table!) and getting them via the FieldNames function. In both cases, fields can be freely renamed, and do not need to be named as layout objects. SearchMultipleFields10s.fp7.zip

Not a fan of reading a tome on a computer screen, too many other distractions to get you thru the content that really want to read? Check out Spritz which has a Spritzlet that you can add to your browser bar and then read long form text on most web pages. http://www.spritzlet.com After a bit of practice you can be reading more then 450 words per minute, and actually retain more of what you read. Although it works for narrative text - you may need to be selective when trying to consume technical articles or codes with a lot of examples. Cheers Stephen

Do you travel a lot for your job and need the best route possible to save time and money? Learn how to connect your FileMaker solution with the Google Maps Directions API for route optimization! Free sample file and video included. https://www.dbservices.com/articles/filemaker-google-route-optimization/ David Happersberger www.dbservices.com

Little tip ... It often happens that we wish to not allow pasting in a field. It 's simple, just two steps of a script and the trigger OnObjectEnter Set Selection [ Start Position:1 ] Copy [ ] Copyng an empty selection clears the clipboard.

In my view, in the world of FileMaker Server the concerns of owners and admin with FMS11 and earlier are little different to those of FMS14 admins today. Yes, the product has developed and we now have the new appearance layer from 12 onwards, and WebDirect from 13 on. But, the underlying issue remains, how do you get to understand FileMaker Server and get the best out of it, when it is trivial to build a very "bad" FM solution that is slow and unscaleable and when FMI provides no comprehensive and clear advice? FM software does little to prevent folk using the freedom of FM in that manner, because as an "enabling" and "accessible" type of software it lacks the controls…

Here is a demo of how easy portal sorting can be done in FM12. This demo uses the calculation that Tom Fitch provided a while ago with his portal sorting technique but one can use the PositionValue custom function as well. Portal_sort_fast12.zip

Do you have a FileMaker Server with connections for WebDirect/FileMaker Go? Read this article to learn more about how you can save money before price increases in May! FileMaker Server Connections Renewal Price Increase David Happersberger www.dbservices.com

You know a language that can reply as XML, and you would like to have your own "plugin?" Here is my outline/proof of concept; example written in PHP: http://wethecomputerabusersamongst.blogspot.com/2013/10/execute-php-script-from-filemaker-with.html There is also a contributed example using Ruby, NodeJS, ASP, or your favorite language that can deliver XML over TCP/IP( with some async approaches this may or may not time out. )

Deskspace Systems Limited in the UK have just released the Review Edition of the Deskspace rwApp Responsive Web-site Builder. It is of course built 100% in Filemaker. You can find out more and download it here: http://www.deskspace.com/rwapp_features.html Cheers, Nick Like many other web site builders... the rwApp Responsive Web-site builder enables you to write and edit your pages and immediately see how your page will appear. But there are two very big differences you will notice after comparing the rwApp Responsive Web-site builder with its competitors... (1) the rwApp Responsive Web-site builder is very very fast, both to render wh…

See this article: http://www.macnn.com/articles/16/02/16/not.so.much.an.app.more.a.way.of.life.132570/

Since FM14 came out with the new button bars having the ability to calculate data on the fly on layouts for display purposes has been great - the fact that you can display data without a dedicated calculated field or extra relationships just to display a bit of information. So I am generating a document that prints a portal however the data is not connected to the portal in the traditional parent / child relationship - but rather it's showing related data for the given product kits. This invoice line item record is not "parent" to the portal of kit items. That presented a challenge - originally i had a convoluted way to generated this report using a virtual lis…

Anyone have any experience of using barcode scanners with FileMaker, ie reading barcodes on boxes with a physical scanner, perhaps connected via usb? Or Bluetooth? Intended Usage is for stock control.

Awhile ago sixfriedrice.com had a great article on using the webviewer without the web. What was missing was a way to hyperlink back to the actual database. Well it is now possible by calling the FMP internet protocol along with a script name, a parameter and a variable. This example uses the FMP url to view a related record and set a field value. (hosted file only, I have to look at local file possibilities ). Along with this feature, FMP12 has also blessed us with the ExecteSQL function which is used here to compile all the data, reducing the need for all those messy TOCs. Enjoy. PS. if anyone can solve my line numbering in the html lay…

Hey, Just wanted to let everyone know about a little module we put together for geocoding and mapping. Simple to install and free to download. I'd love to hear what people think. http://msnmedia.com/blog/2015/04/10/geocoding-and-mapping-module-filemaker-pro

I had a client who took extensive notes during phone calls and occasionally they would loose the notes because of an interuption between FMP client and server. To help with the issue I created a small script to auto-save the notes on a timed interval, while the field is active. In this example I have the interval set to 12 sec. and to give the user an indication of when the auto-save happens, I have scripted an apple notifcation for Mac (10.9+) users and a title bar change for PC users. -enjoy If you see any way of improving please post update sample. RIVET field auto-save v1a.zip

This teaching is part of the Design Masterclass course [ DESIGNmasterclass.co ], but it's not quite ready for prime time yet, and that's why we're posting here! A select group of Design Masterclass alums are set to meet with us this Tuesday, Sept. 15 at 11:30 EDT, to review the teaching in private. There are TWO slots still open for that meeting, and we are looking for experienced designers to join us for the conversation. We prefer to find: Alums of the Design Masterclass or other app design training Software designers or project managers with experience leading software teams If you'd like to join us for a 60-minute roundtable discussion, please contact me here, o…

Just one script for all buttons, all layouts and all windows. Sorts occur dynamically. Each column restores it's last sort order and a default sort order can be set for each field type. Any comments or suggestions appreciated. Smart Sort List View.fmp12.zip.001

I find the v14 breakpoint icons just a bit light, so here are two replacements to be placed in: Filemaker/Content/Resources breakpointicons_content-resource.zip

[Content moved by OP from "FileMaker 14 Script Workspace" forum] Man alive, how long have FM developers pined for something like this!!! One thing about the Script Workspace is that it continues to reveal its secrets the more you work with it. Here are a few tips that make scripting faster and more fun to boot: 1. How do you insert a Comment line? The obvious way, of course, is to type a hash (aka "number/pound/octothorp") sign (simultaneous right pinky on the Shift key — left middle finger on the 3, or some equivalent thereof on other keyboard layouts), then type your comment. But try this instead: Hit Space, followed by Return, then comment away. (Space drops d…

Version 14 has made me rethink my custom debug keys. I have attached the macros for anyone using Keyboard Maestro FMP_debug_keys.zip

Three new Filemaker icons (13, 12, 11) for your newly installed OS X 10.10 Enjoy Filemaker_Yosemite_Icons.zip

For anyone using LaunchBar (Mac) and is aware of the snippet feature, attached is a set of Filemaker Function Snippets. Since LaunchBar searches by the snippet name, I have added spaces to the file/function name to speed up the results. i.e. 'Get(ScreenWidth)' is 'Get ( Screen Width )', this mean you can retrieve the function by typing 'gsw' A snippet is a simple text file with the function inside. You can edit the file to customize the pasted results, which I have done with a few of them. To install, unzip the attached file, and place all the .txt. files into: ~/Library/Application Support/LaunchBar/Snippets enjoy More Info: http://www.obdev.a…

Solution / : Multiple Portal Row Selection Description: This file will show developers how to allow end users to "select" portal rows in a single or multi user environment and display that selection. Further it allows selection of multiple portal rows simulating general OS functionality. Solution Status: Finished FileMaker Version: FileMaker 7+, FileMaker 9+ Author(s): Genx Date: 09/11/06 Disclaimer: FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indicated. Ple…

Using FileMaker Pro to generate Code 39 barcodes without the need for fonts or plug-ins. By Doug West, Product/Project manager for Excelisys. This FileMaker Pro file demonstrates the use of conditional formatting with a repeating field to draw the bars of a Code 39 (Code 3 of 9) barcode. This FileMaker Pro code 39 barcode generator uses a series of 16 “slots” per character which appear as wide or narrow bars. The intermediatebarcodeBitFlags field simply tells each repetition of the repeating field whether or not to use a background fill color, creating the bars. For the repeating field to display properly, the width must be set to 1 pt for each repetiti…

http://bluefeathergroup.com/blog/importing-xml-data-into-filemaker-using-xslt-xsl-style-sheets/ I've written a new post about how to create XSL Style Sheets so that you can import data from XML data sources into FileMaker. Please let me know if you have any comments.

For those looking for a way to do caller ID integration with FileMaker . . . . Here's what I have going. The US patent office's examiners each have a unique phone number, which we have stored in a database. When a phone call comes in on our VoIP phone (our provider is Phone.com, but Call Centric looks better and better), an AppleScript is trigger, which triggers a FileMaker script to show all the relevant patent applications we're working on with that examiner. Even before the phone is answered, we know who the person is, and what application(s) he's going to be discussing. The glue between our VoIP phone and FileMaker is a Mac program called Phone Amego. I hi…

I'm pleased to announce the availability of the first group of a series of new and updated demo and example files for FileMaker 13. The first ten demos in this series are available immediately and include a mix of new techniques based on the features of the FileMaker 13 platform, along with updated versions of some of our previous demos (reworked in light of the new features). This set of demos showcases a number of our favourites among the features of FileMaker 13. Eight of this first set of FileMaker 13 demos are unlocked, so that you can access the code. Two are preview-only (code available to registered users). These include an update to version 2.0 of our UltraLo…

I've gotten a lot out of this forum, so I try to pay it forward when I can, even though it'll likely only benefit newbies. I have an "image" button that is tied to a popover. So you click the button, and you get the popover. Easy enough. Usual UI interaction is that if you click the button, the popover appears, and if you click it again, the popover disappears. Again, all typical FM stuff. FM does not allow conditional formatting of image buttons to change the color. I wanted to emphasize to the user that for the layout field in question (in the popover), data has been entered. So I created another layout object -- an oval/circle surrounding the image button…

Background. A record in a table is related by a field to a field in another table. To select the related record, I use a dropdown box that shows all the relevant field values that can be selected from. The issue is, if the desired value is not there, you want the user to be able to enter a new value, and then automatically create a record for that new value in the related table.  I was having trouble with this issue previously, and decided to take another look at it. I came across the following solution, which is worth reposting here.  http://forums.filemaker.com/posts/d11c45f9f8  Here's the relevant section.   Now, for whatever reason, this d…