Jump to content

Blogs

bBox for FileMaker v0.98 with M1, GraphicsMagick & Sips

We are pleased to release bBox version 0.98, with with new image file functions and M1/Apple Silicon support. bBox is a free utility plug-in to extend FileMaker solutions to easily use code libraries and macOS-based functions from Python, JavaScript, PHP, Ruby, AppleScript, C/C++, Bash/sh, XPath, and SQLite. Also included is a demo file that has […]Afficher la totalité du billet

vincenzo

vincenzo

DataTables Deep Dive - Replacing Portals - Part 2

This is Part 2 of a series about using the DataTables JavaScript library in order to simply pull data you wish to display and doing so within a Web Viewer. While standard FileMaker Portals present one of the easiest methods for showing related data, it's now a viable option to simply use a Web Viewer to present data to the user. With the bi-directional support of JavaScript within FileMaker 19 and higher we can take advantage of what JavaScript does best - being fast! In this video we focus sp

FileMaker Magazine

FileMaker Magazine

DataTables Deep Dive - Replacing Portals - Part 1

Portals and list views represent one of the biggest reasons for using a database for managing data. You can view the data in a myriad of ways and FileMaker provides the tools to modify the views quite easily. FileMaker's list view happens to be the most powerful when compared to portals. We don't really have the same feature set presented within a portal. Using a portal it's an all or nothing approach to sorting by default and you can't really search the portal contents. You can certainly hack

FileMaker Magazine

FileMaker Magazine

PSOS – Run Script in File not open Locally

Update: See Jason Wood’s suggestion in the comments section for making this technique more secure. 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… Continue reading PSOS – Run Script in File not open LocallyAfficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

FMPlanner : Un add-on de planification basé sur FullCalendar V5

Nous sommes fiers de vous annoncer la sortie de FMPlanner, notre add-on de gestion de ressources et d'évènements. Cet add-on utilise les dernières fonctionnalités de FileMaker Pro 19 ainsi que la célèbre bibliothèque Javascript FullCalendar 5. Pleinement fonctionnelle sur macOS et Windows, FMPlanner vous permet d'intégrer un calendrier de planification à vos solutions en quelques clics...   Nul besoin d'en dire plus, venez l'essayer, nous mettons à votre disposition une version d

Julien Rouard

Julien Rouard in IU-DATA

Formatting Date, Time & Timestamp Values

What's the easiest way to format a FileMaker date, time or timestamp value? Using a custom function? Maybe... In this video, I'll show you a unique trick for getting a formatted date, time or timestamp value without using a Custom Function or any of FileMaker's Date or Time functions. Of course, I'll also provide you with one of the better custom functions for formatting date/time/timestamp values. The custom function in this technique file handles pretty much all possible variations of date/t

FileMaker Magazine

FileMaker Magazine

UI Portal Enhancements

Anyone can just throw everything they need within a portal. Adding a new field? Just throw it in the portal. But WAIT! The question is "Should you?". The fine art of determining what should end up in your portal is based on how the data and/or actions are being referenced/used. Is the frequency for editing the data high or low? If it's low, then maybe the user doesn't need field access. What is the frequency of record deletion? Low? Then, do you really need that obvious red trash can icon on ev

FileMaker Magazine

FileMaker Magazine

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 + JSONataAfficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Sortie de FileMaker 19.3

Claris l’avait annoncé : finies les traditionnelles grandes sorties du moi de mai. Le cycle « Agile » consiste en des mises à jour plus fréquentes, avec une répartition des nouveautés tout au long de l’année. Cette semaine, c’est la version 19.3 qui a été annoncée, et c’est une version importante même si surtout « technique ». Petit résumé […] Cet article Sortie de FileMaker 19.3 est apparu en premier sur 1-more-thing. >>> Lire la suite… <<<

fabriceN

fabriceN

InspectorPro 7.2 for FileMaker – Faster on M1!

Using FileMaker on an M1 Mac, it's so responsive and such a delight to use. InspectorPro 7.2 is optimized for FileMaker 19.3, which gains a huge speed boost by virtue of running natively on Apple silicon M1-based Macs.Afficher la totalité du billet

vincenzo

vincenzo

Mutually Exclusive Values

Value lists are one of the fundamental building blocks of any good UI built on top of a database system. Providing users with a preselected list of options to choose from helps the data entry process go faster and - is - just easier. When using value lists, there are times when you need to limit the number of selections of any given value to being used just once. You may also need to enforce that one of each of all possible values is used. In this video, we tackle both situations by enforcing

FileMaker Magazine

FileMaker Magazine

fmcloud.fm available in Switzerland

fmcloud.fm, the only FileMaker hosting service running on Linux/Docker, is now available in Switzerland too, as well as USA, Canada, UK, France, Germany, Singapore and Australia. The post fmcloud.fm available in Switzerland appeared first on fmcloud.fm. Afficher la totalité du billet

fabriceN

fabriceN

Big 3 Local Development Options

Being able to develop locally, as if the data and the server was right there on your local machine provides a nice advantage. You know how the solution will work when hosted, you can develop and test PSOS scripts effectively, and you're generally protected from client crashes. Plus, you're fully mobile if need be - it's all on one machine. This is where hosting your FileMaker solutions locally becomes a big advantage. This video showcases what I consider to be the Big 3 of local hosting. 1) You

FileMaker Magazine

FileMaker Magazine

Extracting System Paths - Media Archiving

In the process of creating a simple media archiving database I found I had used the same skill twice because of how FileMaker returns data from certain functions. Hence, I decided to provide you with my simple little start to a Media Archiving solution. Simply, it asks for a folder, then pulls the paths to all files from the selected, and enclosed, folders into the database. It's really a pretty simple thing because it's managed with one simple function from the BaseElements plug-in. However,

FileMaker Magazine

FileMaker Magazine

Universal List View Sorting

What makes FileMaker development so fun is the variety of different functions and script steps. They provide an almost infinite number of combinations to solve a wide variety of technical problems. There isn't always just "one way to do it". So, what happens when you stop to think about a more recent feature in light of how you've "always done it before"? Like... sorting... for example. Have you always simply attached the Sort script step to your list view headers and called it a day? What if y

FileMaker Magazine

FileMaker Magazine

Narrow vs. Wide Tables - Part 2

Continuing on with the two part series about Narrow vs. Wide tables, this video will go into how to best filter your data, especially if you have a large amount. It will present the data within the structure we'd created within the first video. Knowing the impact of data operations isn't just limited to the structure of your tables. It's also about how much data is loaded and shown to the user based on what the user needs to see. If you have a relationship resulting in hundreds of thousands of

FileMaker Magazine

FileMaker Magazine

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 Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Narrow vs. Wide Tables

Like any good craftsperson, you should know your tools and your methods for accomplishing things in the most efficient and best performing way. This is always most obvious when it comes to that every slowing FileMaker solution which started out innocently as a simple "helper" database. Then... it ended up being used for all kinds of things. Critical things even! It was thrown together based on how you mentally "see" the data and not how the data should have been structured. This is one of those

Diamant de Lucie n°1 : DataTables dans FileMaker

Nous avons le plaisir de vous présenter le premier bijou technique de @Lucie Guilbert, en tant que développeuse Web et FileMaker chez ParJupiter. Les bijoux techniques de Lucie seront naturellement appelés les «Diamants de Lucie» !   💎 🎵 Et il y en aura d'autres… Ce tout premier diamant vient combler un manque historique de #FileMaker : il apporte la possibilité de consulter les données dans un tableau facile à trier, à filtrer, bien présentable, avec une pagination et un compteur

Jérémie Gimenez

Jérémie Gimenez in Diamant

×
×
  • Create New...