Aller au contenu

FileMaker Magazine

Membres
  • Compteur de contenus

    198
  • Inscription

  • Dernière visite

    jamais

1 abonné

À propos de FileMaker Magazine

  • Rang
    100

Profil général

  • Genre
    Non précisé

Profil FileMaker

  • Certification
    FileMaker 15 Certified Developer

Visiteurs récents du profil

Le bloc de visiteurs récents est désactivé et il n’est pas visible pour les autres utilisateurs.

  1. FileMaker Magazine

    Accessing Google Services - Part 3

    Having made the connection to Google's Services using Oauth 2, and spending a touch of time investigating how we can discover documents within Google Drive, we're in the home stretch of reading and writing data to a Google Sheet. By simplifying the way we make API calls to any of Google's services, we end up with a great solution for working with any of Google's available APIs. Also, by focusing on the simple example of working with one simple Google Sheet, we end up capturing data via a Google Form which dumps data into the Google Sheet. All we need to do is read and write to that sheet. This video covers the topic of watching for an expired access token and making sure that each call to the API has the greatest chance of success. Within no time you'll be reading and writing to a Google Sheet as if everything was right there within FileMaker Pro itself! Click the title or link to this article to view the video. Afficher la totalité du billet
  2. FileMaker Magazine

    Accessing Google Services - Part 2

    This video is a continuation of the first video in this series where we took a look at connecting to Google's myriad of available services. Once you know how to make the secure connection which Google requires, you can access all the possible services. The trick with working with web services, such as Google or AWS, is that you need to become familiar with how FileMaker requests data and then process the response. We tackle that task within this video then move on to working with Google Drive in order to determine which file it is we want to work with. After making a successful connection we also need to know how to maintain or re-establish that connection. Google doesn't keep the door open forever you know. So, settle in for another longer, but valuable exploration of connecting to Google's services. Click the title or link to this article to view the video. Afficher la totalité du billet
  3. FileMaker Magazine

    Accessing Google Services - Part 1

    Buried within the layers of complexity inside any technical system are the simple settings of multiple parameters and/or settings. You simply need to get the right pieces into the right places. You know - like a jigsaw puzzle. And, once the puzzle starts to reveal itself, the understanding of what the picture is becomes so much more clear. That's the goal of this particular video when it comes to connecting to the myriad of possible Google services. FileMaker Pro, in the last few years, had improved by leaps and bounds with regards to working with external systems and services. With everything you need now built in the the native client, you can easily connect to Google's services and make the most of them right within your own FileMaker solution. You may just need a head start on the understanding in order to see the whole picture. Fortunate, that's exactly what this video will do for you. If you need to connect to Google services for any reason then look no further! Click the title or link to this article to view the video. Afficher la totalité du billet
  4. FileMaker Magazine

    Universal Date Picker

    FileMaker Pro provides us with a wonderfully blank canvas in order to present data however we wish. It's called Layout Mode. When you combine that feature with the recently added Card Windows the power to solve presentation problems goes up quite significantly. Such is the case when it comes to providing users with a date picker, or a calendar widget if you will. In previous videos, I've provided instruction on how to make a very simple calendar widget. When you combine that widget with a Card Window you simply gain full control about how a user makes selections for date values. So, what's the best method of implementation? Well, like all things, there are many ways to approach the problem. In this video I discuss the use of global variables and the differences in context when working with Card Windows. I present some of the better ways to approach the solution and how to clean up after yourself when considering the use of global variables. If you're in need of expanding your FileMaker knowledge and you happen to also need a simple, yet powerful date picker, then I'm sure you'll enjoy watching this video about a Universal Date Picker. Click the title or link to this article to view the video. Afficher la totalité du billet
  5. FileMaker Magazine

    Using FileMaker's Grid

    Recently, while providing intermediate training at the annual FileMaker Devcon, I had an attendee approach me and ask a very simple question. "How do you turn off the grid in FileMaker?" Like all questions, it was asked within the context of innocent ignorance. This was simply because this person had not yet used, nor explored this area of FileMaker. This is totally understandable with the increasing number of options found across the increasing number of palettes within FileMaker. However, if you think this video is simply about how you turn on/off the grid, then you'll be missing out on a whole host of features and options which can both benefit your layout designs and make things much faster for you within the area of your designs. This video is about taking full advantage of the grid and making decisions about how to use it and how to choose the right width for your designs. Plus, you'll get all kinds of tips about how to make your layouts feel "visually comfortable" so they appeal to users. Think you know about using FileMaker's Grids? Double-check by watching this video! Click the title or link to this article to view the video. Afficher la totalité du billet
  6. FileMaker Magazine

    Duplicating Related Records - Server Side

    The age old question commonly arises on FileMaker forums around the world. "How can I duplicate the whole record?" In other words, how can I duplicate the parent record and all related children records which make it seem like it's one whole entity. Well, at least, that's how a newer user/developer sees it. They may visually see the one record with all of its related records presented within the portal, but making the distinction that you're actually looking at 1 record plus N related records isn't super obvious from a UI standpoint. However, as a FileMaker developer, you need to know how to duplicate the whole collection of records so the user can conveniently click that one single button which reads "Duplicate". There are many methods you can use to accomplish this task, but there are a few tricks to making to work successfully and reliably depending on your specific requirements. In this video I present one of the most efficient methods for duplicating whole related record sets. No matter how many sets of related records you have, you can always take advantage of the inside knowledge on how to accomplish this type of task in FileMaker Pro. Click the title or link to this article to view the video. Afficher la totalité du billet
  7. FileMaker Magazine

    Reusable Dialogs

    Card windows will continue to impact our FileMaker solutions for years to come. Released in FileMaker 16, who would have thought that simply creating a new way to draw windows would be so empowering. We've long been able to create modal windows which force user interaction - but taking off the title bar and dimming the background window was all it took to make things much more powerful. So, what is the most common thing you can do with a card window? Well, create a reusable dialog box of course. In previous videos I've covered card windows for progress bars, menu navigation systems and ultimate card window positioning. In this video, I show you how to take advantage of the new FileMaker 17 feature of being able to target a script based on the name of the script. By doing this, we can create a reusable dialog box system which provides us with full visual control and styling of the content. If you're interested in taking full advantage of the latest features and you'd like to standardize your own custom dialog boxes then this video will have the information you need. Click the title or link to this article to view the video. Afficher la totalité du billet
  8. FileMaker Magazine

    List Processing with Custom List

    While FileMaker's calculation engine is super powerful for managing all kinds of unique calculations, the one thing it lacks is a feature for running a repetitive function across a range of data. This is certainly possible within the Scripting engine with the use of the ever wonderful Loop script step. However, as stated, there's no way to really process a range of data using just a function. Unless... you create your own or use one which has already been created. As it happens, there is just such a function which has long been one of the most powerful custom functions of all possible FileMaker custom functions. It was created over a decade ago and is still, too this day, one of the most powerful custom functions you could ever learn to use. The function is called CustomList and it's a must-know function for any FileMaker developer. Click the title or link to this article to view the video. Afficher la totalité du billet
  9. FileMaker Magazine

    Oauth External Authentication

    Using multiple files for developing a robust FileMaker solution can be pretty normal when you plan out the distribution of your data and servers. Some solutions benefit from breaking out part of the solution into one or more separate files. So, whether taking the load off a given server or simply planning for quicker data access across multiple time zones, one of the bigger problems which pops up with your standard FileMaker accounts is password management. This is where it becomes much easier to use external authentication. In earlier days, we only had access to Active/Open Directory or system accounts hosted on the same machine as FileMaker server. But, since FileMaker Server 16, we now have the ability to use external authentication through Oauth. This means we can use a third party like Amazon, Google or Microsoft in order to allow users to access solutions and manage their own passwords. If you're looking for an easier way to manage the users of your solution, then you'll find out how it works and how to make it happen within this video about Oauth External Authentication. Click the title or link to this article to view the video. Afficher la totalité du billet
  10. FileMaker Magazine

    Layout Object Palette Know How

    The Layout Objects palette was an absolutely WONDERFUL addition to working in FileMaker's Layout Mode. If you've not given yourself the time to fully explore what's possible with it then this video will give you a great reason to do so. In this video, I walk through a re-work I needed to do on a database project which had a ton of extra layout objects. I show you how I used the Layout Objects palette in the most effective way possible. The tips and tricks provided may very well save you a ton of time too. Think there might be some hidden tricks waiting within the Layout Objects palette? Then this video is certainly for you! Click the title or link to this article to view the video. Afficher la totalité du billet
  11. FileMaker Magazine

    Tabbed List Views

    One of the challenges I love the most within FileMaker is creating something which requires less time and effort than the "older way" of doing the same thing. Such is the case with a tabbed list view. I recently came upon a sample file showcasing how to do something in multiple list views. It was using an older method of "simulated" tabs by simply placing clickable buttons in a horizontal row and making one of the buttons look different on each respective layout. So I thought to myself, "Why isn't he just using a normal tab panel?". You can certainly do it. You just need a few key pieces of info in order to create a very powerful navigational tool for a tabbed based list view. And, that's what this video is all about Tabbed List Views. Click the title or link to this article to view the video. Afficher la totalité du billet
  12. FileMaker Magazine

    Ultimate FileMaker Debugging

    Every craftsman should know how to use his or her set of tools effectively. When you know all the various uses and features of a given tool you then become more efficient at your trade. In FileMaker Pro Advanced, now available to pretty much everyone in version 17, there's one tool which helps you both understand what's happening and figure out what's not happening. The Script Debugger is an absolutely essential tool. Creating a well functioning script is a lot like Michelangelo creating David. It didn't just appear because he held the tools in his hands. It was because of the constant refinement with the tools until the beauty within was finally present. Writing a script is no different. You won't get it right the first time and you with almost always be able to refine and make it better. So, it goes without saying that knowing how to use the Script Debugger is one of the number one things you should know how to do when coding in FileMaker Pro. Click the title or link to this article to view the video. Afficher la totalité du billet
  13. FileMaker Magazine

    Custom ordered portals

    Every software user loves convenience. Heck, every human being loves convenience. So, why not provide it within every aspect of your user interface? The problem, however, which you may run across is figuring certain features out. FileMaker can be a very simple program or something quite complex if you're trying to do something custom like providing users with the ability to custom order their related records. The most basic sequential ordering of data comes in the form of simply providing a number field called something like "order", "sequence" or the more mathematically inclined "delta". Once you have the field, you can allow the user to manually change the values. But, that becomes a real pain when you try to add a record between the numbers 1 and 2. You now have a user entering 1.5 or 1.3 and 1.7 in order to get values to sort properly. Then, having to manually reserialize all the original values is just an unnecessary pain. Well, the best solution to this problem is to simply use the automation provided by FileMaker's powerful scripting engine. With a few scripts, a value list, and a bit of FileMaker know-how, we can provide a very quick-and-easy method of allowing users to custom order portal rows. Click the title or link to this article to view the video. Afficher la totalité du billet
  14. FileMaker Magazine

    Exporting Field Data Properly

    There's a lot of pretty boring stuff you need to know about when programming in FileMaker - or any other coding environment for that matter. Knowing the fundamentals of how to move information around is a critical skill. If the file format isn't correct or the receiving end of an online service just won't process your data, then it can certainly be a confusing dilemma which may take hours of learning in order to understand exactly what's going wrong. Of course, if you can simply watch a video like this, and gain an instant understanding of what it takes to move text in and out of a FileMaker field, then why not take advantage? In this video and technique file you'll find two super helpful scripts which can be used to pretty much move any text into and out of a field. It doesn't matter whether the text is JSON, XML, PHP, HTML or just plain simple text. Once you know how file encodings and line endings work you can move information around like a professional! Click the title or link to this article to view the video. Afficher la totalité du billet
  15. FileMaker Magazine

    Multiple Parameters using JSON

    The ingenuity of developers has always extended beyond the limitations presented within any given environment - both physical and virtual. If you can't cross a river with your cart and horse, then you learn how to build a bridge and make it last. Such is the case with FileMaker's script parameters. There's always been only one way to pass anything into a script - as one big blob of text. There's nothing which controls what type of data is embedded within the block of text and it's up to the developer to create a method for passing discrete pieces of data. From the most basic method of simply passing a return delimited list of data we can always take the individual pieces one by one from the list. Things, however, can get a bit more complex with larger amounts of data. When you need to pass return delimited data as a single parameter out of many you have to be a bit more creative. This is where FileMaker's addition of its JSON functions within FileMaker 16 have helped moved the feature set forward. While there is no native methods for passing multiple parameters, we do have a standard structure for name/value pairs now when working with FileMaker. Click the title or link to this article to view the video. Afficher la totalité du billet
×