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
    • 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

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Website URL








  1. 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 Afficher la totalité du billet
  2. Who doesn't want to know how long something takes? It's not like we, as the busy bees we are, have all the time in the world - right? Well, how about some convenient progress information. One of the most common procedures within all of computing is to cycle or iterate over a set of something. In FileMaker, this comes in the form of records. A record loop is one of the most common things you'll ever do within FileMaker. Setting a field value to something else across a range of records? You'll likely use a record loop. So, what's the easiest way show the progress of that record loop? It's curr
  3. Every trade has its own tips for making your work go faster or happen more easily. During this holiday season I thought it would be great to bring you 12 Tips of Developing in FileMaker Pro. So, I opened FileMaker and stared at the blank screen of a new file thinking about the things that tend to help me out the most. I pulled down a CSV file from Data.gov and just let the tips flow out from there. I hope, with this list of 12 tips, you'll pick up some productivity enhancements that will carry you forward into the new year! Happy Holidays! Click the title or link to this article to view the
  4. FileMaker Pro provides a variety of methods for extracting your data from its database. From memory, we have standard relationships and calculated concatenations, the Copy All Records script step, scripted data loops and using the ExecuteSQL function. In FileMaker 19, we're provided with yet one more method for pulling data out of the system. The Execute FileMaker Data API script step allows us to use what was formerly available only from outside of FileMaker Pro via a url. Now, within our scripts, we can use this fast retrieval method for extracting data in the popular and common JSON format
  5. There's a great feeling about writing functional code when it's something you can rely on. You know it's just going to work. Which, for some import routines, doesn't always feel this way. Sometimes the import may fail or you can't figure out how to make it work. Columns may get renamed, they may be shifted around and vary or you may be importing from multiple different providers. If you're consolidating data from multiple sources or you have a situation where you need to manipulate the data before the import, then we've got a great solution for you. Not only is this video about server side i
  6. 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 Afficher la totalité du billet
  7. With a handful of simple scripts and just a few fields, you can easily accomplish some powerful image organization both inside and outside of FileMaker. In this video, we take a look at how FileMaker can be used to organize a collection of images. This is prior to sending them out or making them available for a web server to host them. If your FileMaker solution needs to work with images used for verification or any form of media communication, then learning how you can make FileMaker bend to your media will can have a number of big benefits. Need to know how to manage the whole process and
  8. Using JSON for passing multiple parameters can be a real life saver. Because JSON keeps all individual parameters separate from each other, you can pass pretty much any type of data except for container data - although you can pass a reference to a container easily enough. Your parameters can also have as many levels as necessary and the JSON can easily be modified as it moves from script to script. When writing a complex and large collection of scripts, you eventually hit errors and issues. You end up spending extra time hunting down problems and eventually you find out it's a simple issue w
  9. Business Trends 2021 Wow, 2020, just wow! So many changes in the world and very obvious changes to the way in which businesses operate. How long will these changes last? Has the way in which we work changed forever? With so much uncertainty, it’s comforting to know that predictable emerging trends will see us [...] The post Business Trends for 2021 appeared first on The Scarpetta Group, Inc.. Afficher la totalité du billet
  10. It’s hard for those of us who aren’t in the know, to buy for those who are… so with Christmas 2020 just around the corner, we’ve compiled our top 8 favorite Christmas gifts for the tech geek in your life. Starting off with something super relevant, it’s the UVC Sterilizer Box with Wireless Charger. [...] The post Christmas Gifts for Tech Geeks appeared first on The Scarpetta Group, Inc.. Afficher la totalité du billet
  11. This versatile function offers quite a bit of value to any developer’s toolkit. It gives us the ability to interrogate the state of different layout objects (also called introspection) which allows us to make our calculations and scripts smarter. Today we’re going to just focus on a one of the options, the attributeName parameter to take a look at some interesting behavior that could be leveraged as another tool in our developer toolbelt. Parameters objectName – in order to use this function, the object to be interrogated must have a name set in the position tab of the inspector. I
  12. FileMaker natively provides us with some really nice tools for user feedback. We can use the Show Custom Dialog or even create a dedicated dialog using a Card Window and Layout. There are, however, times when you need something a little more subtle. Just a simple message on screen will often suffice. The next question is whether you need the user to interact with that message or not. The solution is simply to provide both options of course. In this video and technique file, we explore a super simple method for providing user feedback via a simple message which is shown using a dedicated Butt
  13. During agile development in FileMaker, sometimes you may notice an unwanted performance difference after adding a new feature, or display a new field to a layout. In this blog, I’d like to address what I have found to be the most likely culprits of the slow and unwanted Find or Sort dialogs on FileMaker layouts: summary fields and “unstored calculations”. Inside the storage options of the calculation field definition is where developers decide if a calculation is stored or unstored. A checked box here (unstored), means exactly what it says: the data will not be stored and must r
  14. 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 Afficher la totalité du billet
  15. The wonderful thing about creating software is it feels like you're able to create your own universe. You're the master of that universe and how it functions and reacts to its users. It's a very empowering feeling to know you can direct and control data in a way that makes it useful to others. When considering all the directions that software can take there's always that simple fact that different people like different things. Heck, someone buys the Rhubarb from the grocery store - because they keep stocking it - right? So, what is the best way to offer user specific preferences to your solu
  16. If there’s one thing that can stop a sale dead in its tracks, it’s an objection. There are always going to be reasons your potential customers hold back from purchasing from you, and you can be one step ahead if you figure out these possible objections beforehand and address them in your website FAQs. [...] The post What are your customers’ pain points? appeared first on The Scarpetta Group, Inc.. Afficher la totalité du billet
  17. All businesses have a target audience they want to reach, that much is obvious, but why it’s so important as well as how to define your target consumer, may be less so. Whether you’re offering a product or service, as a business owner, you’re going to want to make the most out of your [...] The post Know your audience appeared first on The Scarpetta Group, Inc.. Afficher la totalité du billet
  18. A common feature I like to provide on my FileMaker list view layouts is clickable headers that sort records based on that column. Realistically, you don’t always have the luxury of being in a simple 1 table list view. In this blog, I will walk through a consistent way to dynamically sort related data in portals, using the column headers. I would like to preface this blog by saying this is not a concept I invented. It was taught the concept from a coworker – who learned it from a blog or forum. I still believe I have broken the concept down to its simplest form and can explain the parts
  19. Overview of when it would be beneficial to use abstraction in FileMaker Sometimes you can benefit from a method called abstraction where you use what’s called “indirection.” Indirection is a way that you can automatically iterate through a series of steps like set variable or set field. For instance, let’s say you needed to bring the contents of one set of fields in a table and create new related records in another, a process very common when dealing with legacy app data after importing it into a new app. Here there may be quite a few fields. In this particular instance ther
  20. Portals are wonderful tools for showing related data relevant to what your solution is solving. Sometimes, however, there's a trick to getting them to show exactly what you want. The combination of functions required may not always be obvious and it can be hard to achieve the desired result. Essentially, you have to know how to extract the specific key values which allow you to filter only the desired rows. In this video, I walk through all the specifics of creating a custom function which allows you to filter unique keys such that only the desired records will be shown. If you've ever had t
  21. There's this special feeling you get when developing software where you feel like you've created something magical. Sometimes, it doesn't even matter if you've done the same type of thing before. It just feels like you're the master of the universe and you've created something super useful. This may even be the case when you're simply creating a virtual trash can and providing users with the ability to reverse course on that accidental record deletion. In this video, we're taking a look at a super simple trash can metaphor. It's easy-to-implement and allows users to bring records back from t
  22. The decorator pattern is one of my favorite patterns. It is simple, extensible and powerful. It feels like it follows the essence of object oriented programming beautifully. Sadly though, it is also easy to be misused or misunderstood. So, in this post I will show you the essence of the decorator pattern, illustrated with a […] Afficher la totalité du billet
  23. Do you need to work with online APIs and find yourself wishing there was an easy way to accomplish it? Well, there actually is. In fact, in much of technology, there's something or someone somewhere which has likely already solved the problem. In the case of using REST (Representational state transfer) to interact with service APIs within FileMaker, it's nice to have a single tool which will handle most of the heavy work for you. When native JSON was added to FileMaker, the last piece to the puzzle was a more expanded method of interacting with the network. The cURL library was already being
  24. Il faut s’y habituer, avec les nouveaux cycles courts des sorties de FileMaker, les nouveautés importantes ne sont plus forcément à date fixe avec un nouveau numéro de version. Il ne suffit donc plus, pour qui s’intéresse à la plateforme FileMaker, de réserver un peu de temps au mois de mai pour s’enquérir des nouveautés […] Cet article FileMaker Server sur Linux : la révolution fmcloud.fm 2.0 est apparu en premier sur 1-more-thing. >>> Lire la suite… <<<
  25. 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 Afficher la totalité du billet
  • Create New...