Jump to content

Search the Community

Showing results for tags '[]'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Community
    • On se cause…
    • Annonces
    • Exercices et astuces
    • FM Conférence - archives
  • Creation
    • Tables et rubriques
    • Liens
    • Scripting
    • Calculs
    • Modèles & Interfaces
    • Listes de valeurs
    • Divers
  • Partage
    • Réseau
    • Publications web
    • Sécurité
    • Téléchargements
  • Integration
    • Modules & Plug-ins
    • JavaScript
    • Claris Connect
    • Intégration
    • SQL & FQL (FileMaker SQL)
  • Versions de FileMaker
    • FileMaker Pro
    • FileMaker Server
    • FileMaker Go
    • FileMaker Pro 7 à 18
    • FileMaker Pro 6 et versions antérieures
    • Archives de 1996-2004


  • FM Conférence 2017
    • Formation JSON, API et FileMaker Data API
    • Journée 1 - Jeudi 19 Oct.
    • Journée 2 - Vendredi 20 Oct.
  • FM Conférence 2016
  • Technique
  • Interface


  • La chronique de David Julot
  • Le Blog FileMaker
  • l'OpenData et les API
  • Soliant Blog
  • ISO FileMaker Magazine
  • DB Services
  • Beezwax
  • The Scarpetta Group
  • Designing FileMaker
  • ModularFilemaker
  • FileMaker Hacks
  • Lesterius FR
  • 1-more-blog
  • Astucieux-Filemaker
  • FileMaker Medium
  • MainSpring
  • Lesterius EN
  • ParJupiter
  • jp cherch doublons
  • Neo Code
  • fmcloud.fm

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Website URL









  1. 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
  2. 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 the job done. For FileMaker, the fact that you can derive a value list from a related set of values is extremely valuable. If you have a class of cars and you need a value list with a sublist of models, then getting a related value list is really easy and useful. But, what if you need a bit more control? You want to specify the exact values used. They need to be custom and you want to include calculated values which are dynamic in nature. You also want them in some type of fixed order and separated with dividers. Doing this is "almost" impossible unless you know the special "hacks" which allow you to achieve the desired result. This video and technique file will show you how to take full control of value lists and use Custom Dynamic Value Lists in the exact way you think you should be able to! Click the title or link to this article to view the video. Afficher la totalité du billet
  3. 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 save a lot of time by using certain add-ons within your solution. For myself, the question tends to center around build-it-yourself or leverage someone else's efforts. Fortunately, if you're comfortable with your own assessment skills regarding FileMaker development, you can determine if a given Add-on is worth using or not. In this week's video I take a look at installing and using an add-on download from the Claris marketplace. The experience is somewhat telling of what a new or even intermediate user might go through. It all comes down to implementation and the condition of the UI/UX. If you've not used a lot of add-ons or experienced how they might (or might not) be useful in your own development then give this video a once over. Click the title or link to this article to view the video. Afficher la totalité du billet
  4. 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
  5. 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
  6. 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 needed to know when considering time around the globe. Understanding UTC, how it impacts my solution, and running scripts on the server in a different time zone vs running them within the local client and how this might impact things based on times or dates. This week's video and technique file will provide you with all kinds of understanding. The fundamentals and powerful custom functions which should provide you with a ton of date/time confidence for handlings most any date/time based task within FileMaker. Click the title or link to this article to view the video. Afficher la totalité du billet
  7. 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
  8. 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. As a FileMaker developer, you should now consider the remote user and plan your system accordingly. Fortunately, this approach can be taken at any point in the life cycle of a FileMaker system. You can retrofit or plan from the outset to use a very creative way of avoiding record locks. Quite simply, you provide each user with their own personal file. If you're familiar with using External Data Sources within FileMaker, then this may be common ground for you. If not, then you'll find a ton of useful information within this video. If your users are accessing a system from across the globe, then using the know-how here will help alleviate a lot of connection stress and struggles because it's a method of data collection and transfer which directly emulates what users do when they interact with a standard web based application. Need the benefits of speed and performance? Look no further than Avoiding Record Locks. Click the title or link to this article to view the video. Afficher la totalité du billet
  9. 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’avance sur les services classiques ont été distingués par le jury. Depuis deux ans, fmcloud.fm révolutionne les usages en permettant aux entreprises de toutes tailles de bénéficier d’un véritable cloud pour déployer la plateforme low code FileMaker, et de gagner en performance, en sérénité et en coût Un VRAI cloud sur Linux/Docker Nous avons investi massivement pour permettre à FileMaker Server de tourner sur une architecture Linux/Docker, avec une « architecture as code » offrant une souplesse extraordinaire. Nous sommes capables de déployer ou mettre à jour, des milliers de serveurs à travers le monde en quelques secondes, et nos clients ont à disposition des monstres de puissance pour un prix souvent inférieur au simple coût de possession d’un serveur local. Mais nos efforts ne s’arrêtent pas là. C’est un bonheur de voir les optimisations apportées par Claris à chaque version, et elles nous permettent aussi d’optimiser à notre tour pour proposer des solutions toujours plus performantes et rentables. Nous tenons à remercier chaleureusement Claris pour cette récompense, mais aussi, bien sûr, les dizaines de consultants du monde entier qui font confiance à notre service d’hébergement FileMaker pour les applications de leurs clients et leur propre environnement de développement, et qui contribuent à la réputation de ce service de premier ordre. Un grand merci également à Nick Lightbody et Christian Schmitz (MonkeyBread Software, MBS) pour […] >>> Lire la suite… <<<
  10. 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
  11. 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
  12. ‘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
  13. 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 constantly need to be learning about ways you can make things look and feel differently within your software. In this video, I showcase a number of tips and tricks related to making your user interface just a little bit prettier. It's not a word you'll use that often, but, by taking the time to prettify your solution, you'll find it's a rewarding task. Learn from this video and the provided example file and make sure your solution's UI is as pretty as it can be. Prettify it! Click the title or link to this article to view the video. Afficher la totalité du billet
  14. 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
  15. 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 calculations with a lot of Boolean logic. If you don't know how to use your AND and OR operators, then it can really seem daunting. In this video we take a detailed look at how to break down a complex multi-filter approach and make it seem really easy to achieve some super advanced portal filtering. If you've ever been confused about making your portals show exactly what the user needs, especially when using multiple filtering vectors, then enjoy the understanding you'll receive from watching this video. Click the title or link to this article to view the video. Afficher la totalité du billet
  16. 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
  17. 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
  18. 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
  19. 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
  20. Who doesn't need to mark subsets of records? I've rarely, if ever, worked on a solution which couldn't take advantage of simple record marking. Whether it's for creating a user based subset or simply toggling an active or favorite value. Marking records is something which should just be standard. So, why not make it both standard and universal. Meaning, you use one single script regardless of whether you're dealing with a current found set of records or a filtered portal - and independent of a specific field. That's what this video and technique file are all about. Universally marking records within your solution. A small collection of scripts for targeting any given Boolean field and making it so simple and easy that you don't even need to think about it. You just call the one universal utility script and call it a day. Your records are marked - or unmarked. Looking for a smaller, and easier, FileMaker solution to manage? Then start using utility scripts and make this marking solution one of your go-to recipes. Click the title or link to this article to view the video. Afficher la totalité du billet
  21. For many FileMaker solutions it's fine to use the default standard FileMaker menus. There are only a few dangerous menu options which can cause serious problems. In fact, learning how FileMaker actually works, via its default menus, is a big benefit in a lot of situations. In some, however, it makes a lot of sense to simply take advantage of being able to implement and use our own menu systems. In this video we walk through how to get started with Custom Menus and how to take advantage of the features they provide. How to comfortably switch between default menus and one you may have customized. If you haven't considered using Custom Menus, then you may find some hidden gems which make their use more comfortable. And, if you have been using Custom Menus, then you may pick up some tips and tricks which makes them just a bit more useful. Custom menus are a great way to make your solution more usable. The key to using them successfully may just be to start from something which already exists rather than having to create something from scratch. That's what you'll find in the content for this week's video. Click the title or link to this article to view the video. Afficher la totalité du billet
  22. Interview with Steve Senft-Herrera [Editor’s note: the demo file has evolved a bit since this interview took place, and, as a consequence, screen shots shown here may deviate slightly from what you will find in the demo.] Demo file: CF_JSONQuery_20211029_1200_PUBLIC.fmp12.zip KF: Good afternoon, Steve. You’ve been developing JSONQuery over the last few years, and today… Continue reading JSONQuery, part 1Afficher la totalité du billet
  23. Nous sommes ravis d’annoncer que nous avons été présentés dans le magazine Best Startup EU comme l’une des meilleures entreprises d’intégration de données en Belgique. Grâce à notre expertise dans la conception d’applications Low-Code et l’intégration/orchestration, 1-more-thing a été sélectionnée en raison de ses performances exceptionnelles dans la catégorie Innovation, parmi les catégories suivantes : […] Cet article Best Startup EU nomme 1-more-thing parmi les meilleures startups d’intégration de données en Belgique. est apparu en premier sur 1-more-thing. >>> Lire la suite… <<<
  24. For anything that could possibly go wrong within FileMaker we have a list of Error Codes. They're easily referenced from within FileMaker's help documentation. While they won't give you the exact solution to any particular error that's happening, they do provide the starting point for where to look and troubleshoot. In this video, we take a look at how to simply use and reference the provided FileMaker error codes. We also look at how you can intentionally cause an error in order to take control of certain feature of FileMaker. If having a better understanding of working with errors within your software sounds like a good idea (and it is) then you'll have the info you need to get started. Click the title or link to this article to view the video. Afficher la totalité du billet
  25. One of the more troublesome questions we ask ourselves as developers is "Am I doing this the right way?". And, while it applies to most all situations, it most certainly applies to data structure. If you don't structure your data well enough, then you either have to restructure it later, and migrate, or try to solve some of your problems in very odd ways. Fortunately, the variety of ways you can actually store data presents a lot of options depending on what type of software you need to create. The key is knowing these different ways and choosing one which sets your solution up for success. All software, over time, becomes outdated. It's like thinking things are all good living in a house built in the early 1900's when everything around you has gained significant improvements. The same applies to software. There are newer and newer ways of doing things. In this video, we take a look at three primary ways of breaking down structured data. We classify the student/teacher subtype as it applies to a person. If choosing how to store your data has always been a tricky question for you then you should find some peace of mind with this particular video. Click the title or link to this article to view the video. Afficher la totalité du billet
  • Create New...