Jump to content
  • entries
    287
  • comment
    1
  • views
    55,933

Entries in this blog

PSOS – Run Script in File not open Locally

INTRODUCTION Today I want to take a look at a certain Perform Script On Server (PSOS) behavior, and for those who find this behavior to be inconvenient, propose a work around. Here’s the behavior, or misconception, actually: a server side script initiated via PSOS (apparently) cannot access files on the server unless the user already… Continue reading PSOS – Run Script in File not open LocallyView the full article

FileMaker 19 + JSONata

Introduction Recently I had the pleasure of speaking with Jeremy Brown on The Context Podcast about an open-source project called JSONata that enables you to query and transform JSON. The JSONata site is packed with useful information, including this short video… …as well as… Extensive documentation A link to the Stack Overflow forum, where you… Continue reading FileMaker 19 + JSONataView the full article

Bypassing Scientific Notation

Earlier today I needed 1 billion to render in the calc engine as 1000000000, but FM helpfully converts numbers to scientific notation if they A) are >= 1 billion, and B) contain nothing but zeros following the initial digits. Example where “A” and “B” are both true: Example where “A” is true but “B” is… Continue reading Bypassing Scientific Notation View the full article

FRAP-Map: A Flexible, Robust, Accessible and Portable Data Mapping Technique

Editor’s note: today we have a guest article by long-time FileMaker developer, Peter Doern, who has come up with an elegant, outside-the-box methodology for managing imports. This is one of the coolest techniques I’ve seen in a long time. Enjoy. FileMaker includes a powerful and fast method for importing data from a source table to… Continue reading FRAP-Map: A Flexible, Robust, Accessible and Portable Data Mapping Technique View the full article

When 2 is greater than 10

Today we’re going to take a quick look at a potential “gotcha” that can crop up when doing numeric comparisons. Jason DeLooze and I discussed the general behavior back in 2011 (Space Is The Place), but this time around I want to focus on one particular set of circumstances where the problem can arise. At… Continue reading When 2 is greater than 10 View the full article

Kevin Frank

Kevin Frank

Fun with SQL Joins and Currency Formatting

Demo file: sql-join-fun-etc.zip requires FM 18 or later. Recently I was asked to create a mini-report combining data from a pair of related tables via ExecuteSQL. This provided an opportunity to think about SQL joins, and also to come up with a way to apply currency formatting to dollar amounts in the SQL query result,… Continue reading Fun with SQL Joins and Currency Formatting View the full article

Kevin Frank

Kevin Frank

File IDs, Table IDs and Field-Level Schema

Demo file:  file ids, table ids and field-level schema.zip (requires FM 18 or later) INTRODUCTION Recently I was asked to help document a FileMaker solution by creating and populating a “schema” table as per the above screen shot. One of the requirements was to programmatically determine internal ID numbers for the file and for the… Continue reading File IDs, Table IDs and Field-Level Schema View the full article

Kevin Frank

Kevin Frank

Set Variable By Name Revisited

Demo file: set-variable-by-name-v2.zip (requires FM 16 or later) INTRODUCTION You’ve probably heard the old joke that goes… Patient: Doc, it hurts when I do this. Doctor: Don’t do that. Perhaps you’re also familiar with the FileMaker equivalent? Developer: It hurts when I try to assign certain variable names. FileMaker: Don’t do that. Or how about… Continue reading Set Variable By Name Revisited View the full article

Kevin Frank

Kevin Frank

A Value List Experiment

Demo file: a-value-list-experiment.zip Note 1: today’s demo is recycled from the one that accompanied Virtual Portal, part 2. All we care about today is how we assign the parent company; the remainder can be ignored. Note 2: if you’re unclear on value list basics, check out Thinking About Value Lists, part 1. “I want it… Continue reading A Value List Experiment View the full article

Kevin Frank

Kevin Frank

A Simpler Backup Script

Demo file: backup-simplified.zip Like many developers I go back and forth between developing locally and in a hosted environment, and many years ago, I posted a couple articles featuring a simple backup script to create on-the-fly backups when working on local files. Recently a colleague pointed out that this backup routine, which I last wrote… Continue reading A Simpler Backup Script View the full article

Kevin Frank

Kevin Frank

Render Found Set as JSON Object

Demo file: found-set-to-json-object.zip (40MB; requires FM 18 or later) [Author’s note: the demo file is a work in progress. Modify it as you see fit.] Today we’re going to compare various methods one might consider employing to render an arbitrary found set as a JSON object. The demo consists of a table of US customers… Continue reading Render Found Set as JSON Object View the full article

Kevin Frank

Kevin Frank

JSON Currency Exchange Rates

Currency Exchange Rates Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency conversion service. Demo file: json-exchange-rates.zip I threw together this… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

JSON Currency Exchange Rates

Currency Exchange Rates Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

JSON Currency Exchange Rates

Currency Exchange Rates Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

JSON Currency Exchange Rates

Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together this FileMaker front… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

JSON Currency Exchange Rates

Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together this FileMaker front… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

JSON Currency Exchange Rates

Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together this FileMaker front… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

JSON Currency Exchange Rates

Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together this FileMaker front… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

JSON Currency Exchange Rates

Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together this FileMaker front… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

JSON Currency Exchange Rates

Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together this FileMaker front… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

JSON Currency Exchange Rates

Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together this FileMaker front… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

JSON Currency Exchange Rates

Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together this FileMaker front… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

JSON Currency Exchange Rates

Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together this FileMaker front… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

JSON Currency Exchange Rates

Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together this FileMaker front… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

JSON Currency Exchange Rates

Welcome back for another exciting round of JSON exploration. Last time we discussed a JSON-related bug fix in FM 19, as well as a free package tracking service that returns results in JSON format. Today we’re going to look at a free currency exchange rate service. Demo file: json-exchange-rates.zip I threw together this FileMaker front… Continue reading JSON Currency Exchange Rates View the full article

Kevin Frank

Kevin Frank

×
×
  • Create New...

Important Information

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