Jump to content
  • entries
    41
  • comments
    8
  • views
    19,175

Entries in this blog

 

Toggle two fields

Say you’ve got two fields, both number fields, and you want to use them as flag fields, to be set to either 0 or 1. But they should always be opposite from each other. Changing one field should change the other and vice versa. At first, that seems simple. You just need to make each field an auto-enter referencing the other field, right? Nope. That doesn’t work. FileMaker’s calculation engine does not like that sort of circular references. Field A changes so Field B changes so Field A changes, e

David Jondreau

David Jondreau

 

DevCon 2018 Review

DevCon 2018 was held at the Gaylord Texan Resort and Convention Center win Dallas, Texas from August 6th through the 9th and it was a great event. The Gaylord Texan (GT) is a destination unto itself. It’s enormous with several acres of open ground enclosed by a dome and a combination of a convention hotel and a family destination. There were a couple other conferences going on, including, notably, QuakeCon with hundred of video game fans hauling their heft PC towers and giant monitors through t

David Jondreau

David Jondreau

 

Fasting

In the blogs and forums I favor, there’s a buzz over the past few years about “intermittent fasting”.  The idea is that not eating all the time is healthy. As far as physical and emotional health benefits, the pop science seems intriguing and it meets my common sense filters, so why not try it? There’s a few different versions. 16/8 is popular. That’s where you only eat in the same 8 hour window each day. Say, from 10 AM to 6 PM. That’s sounds helpful, something I would call “time-restricted ea

David Jondreau

David Jondreau

 

Modified timestamps and importing

At DevCon 2018, Molly Connolly led a session on data cleaning. During that session, there was a question of how to import data without updating the Modification timestamp. The goal is to display when a user last modified a record, not the developer. Two methods* of doing that were mentioned but there is another, more robust, answer. It’s simple and flexible: create an additional field that references the Modification Timestamp field and set a variable flag when you don’t want to update it. Le

David Jondreau

David Jondreau

 

7 cool tools for better nerd living

If you’re a dev, you are a power user. Below are 7 digital tools that are indispensable, and not necessarily for coding. I don’t know if they share any common characteristics, except that when I don’t have access to them, I grunt in frustration.   Nanny / LeechBlock / WasteNoTime Distraction is a huge productivity killer. For me, it’s the #1 issue in ‘getting things done’. I’m an info junkie and I have low self control. Me, making a living at a computer, is like being a recovering alcoholic a

David Jondreau

David Jondreau

 

Interesting quirk for unrelated field reference in field definition

One apparent limitation of using ExSQL() in the separation model is that you can’t use unrelated tables in a field definition. So you’d need to related all your tables to one another. I just discovered that you can bypass that limitation simply by wrapping your statement in a Let() and declaring a variable that includes wrapping a field in the GetFieldName() function. So the expression: Let( field = unrelated::table ; field ) returns an error. However, Let( gfn = GetFieldName ( unrelated::tab

David Jondreau

David Jondreau

 

Interesting quirk for unrelated field reference in field definition

One apparent limitation of using ExSQL() in the separation model is that you can’t use unrelated tables in a field definition. So you’d need to related all your tables to one another. I just discovered that you can bypass that limitation simply by wrapping your statement in a Let() and declaring a variable that includes wrapping a field in the GetFieldName() function. So the expression: Let( field = unrelated::table ; field ) returns an error. However, Let( gfn = GetFieldName ( unrelated::

David Jondreau

David Jondreau

 

Triggering a server-side script Part II

Part II will include a custom function to create your URL, an example of a feeder script to manage the process, and an explanation of why the Guest account is necessary. In Part I of this series, I explained how to trigger a server-side script using XML. In this part, I’m going to give you a custom function to aid this process and explain why you need to enable the Guest account. First, the Guest account. To access the XML engine on the FileMaker Server by a browser, a user will always be take

David Jondreau

David Jondreau

 

Triggering a server-side script Part II

Part II will include a custom function to create your URL, an example of a feeder script to manage the process, and an explanation of why the Guest account is necessary. In Part I of this series, I explained how to trigger a server-side script using XML. In this part, I’m going to give you a custom function to aid this process and explain why you need to enable the Guest account. First, the Guest account. To access the XML engine on the FileMaker Server by a browser, a user will always be take

David Jondreau

David Jondreau

 

Triggering a server-side script Part I

FileMaker does most of its processing client side. That means when a client wants to do a find, or show the result of a calculation, the data necessary to do the action is transferred from the server to the client and the client calculates the result. This is handy because you don’t need super powerful [...] Source

David Jondreau

David Jondreau

 

Triggering a server-side script Part I

FileMaker does most of its processing client side. That means when a client wants to do a find, or show the result of a calculation, the data necessary to do the action is transferred from the server to the client and the client calculates the result. This is handy because you don’t need super powerful servers and the amount of load put on the server itself is reduced. But there’s a tradeoff, in some circumstances, it can also be extraordinarily painful. If a lot of data needs to be moved, the t

David Jondreau

David Jondreau

 

Triggering a server-side script Part I

FileMaker does most of its processing client side. That means when a client wants to do a find, or show the result of a calculation, the data necessary to do the action is transferred from the server to the client and the client calculates the result. This is handy because you don’t need super powerful servers and the amount of load put on the server itself is reduced. But there’s a tradeoff, in some circumstances, it can also be extraordinarily painful. If a lot of data needs to be moved, the t

David Jondreau

David Jondreau

 

Running an iPad database as a Kiosk

Doug Alder of HomeBase Software out of Vancouver, BC posted an excellent explanation of locking down an iOS device to use an FM Go database in “Kiosk” mode, using the Accessibility options. While you’re there, check out his FileMaker Timeline (which isn’t working in Chrome for me, but in Firefox it looks great). Source

David Jondreau

David Jondreau

 

Running an iPad database as a Kiosk

Doug Alder of HomeBase Software out of Vancouver, BC posted an excellent explanation of locking down an iOS device to use an FM Go database in “Kiosk” mode, using the Accessibility options. While you’re there, check out his FileMaker Timeline (which isn’t working in Chrome for me, but in Firefox it looks great). <a href="http://wingforward.net/running-an-ipad-database-as-a-kiosk" rel='nofollow external'>Source</a>

David Jondreau

David Jondreau

 

Running an iPad database as a Kiosk

Doug Alder of HomeBase Software out of Vancouver, BC posted an excellent explanation of locking down an iOS device to use an FM Go database in “Kiosk” mode, using the Accessibility options. While you’re there, check out his FileMaker Timeline (which isn’t working in Chrome for me, but in Firefox it looks great). View the full article

David Jondreau

David Jondreau

 

FileMaker Server 12 Plugins

tl;dr: Plug-in developers can now update their plug-ins to run in 64 bit mode. There’s an undocumented change to how the Web Publishing Engine runs that affects where to install plug-ins to be run by CWP. A few weeks ago FMI released the FMS 12 v2 update, adding support for 64 bit plugins used by [...] Source

David Jondreau

David Jondreau

 

FileMaker Server 12 Plugins

tl;dr: Plug-in developers can now update their plug-ins to run in 64 bit mode. There’s an undocumented change to how the Web Publishing Engine runs that affects where to install plug-ins to be run by CWP. A few weeks ago FMI released the FMS 12 v2 update, adding support for 64 bit plugins used by CWP solutions. FMI also released a new software developer’s kit (SDK) for plug-in developers. Until this SDK, there was no way for plug-in devs to update their plug-ins to run in 64 bit mode. So some F

David Jondreau

David Jondreau

 

FileMaker Server 12 Plugins

tl;dr: Plug-in developers can now update their plug-ins to run in 64 bit mode. There’s an undocumented change to how the Web Publishing Engine runs that affects where to install plug-ins to be run by CWP. A few weeks ago FMI released the FMS 12 v2 update, adding support for 64 bit plugins used by CWP solutions. FMI also released a new software developer’s kit (SDK) for plug-in developers. Until this SDK, there was no way for plug-in devs to update their plug-ins to run in 64 bit mode. So some

David Jondreau

David Jondreau

 

Then again, no.

Awww, scratch that last post, as yet another thing has gone wrong with this horrific ‘easy’billing database. Now the invoice numbers aren’t updating – we had this problem before but the solution was ?? – it just fixed itself magically, as far was we could tell. I strongly dislike old databases. My advice to all: [...] Source

David Jondreau

David Jondreau

 

Pre-fill new fields with related data, quickly

Sometimes you need to add a field to an existing database that should have values for all the already existing records in the table. Say you’ve added a new field on an existing database. It’s not a calc field, but will have an auto-entered calculation field that will always be filled out. For example, in [...] Source

David Jondreau

David Jondreau

 

Make a new plan, Stan.

or even use an old one… just HAVE a plan, and STICK to it. A few thoughts for the next time we make a brand new database: We should set some strict naming and formatting conventions so that all the names used for tables, field, layouts and scripts use the same rules, allowing us to [...] Source

David Jondreau

David Jondreau

 

Learning

It’s funny how things I’ve studied thoroughly do not necessarily register themselves in my brain as useful knowledge until I’ve made use of them. In working with Filemaker, and learning it in a somewhat haphazard way, it’s cool to observe how I learn. First off, I started by reading many books and stuff on Filemaker [...] Source

David Jondreau

David Jondreau

 

Migrating Word Press

We’ve got a few websites based on WordPress. They’re little sites and have been hosted with GoDaddy since launch. GoDaddy is cheap, cheap, cheap, and good enough for the sites we’ve had up. But we want to drive more traffic to those sites, take hosting control of a couple other more complicated sites, and get [...] Source

David Jondreau

David Jondreau

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.