Jump to content

FileMaker Magazine

Moderators
  • Content Count

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

1 Follower

About FileMaker Magazine

  • Rank
    member

Profile Information

  • Gender
    Male
  • Location
    Murrieta, CA

Contact Methods

  • Website URL
    http://www.filemakermagazine.com

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Your FileMaker database is obviously designed to store data. FileMaker also provides the tools for precisely extracting that data as needed. When and how you extract the data is based on your needs. Sometimes, you need the data for an external system or API. Maybe it's needed for an export or you need the data specifically for a given visualization of that data. In a recent video, I showed some Sankey Diagrams and how cool they are as visualization tools. One of keys to presenting a great visualization is being able to extract the data you need to present. This data may also change as the user navigates through the chart or your user interface. So, in short, we need to be familiar with all the various ways in which we can collect our data out of the database. Fortunately, there is a somewhat small collection of methods, but knowing how each of them work and when you might use one over the other is a matter of experience and practice. In this video, I cover the possible variations and you get to choose which method you want to use and when. The ultimate method is something you'll find towards the end of the video. Click the title or link to this article to view the video. View the full article
  2. Your FileMaker database is obviously designed to store data. FileMaker also provides the tools for precisely extracting that data as needed. When and how you extract the data is based on your needs. Sometimes, you need the data for an external system or API. Maybe it's needed for an export or you need the data specifically for a given visualization of that data. In a recent video, I showed some Sankey Diagrams and how cool they are as visualization tools. One of keys to presenting a great visualization is being able to extract the data you need to present. This data may also change as the user navigates through the chart or your user interface. So, in short, we need to be familiar with all the various ways in which we can collect our data out of the database. Fortunately, there is a somewhat small collection of methods, but knowing how each of them work and when you might use one over the other is a matter of experience and practice. In this video, I cover the possible variations and you get to choose which method you want to use and when. The ultimate method is something you'll find towards the end of the video. Click the title or link to this article to view the video. View the full article
  3. There are so many times I hear lamentations from stalwart "FileMaker only" developers who declare that you should do everything within FileMaker and FileMaker alone. This is just crazy. It's like saying you should build an entire house with only a hammer and nails. How could you ever do that efficiently? What about the plumbing? The electrical? Well, you can't. You always have to increase what you know and become familiar with other tools and newer technologies. In this video, I showcase a very compelling use of Javascript within a web viewer. It's because native FileMaker simply can't generate a Sankey flow diagram. FileMaker doesn't do curves, it does data. However, FileMaker can make it happen with the use of Javascript and a web viewer. The best part yet is that it's already been done for us. All you have to do is become familiar with how to modify and integrate with your own data. That's exactly what this video does. It will teach you how to understand the implementation of this particular Javascript and give you the confidence to integrate other examples as well. If presenting your data with a very compelling visualization is something which you'd like to do, then you'll find the knowledge you need within this video. Click the title or link to this article to view the video. View the full article
  4. There are so many times I hear lamentations from stalwart "FileMaker only" developers who declare that you should do everything within FileMaker and FileMaker alone. This is just crazy. It's like saying you should build an entire house with only a hammer and nails. How could you ever do that efficiently? What about the plumbing? The electrical? Well, you can't. You always have to increase what you know and become familiar with other tools and newer technologies. In this video, I showcase a very compelling use of Javascript within a web viewer. It's because native FileMaker simply can't generate a Sankey flow diagram. FileMaker doesn't do curves, it does data. However, FileMaker can make it happen with the use of Javascript and a web viewer. The best part yet is that it's already been done for us. All you have to do is become familiar with how to modify and integrate with your own data. That's exactly what this video does. It will teach you how to understand the implementation of this particular Javascript and give you the confidence to integrate other examples as well. If presenting your data with a very compelling visualization is something which you'd like to do, then you'll find the knowledge you need within this video. Click the title or link to this article to view the video. View the full article
  5. Yes, while it's unfortunate FileMaker Go doesn't run on Android devices, we can still take advantage of what's offered on the iOS side of things. This comes in the form of Apple Maps using MapKit JS. True, Google Maps does seem to have the slight edge when it comes to feature set, but if you need full control over an integrated mapping experience, then Apple's MapKit JS may just be the perfect solution for you. MapKit JS, currently in beta since WWDC 2018, only seems to work on the Mac version of FileMaker Pro. So, you're still stuck with Google Maps if you are needing Windows support. However, if you're using either Macintosh computers and/or iOS with a FileMaker Go, or an SDK bound iOS solution, then it may be the case that Apple Maps would be a wonderful solution within a Web Viewer. Especially, now that we know that native bidirectional communication within JavaScript is coming to a Web Viewer near you! Now seems like an ideal time to take a look into this very capable mapping technology. Click the title or link to this article to view the video. View the full article
  6. Yes, while it's unfortunate FileMaker Go doesn't run on Android devices, we can still take advantage of what's offered on the iOS side of things. This comes in the form of Apple Maps using MapKit JS. True, Google Maps does seem to have the slight edge when it comes to feature set, but if you need full control over an integrated mapping experience, then Apple's MapKit JS may just be the perfect solution for you. MapKit JS, currently in beta since WWDC 2018, only seems to work on the Mac version of FileMaker Pro. So, you're still stuck with Google Maps if you are needing Windows support. However, if you're using either Macintosh computers and/or iOS with a FileMaker Go, or an SDK bound iOS solution, then it may be the case that Apple Maps would be a wonderful solution within a Web Viewer. Especially, now that we know that native bidirectional communication within JavaScript is coming to a Web Viewer near you! Now seems like an ideal time to take a look into this very capable mapping technology. Click the title or link to this article to view the video. View the full article
  7. With FileMaker Pro development, there are so many little areas which take a bit of time to investigate and discover. One of the more important areas is that of search and making sure you provide users with the results they might expect. While using one of my own personal tools, I found that FileMaker itself couldn't find the result I was looking for when using its own Quick Find feature. I thought that was a bit odd and had to dig into the code to find out what the real issue was. While the issue was tied to the type of data I was searching, it provided a great opportunity to explore how one would address this particular issue. Using FileMaker's search operators is something which every great FileMaker developer should be aware of. Fortunately, the descriptions provided by FileMaker's documentation helps us solve the issue. Watch this video if you've got an interest in learning how FileMaker searches for content and how you solve unique issues which may prevent your system from providing the results you intend. Click the title or link to this article to view the video. View the full article
  8. With FileMaker Pro development, there are so many little areas which take a bit of time to investigate and discover. One of the more important areas is that of search and making sure you provide users with the results they might expect. While using one of my own personal tools, I found that FileMaker itself couldn't find the result I was looking for when using its own Quick Find feature. I thought that was a bit odd and had to dig into the code to find out what the real issue was. While the issue was tied to the type of data I was searching, it provided a great opportunity to explore how one would address this particular issue. Using FileMaker's search operators is something which every great FileMaker developer should be aware of. Fortunately, the descriptions provided by FileMaker's documentation helps us solve the issue. Watch this video if you've got an interest in learning how FileMaker searches for content and how you solve unique issues which may prevent your system from providing the results you intend. Click the title or link to this article to view the video. View the full article
  9. When you work within a development environment long enough, you end up realizing where some of the pain points are for certain types of situations. For FileMaker Pro development, and many other systems, one of the biggest pain points is maintenance of a growing system. Where older code may be replaced instead of refactored. What ends up happening is the older, unused code just sits there and only contributes to the growing mess which is what I call the "Giant Ball of Spaghetti Mess" that is a FileMaker solution gone awry. So, what is one of the best solutions for keeping a system easy-to-maintain while also being able to understand what you're doing while developing? Naming standards or conventions of course. In this video, I discuss some updates to my own personal conventions which will lend themselves to helping to make a FileMaker solution much more streamlined. If you consider your own FileMaker solution a special kind of mess, then give this video a peek for information about why naming certain things in certain ways can give you a helping hand for keeping your FileMaker solution easier to maintain and update. Click the title or link to this article to view the video. View the full article
  10. When you work within a development environment long enough, you end up realizing where some of the pain points are for certain types of situations. For FileMaker Pro development, and many other systems, one of the biggest pain points is maintenance of a growing system. Where older code may be replaced instead of refactored. What ends up happening is the older, unused code just sits there and only contributes to the growing mess which is what I call the "Giant Ball of Spaghetti Mess" that is a FileMaker solution gone awry. So, what is one of the best solutions for keeping a system easy-to-maintain while also being able to understand what you're doing while developing? Naming standards or conventions of course. In this video, I discuss some updates to my own personal conventions which will lend themselves to helping to make a FileMaker solution much more streamlined. If you consider your own FileMaker solution a special kind of mess, then give this video a peek for information about why naming certain things in certain ways can give you a helping hand for keeping your FileMaker solution easier to maintain and update. Click the title or link to this article to view the video. View the full article
  11. Well now, you really can't get away from it, because most of the Internet is pretty much dependent upon it. Yep, it's JavaScript of course. So, should you be afraid of using it within FileMaker Pro? No WAY! You should take advantage of it as much as possible. Integrating JavaScript solutions is what makes FileMaker solutions that much more powerful. In this video, we take a look at using the Google Maps JavaScript API in order to capture latitude and longitude coordinates. Along with that, we look at how you can jump between the free standard Maps URL APIs and how you can create a solution which will allow a user to double-click to capture the desired coordinates. This type of solution can be used for any situation where capturing initial intended coordinates is desired. Once you have the initial coordinates, you can always send someone out into the field to capture the true coordinates using a copy of FileMaker Go. Whatever your mapping needs are, you can certainly solve the solution with Google Maps JavaScript APIs. You just have to dip your feet into the pool and that's exactly what this video will do for you. Click the title or link to this article to view the video. View the full article
  12. Well now, you really can't get away from it, because most of the Internet is pretty much dependent upon it. Yep, it's JavaScript of course. So, should you be afraid of using it within FileMaker Pro? No WAY! You should take advantage of it as much as possible. Integrating JavaScript solutions is what makes FileMaker solutions that much more powerful. In this video, we take a look at using the Google Maps JavaScript API in order to capture latitude and longitude coordinates. Along with that, we look at how you can jump between the free standard Maps URL APIs and how you can create a solution which will allow a user to double-click to capture the desired coordinates. This type of solution can be used for any situation where capturing initial intended coordinates is desired. Once you have the initial coordinates, you can always send someone out into the field to capture the true coordinates using a copy of FileMaker Go. Whatever your mapping needs are, you can certainly solve the solution with Google Maps JavaScript APIs. You just have to dip your feet into the pool and that's exactly what this video will do for you. Click the title or link to this article to view the video. View the full article
  13. Over my many years of working with FileMaker Pro, I've often talked about adding in a multiple selection feature. Whether working within FileMaker's List View or working with portal rows, this can be a critical feature for allowing users to make selections and then being able to take some type of action against that selection. Whatever the desired result is, such as processing the data, saving the set, or just being able to see a set of selected records, knowing what your options are, and how to implement is certainly worthwhile. In this video, I walk through the use of a variety of custom functions and show the multiple options possible when considering a multi-selection technique for record rows. This video is great tool for understanding what can be done and how to implement a multiple-selection strategy. Click the title or link to this article to view the video. View the full article
  14. Over my many years of working with FileMaker Pro, I've often talked about adding in a multiple selection feature. Whether working within FileMaker's List View or working with portal rows, this can be a critical feature for allowing users to make selections and then being able to take some type of action against that selection. Whatever the desired result is, such as processing the data, saving the set, or just being able to see a set of selected records, knowing what your options are, and how to implement is certainly worthwhile. In this video, I walk through the use of a variety of custom functions and show the multiple options possible when considering a multi-selection technique for record rows. This video is great tool for understanding what can be done and how to implement a multiple-selection strategy. Click the title or link to this article to view the video. View the full article
  15. One of your most powerful methods of showing data, within a fully controlled manner, is using the combination of global fields and portals. The portal object isn't simply for showing the related data as it belongs to one single record. A portal is a display tool useful for presenting whatever data you want and, however you want. In this video, I use the example of showing multiple events based on the selection of multiple locations. Whether you need to provide a simple multi-selection option in your UI, or your filtering needs extend to multiple field values, the use of a global field, in conjunction with a portal object, is how you can achieve a lot of your display objectives. Click the title or link to this article to view the video. View the full article
×
×
  • Create New...

Important Information

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