Jump to content

FileMaker Magazine

Moderators
  • Content count

    576
  • Joined

  • Last visited

  • Days Won

    4

FileMaker Magazine last won the day on August 4 2016

FileMaker Magazine had the most liked content!

Community Reputation

11 Good

About FileMaker Magazine

  • Rank
    member

Profile Information

  • Gender
    Male
  • Location
    Murrieta, CA

Contact Methods

  • Website URL
    http://www.filemakermagazine.com
  1. FileMaker Overview: Number Functions

    If you're the type of person who's into Math, then you probably know when you need to use Factorial() versus Exp() versus Div(). Inevitably, you're a better mathematician than I. My use of the Number functions extends to how useful they can be when you're creating your FileMaker user interface and solving workflow related problems. When it comes to FileMaker's Number functions, there are number of tricks I've picked up over the years from those who are much smarter at the "math part" than I am. For the most part, the functions are there when you need them and are obviously useful when your required solution deals with math. In this video, I go through the Number functions and talk about when and how I've used them. Which ones I've used the most and what you can do with them. Click the title or link to this article to view the video. View the full article
  2. If you're the type of person who's into Math, then you probably know when you need to use Factorial() versus Exp() versus Div(). Inevitably, you're a better mathematician than I. My use of the Number functions extends to how useful they can be when you're creating your FileMaker user interface and solving workflow related problems. When it comes to FileMaker's Number functions, there are number of tricks I've picked up over the years from those who are much smarter at the "math part" than I am. For the most part, the functions are there when you need them and are obviously useful when your required solution deals with math. In this video, I go through the Number functions and talk about when and how I've used them. Which ones I've used the most and what you can do with them. Click the title or link to this article to view the video. View the full article
  3. While placing fields and merge text onto a layout is a simple matter of adding the elements to the layout, the formatting you apply to onscreen data can only go so far. Sure, we can use Conditional Formatting in order to achieve all kinds of great looking layouts, but, what if there were a way to go beyond these straight-forward layout tools and leverage even more control. What about dynamically displaying colored and formatted text without having to create calculated fields? Well, all of this, and more, can be accomplished when you take advantage of FileMaker's Text Formatting functions. This will video will walk you through what you need to know about the Text Formatting functions and how they can be used to give your layouts a much more impactful presence. Click the title or link to this article to view the video. View the full article
  4. FileMaker Overview: Text Formatting Functions

    While placing fields and merge text onto a layout is a simple matter of adding the elements to the layout, the formatting you apply to onscreen data can only go so far. Sure, we can use Conditional Formatting in order to achieve all kinds of great looking layouts, but, what if there were a way to go beyond these straight-forward layout tools and leverage even more control. What about dynamically displaying colored and formatted text without having to create calculated fields? Well, all of this, and more, can be accomplished when you take advantage of FileMaker's Text Formatting functions. This will video will walk you through what you need to know about the Text Formatting functions and how they can be used to give your layouts a much more impactful presence. Click the title or link to this article to view the video. View the full article
  5. FileMaker Overview: Text Functions

    When you're learning a new skill or programming language, you don't always know what you might need to know. Such was the case when I received an email asking me to go through the various groups of FileMaker functions. I thought to myself, "In most of my videos, I showcase the use of certain functions, but, I've never really gone through each function one by one." So, in this video, I do exactly that. I relay my experience and exposure to each of the various FileMaker functions. Starting with the Text group, I walk through each of the functions, or function types, and talk about their use and what I consider their frequency of use to be in daily FileMaker development. Granted, each solution built in FileMaker is always different and where some solutions may need more math and numbers, others may just store and manipulate data, it's a great thing to know about all the possible functions you can use. And, that's exactly what this video is about! Click the title or link to this article to view the video. View the full article
  6. FileMaker Overview: Text Functions

    When you're learning a new skill or programming language, you don't always know what you might need to know. Such was the case when I received an email asking me to go through the various groups of FileMaker functions. I thought to myself, "In most of my videos, I showcase the use of certain functions, but, I've never really gone through each function one by one." So, in this video, I do exactly that. I relay my experience and exposure to each of the various FileMaker functions. Starting with the Text group, I walk through each of the functions, or function types, and talk about their use and what I consider their frequency of use to be in daily FileMaker development. Granted, each solution built in FileMaker is always different and where some solutions may need more math and numbers, others may just store and manipulate data, it's a great thing to know about all the possible functions you can use. And, that's exactly what this video is about! Click the title or link to this article to view the video. View the full article
  7. Generating SVG Barcodes

    While barcodes have been around for decades, and we all know how fundamental they are to everyday life, it doesn't mean your last implementation is still the best way to integrate them. Technology is always changing and it's moving forward while new technologies replace older ones. A barcode which used to be in JPEG format can now be in the scalable SVG format. In this video, I walk through the use of a JavaScript library which allows for the easy creation of SVG barcodes. This works without a specific font and allows for a scalable file which can be integrated into a PDF or any other type of output. Need barcode support on FileMaker Go on iOS? Need to generate barcodes client side on either Mac or Windows? If you're building a solution which needs to use barcodes, and you're looking for the least expensive option, then you can't get much better than a commercially free JavaScript library. All it takes is a little bit of know-how and you're creating barcodes in very little time! Click the title or link to this article to view the video. View the full article
  8. Generating SVG Barcodes

    While barcodes have been around for decades, and we all know how fundamental they are to everyday life, it doesn't mean your last implementation is still the best way to integrate them. Technology is always changing and it's moving forward while new technologies replace older ones. A barcode which used to be in JPEG format can now be in the scalable SVG format. In this video, I walk through the use of a JavaScript library which allows for the easy creation of SVG barcodes. This works without a specific font and allows for a scalable file which can be integrated into a PDF or any other type of output. Need barcode support on FileMaker Go on iOS? Need to generate barcodes client side on either Mac or Windows? If you're building a solution which needs to use barcodes, and you're looking for the least expensive option, then you can't get much better than a commercially free JavaScript library. All it takes is a little bit of know-how and you're creating barcodes in very little time! Click the title or link to this article to view the video. View the full article
  9. JavaScripting PDFs

    FileMaker Pro has a wonderful PDF generator. In fact, one of the biggest benefits of using FileMaker for the purpose of output is that you can make any layout look exactly how you'd like and with a few script steps, you've got PDF output which will fit 95% of the situations you'll come across. There are, however, certain situations where knowing how to generate a PDF using JavaScript, from within a Web Viewer, will give you the exact results you're looking for. There are a number of advantages with this approach. First, it can be SUPER fast when generating the PDF and second, you can selectively decide what you want to output from within the whole of your HTML. So, if you're using HTML to present a lot of information, but only want a PDF of a portion of that HTML, then you can certainly accomplish that with this technique. Even if you don't need the exact functionality of HTML -> PDF output there's a lot to learn from this video if you've never used JavaScript in order to call a FileMaker script and pass in some data. Click the title or link to this article to view the video. View the full article
  10. JavaScripting PDFs

    FileMaker Pro has a wonderful PDF generator. In fact, one of the biggest benefits of using FileMaker for the purpose of output is that you can make any layout look exactly how you'd like and with a few script steps, you've got PDF output which will fit 95% of the situations you'll come across. There are, however, certain situations where knowing how to generate a PDF using JavaScript, from within a Web Viewer, will give you the exact results you're looking for. There are a number of advantages with this approach. First, it can be SUPER fast when generating the PDF and second, you can selectively decide what you want to output from within the whole of your HTML. So, if you're using HTML to present a lot of information, but only want a PDF of a portion of that HTML, then you can certainly accomplish that with this technique. Even if you don't need the exact functionality of HTML -> PDF output there's a lot to learn from this video if you've never used JavaScript in order to call a FileMaker script and pass in some data. Click the title or link to this article to view the video. View the full article
  11. Pivoting data

    While FileMaker's own Layout Mode provides excellent tools for formatting data for display and output, it isn't always the most convenient for certain types of output. A prime example is a pivot table. Or, the output of data which is normally columnar formatted into a horizontal format. When attempting to do this with native FileMaker functionality, it quickly becomes a bit of a hassle, typically including more relationships than should be otherwise necessary. There are solutions which can make use of repeating horizontal fields, but these typically have a hard limit and the width of the data does not dictate the largest column width. If you work creatively with HTML/CSS and the other available features within FileMaker, you can realize a more flexible solution for horizontal data display and output! Click the title or link to this article to view the video. View the full article
  12. Pivoting data

    While FileMaker's own Layout Mode provides excellent tools for formatting data for display and output, it isn't always the most convenient for certain types of output. A prime example is a pivot table. Or, the output of data which is normally columnar formatted into a horizontal format. When attempting to do this with native FileMaker functionality, it quickly becomes a bit of a hassle, typically including more relationships than should be otherwise necessary. There are solutions which can make use of repeating horizontal fields, but these typically have a hard limit and the width of the data does not dictate the largest column width. If you work creatively with HTML/CSS and the other available features within FileMaker, you can realize a more flexible solution for horizontal data display and output! Click the title or link to this article to view the video. View the full article
  13. Card Sidebar Navigation

    FileMaker 16's new Card Windows have opened the flood gates for all kinds of new methods for presenting information. Not least of which are your common dialogs and wizards. But, what about using them for navigation? Why not? In fact, you'll find so many benefits from using a Card Window, for the purpose of navigation, you may think it makes little sense to use anything else. Especially, when you want the navigation to both hide and reveal as needed. In this video, we walk through a wonderful technique of using a Card Window for the purpose of sidebar navigation. Not only does it blend in well with the user interface but it retains which menus were collapsed and which were expanded. It works in both Form view and List view. Overall, it's one of the best methods you can choose for solution navigation if you're using FileMaker 16 or later. Click the title or link to this article to view the video. View the full article
  14. Card Sidebar Navigation

    FileMaker 16's new Card Windows have opened the flood gates for all kinds of new methods for presenting information. Not least of which are your common dialogs and wizards. But, what about using them for navigation? Why not? In fact, you'll find so many benefits from using a Card Window, for the purpose of navigation, you may think it makes little sense to use anything else. Especially, when you want the navigation to both hide and reveal as needed. In this video, we walk through a wonderful technique of using a Card Window for the purpose of sidebar navigation. Not only does it blend in well with the user interface but it retains which menus were collapsed and which were expanded. It works in both Form view and List view. Overall, it's one of the best methods you can choose for solution navigation if you're using FileMaker 16 or later. Click the title or link to this article to view the video. View the full article
  15. Card Sidebar Navigation

    FileMaker 16's new Card Windows have opened the flood gates for all kinds of new methods for presenting information. Not least of which are your common dialogs and wizards. But, what about using them for navigation? Why not? In fact, you'll find so many benefits from using a Card Window, for the purpose of navigation, you may think it makes little sense to use anything else. Especially, when you want the navigation to both hide and reveal as needed. In this video, we walk through a wonderful technique of using a Card Window for the purpose of sidebar navigation. Not only does it blend in well with the user interface but it retains which menus were collapsed and which were expanded. It works in both Form view and List view. Overall, it's one of the best methods you can choose for solution navigation if you're using FileMaker 16 or later. Click the title or link to this article to view the video. View the full article
×

Important Information

By using this site, you agree to our Terms of Use.