JSONQuery @ FM-DiSC On Friday, January 14, Steve Senft-Herrera and I will be discussing and demoing JSONQuery at FM-DiSC (FileMaker Developers in Southern California). Useful Links Current version of JSONQuery: CF_JSONQuery_20211130_0120_PUBLIC.fmp12.zip Our recent two part in-depth interview series JSONQuery, part 1 JSONQuery, part 2 Coming soon: Steve Senft-Herrera’s demo file from the presentation Coming soon:… Continue reading JSONQuery at FM-DiSCAfficher la totalité du billet
Within the realm of FileMaker development, there are a number of key techniques which allow you to do the types of things you'd normally expect in any development environment. Many of these have been around for many years. In this case, this one, a decade. The unfortunate thing is that some of these obscure methods and techniques just aren't that easy to replicate from memory. Some are hidden in the corners of FileMaker development because they feel like they're "hacks". But, at least they get t
When Add-ons were announced, it sounded like they were going to be the holy grail of transportable code within FileMaker. Thus far, I don't know exactly what the adoption rate is and if the effort is paying off for Claris. I think the concept still has legs; as you can see that the new experience Claris is putting into FileMaker currently leverages what was built.
While I have my own personal strong opinions about how Add-ons were implemented and are currently used, there's no doubt you can sav
Category: ZshName: run PHP scriptDescription: Runs a PHP script using text from a FileMaker parameter. The -s option allows us to pass FMP parameters as a shell variable. Prototype: # Push the parameter to stdout, to be picked up as a script by PHP# Also see the Shell example for another way to do this, […]Afficher la totalité du billet
26 years in, a founding Bee reflects Julian Nadel is president and founder of Beezwax. He’s celebrating the 26th Anniversary of Beezwax with this update to his original Beezwax Blog post. In 2014, a colleague interviewed me about Beezwax; the interview transcript was the orginal basis for the article herein. It was then and still […]Afficher la totalité du billet
When first starting with FileMaker, I remember learning all the default Date/Time/Timestamp functions. The documentation for FileMaker is great and the example calculations often lead you in the right direction.
One of the things I didn't know about was how dates, times and timestamps were treated internally. More importantly, how this impacted what I wanted to do with date/time calculations and integrating with external systems. Later down the road, I learned about all the other things I neede
Have you ever wished you could connect a portal to a JSON array? Portals and JSON arrays seem like they should be a natural fit, but FileMaker doesn’t offer us an obvious way to connect one to the other. (An example of where this might come in handy would be selection criteria for a report,… Continue reading Connecting Portals to JSON ArraysAfficher la totalité du billet
Cadeau de Noël : un peu de couleur dans un logiciel de gestion ! 🌈
Pourquoi l'usage de couleurs variées et fraîches serait-il exclusif aux sites Internet ? Pourquoi ne pas en tirer profit pour des écrans de gestion, à qui l'on réserve bien souvent le privilège d'être "gris sur gris" ?
En illustration, voici un écran de contrôle de rentabilité revisité à la demande de mon client.
Il s'agit de comparer la rentabilité d'un projet lors de ses trois étapes :
- bureau d'étude,
Pour les besoins de différents clients nous avons développé une variante de la table externe native de FileMaker. L'idée était de combler certaines limites de la table externe classique. Par exemple, pouvoir ajuster le nombre de colonnes de manière dynamique, trier les lignes suivant certaines colonnes, déplacer les colonnes et surtout pouvoir scroller sur l'axe horizontal. Le tout avec de nombreuses options de mise en forme facilement règlables à l'aide de fonctions personnalisées. C'est ainsi
For many FileMaker systems, the number of concurrent logged in users, especially those who will hit issues with record locks, is often very low. Typically, these types of systems are used within the local area network and you just ask the offending user to unlock the record. However, with the number of remote users logging into a system through the WAN, a variety of things have had to change. The way you architect a database system can't necessarily take the same approach as was done before.
Beezwax Recognized for Advocacy Excellence, Sharing Expertise and Passion with Customers and Developers In the Claris Community CUPERTINO, Calif. – Dec. 15, 2021 – Claris International Inc., an Apple company, named Beezwax Datatools Inc. as winner of the Advocacy Excellence Award as part of the Claris Excellence Awards for 2021, which honor Claris Partners and […]Afficher la totalité du billet
Le prix Claris Excellence Award de l’Innovation est attribué à fmcloud.fm !
C’est un grand honneur et un grand plaisir pour nous d’annoncer que 1-more-thing s’est vu décerner aujourd’hui le prix le plus disputé par les membres de la communauté mondiale d’experts FileMaker : le Claris Excellence Award for Innovation.
En effet, notre service d’hébergement FileMaker révolutionnaire, fmcloud.fm et ses années lumière d’a
AND THE 2021 CLARIS EXCELLENCE AWARD FOR INNOVATION GOES TO… FMCLOUD.FM!
It is a great honor and pleasure for us to announce that 1-more-thing has been awarded today with the most sought-after prize: the Claris Excellence Award for Innovation.
Indeed, the jury has recognized our revolutionary FileMaker hosting service, fmcloud.fm and the fact that it is light years of advance on traditional services.
For two years, fmcloud.fm has revolutionized practices b
Chaque mois, nos abonnés se retrouvent le dernier vendredi du mois pour assister à un atelier technique. Cet atelier est ensuite disponible (après montage) en différé pour le voir ou le revoir et s’approprier ainsi la thématique proposée. Exceptionnellement, en décembre 2021, cet atelier va se tenir un jeudi et ce sera le jeudi 30 […]Afficher la totalité du billet
‘Tis the Season….to have fun! All the heavy lifting has been done on this one, all you have to do is use the app to create a fun family activity - no development skills (or purchase) required! This Scavenger Hunt is appropriate for all ages, so the Clues [...]
The post Find My Present – Holiday Scavenger Hunt appeared first on The Scarpetta Group, Inc..
Afficher la totalité du billet
One of the most satisfying things about being a solution developer is the opportunity to create the user interface. You get to create, and modify, how users interact with your software creation. It's like shopping for just the right outfit for that perfect occasion. The one which will present your software in just the right light and with the right amount of pizazz.
Of course, you have to be willing to update and change your style over time. Nothing stays popular forever - right? So, you consta
Continuation of interview with Steve Senft-Herrera [Editor’s note: the demo file and custom function have been significantly updated since part 1.] Demo file: CF_JSONQuery_20211130_0120_PUBLIC.fmp12.zip (WeTransfer link) KF: Welcome back Steve for part 2 of our JSONQuery conversation. SSH: Thank you, Kevin. KF: One thing we didn’t mention last time, because they were late-breaking additions, were the… Continue reading JSONQuery, part 2Afficher la totalité du billet
When first using FileMaker's Filter Portal Records feature it's easy to get excited about how you can limit the set of records to exactly what the user needs to see. You start adding a single filter and the result feels like magic. A simple search filter using a global field will let you extra exactly the records you want. It's great!
However, when start adding more and more filters things start to get complicated really fast. You have to become super comfortable with creating complex calculati
Are you looking for a way to manage your business that will free you from staring at spreadsheets all day? A solution that will help you better see what is happening with your business and help you figure out where you need to spend your time each day? Then l have a solution for you: [...]
The post Drop the Spreadsheets: Find Freedom and Increased Revenue appeared first on The Scarpetta Group, Inc..
Afficher la totalité du billet
This won't be a detailed post on every possible topic on object-oriented programming and testing, there are many books about that already. Instead, this will cover basics of testing, so you understand how and why we test, and you can adapt it to your own needs.Afficher la totalité du billet
Ce vendredi 26 novembre à 14h30, j'aurai le plaisir d'animer un atelier en ligne sur la technique dite Virtual List.
Notre consœur @MagalieJ, de Editomac, propose à ses abonnés un atelier pratique par mois, ateliers dont je suis un spectateur fidèle.
Pour la première fois ce vendredi, c'est moi qui animerai l'activité, pour vous faire découvrir une technique FileMaker assez pointue mais finalement accessible, qui permet de résoudre de nombreuses situations.
"Quand je ne sais pas c
Building a custom Tableau® Connector for Claris® FileMaker® enables faster, more reliable and more flexible connections between Tableau and FileMaker datasources, compared with the legacy Web Data Connector. For a number of Beezwax client projects, we’ve installed and deployed a Tableau Connector (aka “TACO”) for FileMaker. The TACO was built using the Tableau Connector SDK […]Afficher la totalité du billet
Let’s talk about Claris FileMaker and transactions! Join Vincenzo Menanno to discuss what transactions are, how they relate to FileMaker data operations (creating, updating, and deleting records), database normalization, and how to use transactional concepts to improve FileMaker performance, especially over a wide area network (WAN). This is a live, virtual event as part of […]Afficher la totalité du billet