Jump to content

FileMaker Magazine

Moderators
  • Content Count

    681
  • 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. Web browsers and their primary language, Javascript, have a very robust ecosystem. In fact, there's few solutions you can't find out in the world of Javascript. So, in FileMaker, when it comes to our data and its presentation within a user friendly fashion, we can easily create a layout, set it to list view and allow users to simply start using FileMaker. But, wait, using FileMaker itself isn't always super user-friendly. In fact, you have to learn how to sort by multiple columns by actually heading into a dialog box. Which, admittedly, becomes easier to use, but it's not immediately UI friendly in that you can't just click on the column you want to sort. Let alone select a second or third column and have those sorts apply too. Enter the world of the Web Viewer and Javascript and it's quite refreshing what you can do and in such a short time. This video walks you through the process of setting up a Javascript library called Datatables. It's a very powerful, and immediately usable UI for working with tabular data. While you can implement the same features within FileMaker itself, it takes quite a bit longer to do so. Click the title or link to this article to view the video. View the full article
  2. Web browsers and their primary language, Javascript, have a very robust ecosystem. In fact, there's few solutions you can't find out in the world of Javascript. So, in FileMaker, when it comes to our data and its presentation within a user friendly fashion, we can easily create a layout, set it to list view and allow users to simply start using FileMaker. But, wait, using FileMaker itself isn't always super user-friendly. In fact, you have to learn how to sort by multiple columns by actually heading into a dialog box. Which, admittedly, becomes easier to use, but it's not immediately UI friendly in that you can't just click on the column you want to sort. Let alone select a second or third column and have those sorts apply too. Enter the world of the Web Viewer and Javascript and it's quite refreshing what you can do and in such a short time. This video walks you through the process of setting up a Javascript library called Datatables. It's a very powerful, and immediately usable UI for working with tabular data. While you can implement the same features within FileMaker itself, it takes quite a bit longer to do so. Click the title or link to this article to view the video. View the full article
  3. Is there really any question the PDF file format will be going away any time soon? Personally, I don't think so. And, neither should you. Adobe released their license to the technology in 2008 and it became an open standard for the world to use. Airlines use it for tickets, ticket companies use it for concerts and basically it's the digital equivalent of good old real-world paper for the digital world. So what does this mean to you and your FileMaker database? Well, if you've got data within your database or you're capturing data in something like Web Direct, then knowing you can merge that data into a form fillable PDF can be invaluable. Especially if you need to put that data into a fixed format - like a PDF! By running a server side script, and running some freely available software which is super fast an efficient, you can send out contracts, invoices, notices or even event tickets with merged in data from your FileMaker database. Yes, you can certainly generate a PDF right from within FileMaker using your own data, but there are those situations where replicating an existing PDF just takes too much time. So just merge the data into a form fillable PDF. Plus, it just might be faster than generating it from within FileMaker! Click the title or link to this article to view the video. View the full article
  4. Is there really any question the PDF file format will be going away any time soon? Personally, I don't think so. And, neither should you. It was released by Adobe in 2008 and became an open standard for the world to use. Airlines use it for tickets, ticket companies use it for concerts and basically it's the digital equivalent of good old real-world paper for the digital world. So what does this mean to you and your FileMaker database? Well, if you've got data within your database or you're capturing data in something like Web Direct, then knowing you can merge that data into a form fillable PDF can be invaluable. Especially if you need to put that data into a fixed format - like a PDF! By running a server side script, and running some freely available software which is super fast an efficient, you can send out contracts, invoices, notices or even event tickets with merged in data from your FileMaker database. Yes, you can certainly generate a PDF right from within FileMaker using your own data, but there are those situations where replicating an existing PDF just takes too much time. So just merge the data into a form fillable PDF. Plus, it just might be faster than generating it from within FileMaker! Click the title or link to this article to view the video. View the full article
  5. Keeping things private, so only those who need access can access them, has been a desirable situation for as long as people have wanted to keep things private. The only difference between the invention of invisible ink and today is trying to keep ahead of those who have the knowledge on how to access what you're trying to keep private. It's the eternal game of cat and mouse between those who seek to access what they shouldn't and those who want to keep those people out. Within FileMaker, we now have the option of using the FileMaker 16 added Crypt* functions. This functionality, formerly only accessible through plug-ins, can now be used to securely encrypt your data within regular text fields. There's some terminology and understanding that needs to be paired with using the provided functions in order to make sure you're staying truly as secure as you possibly can when using them. This video provides the information needed to understand what that terminology is and how to securely encrypt private data within you own FileMaker solutions. Click the title or link to this article to view the video. View the full article
  6. Keeping things private, so only those who need access can access them, has been a desirable situation for as long as people have wanted to keep things private. The only difference between the invention of invisible ink and today is trying to keep ahead of those who have the knowledge on how to access what you're trying to keep private. It's the eternal game of cat and mouse between those who seek to access what they shouldn't and those who want to keep those people out. Within FileMaker, we now have the option of using the FileMaker 16 added Crypt* functions. This functionality, formerly only accessible through plug-ins, can now be used to securely encrypt your data within regular text fields. There's some terminology and understanding that needs to be paired with using the provided functions in order to make sure you're staying truly as secure as you possibly can when using them. This video provides the information needed to understand what that terminology is and how to securely encrypt private data within you own FileMaker solutions. Click the title or link to this article to view the video. View the full article
  7. While FileMaker may promote the low-code/no code aspects of FileMaker Pro, there's a lot to be said about knowing how to design a great system as opposed to thinking you'll end up with one by default. Especially, one which will perform under load and scale to the degree which FileMaker can. This type of knowledge is learned and simply won't come out of the box when you just start adding fields to your database. If you need to store images, or any type of heavy media, then it may not be a good idea to carelessly start throwing container fields into your tables. In fact, there's a whole bunch of details to know about FileMaker and how it transfers data on a record level basis. As well as knowing what can be done to optimize your storage of container based data. While you'll want things to be easy for your users for adding media, and you'll also want to build a system which will be easy to maintain and update. That's what this video is all about. An optimized approach to container storage and making it easy on yourself when you're going to be working with these types of solutions in the future. Click the title or link to this article to view the video. View the full article
  8. While FileMaker may promote the low-code/no code aspects of FileMaker Pro, there's a lot to be said about knowing how to design a great system as opposed to thinking you'll end up with one by default. Especially, one which will perform under load and scale to the degree which FileMaker can. This type of knowledge is learned and simply won't come out of the box when you just start adding fields to your database. If you need to store images, or any type of heavy media, then it may not be a good idea to carelessly start throwing container fields into your tables. In fact, there's a whole bunch of details to know about FileMaker and how it transfers data on a record level basis. As well as knowing what can be done to optimize your storage of container based data. While you'll want things to be easy for your users for adding media, and you'll also want to build a system which will be easy to maintain and update. That's what this video is all about. An optimized approach to container storage and making it easy on yourself when you're going to be working with these types of solutions in the future. Click the title or link to this article to view the video. View the full article
  9. FileMaker Pro provides a more than capable UI surface in order to design great looking user interfaces. In fact, it's the speed with which you can create that user interface which makes FileMaker Pro so appealing. The great thing about recent releases has been the flexibility of the newer layout objects. When you combine the utility of sliders, tab panels, popovers and layout mode's various layout parts, you can further extend what you can do within FileMaker by quite a bit. This video presents the top five tips and tricks you can accomplish with offscreen options possible with both native layout widgets and layout parts. If you're looking to increase what you know about how you can make creative combinations within FileMaker's presentation layer, then look no further! Click the title or link to this article to view the video. View the full article
  10. FileMaker Pro provides a more than capable UI surface in order to design great looking user interfaces. In fact, it's the speed with which you can create that user interface which makes FileMaker Pro so appealing. The great thing about recent releases has been the flexibility of the newer layout objects. When you combine the utility of sliders, tab panels, popovers and layout mode's various layout parts, you can further extend what you can do within FileMaker by quite a bit. This video presents the top five tips and tricks you can accomplish with offscreen options possible with both native layout widgets and layout parts. If you're looking to increase what you know about how you can make creative combinations within FileMaker's presentation layer, then look no further! Click the title or link to this article to view the video. View the full article
  11. When developing a FileMaker solution, you often want a system where the distribution of labor is such that other administrators can create and manage the users of that system. It can't always come back to the developer who has the only Full Access account. When considering FileMaker's authentication methods, you basically have three options. Internal, external and third party. The external option is typically Active Directory on Windows or OpenDirectory on Macintosh. The newer third party options are from Amazon, Google and Microsoft. However, with both external and third party, you have to manage users and their passwords outside of the FileMaker space. If you're wanting to use FileMaker itself to mange users and passwords, then you'll be using FileMaker's internal accounts. The trick is to have a way to manage those accounts within your database. And, that's up to you to both create and manage. This video is about using a dedicated Users table and how you can securely manage the communication between your table of users and the actual users list within FileMaker's internal accounts. Need to provide a secure method of allowing certain users the ability to create and delete accounts? This video will have the know-how you need. Click the title or link to this article to view the video. View the full article
  12. When developing a FileMaker solution, you often want a system where the distribution of labor is such that other administrators can create and manage the users of that system. It can't always come back to the developer who has the only Full Access account. When considering FileMaker's authentication methods, you basically have three options. Internal, external and third party. The external option is typically Active Directory on Windows or OpenDirectory on Macintosh. The newer third party options are from Amazon, Google and Microsoft. However, with both external and third party, you have to manage users and their passwords outside of the FileMaker space. If you're wanting to use FileMaker itself to mange users and passwords, then you'll be using FileMaker's internal accounts. The trick is to have a way to manage those accounts within your database. And, that's up to you to both create and manage. This video is about using a dedicated Users table and how you can securely manage the communication between your table of users and the actual users list within FileMaker's internal accounts. Need to provide a secure method of allowing certain users the ability to create and delete accounts? This video will have the know-how you need. Click the title or link to this article to view the video. View the full article
  13. When you first start writing scripts within FileMaker, you're typically so focused on the feature or solution you're working on that you integrate it directly into the area where you're working. It takes a bit of time and skill, however, to quickly recognize when you need to make a particular script more generalized in nature and treat it like a routine which simply needs to take input and provide some output. Once you get to this point in your development path, you discover all kinds of opportunities where one script will serve the purpose of many. And, you may find that some of your scripts are in the range of 80 to 90 percent redundant. Possibly varying by only a few lines of code. In this video, I present a very common pattern for many scripts. Treating them like a function and simply following a format for inbound and outbound data from that script. You'll also find a good number of tips regarding documentation, script composition and the big bonus is that we do this with a script which will give you the instant ability to send out text messages via the Twilio API! Click the title or link to this article to view the video. View the full article
  14. When you first start writing scripts within FileMaker, you're typically so focused on the feature or solution you're working on that you integrate it directly into the area where you're working. It takes a bit of time and skill, however, to quickly recognize when you need to make a particular script more generalized in nature and treat it like a routine which simply needs to take input and provide some output. Once you get to this point in your development path, you discover all kinds of opportunities where one script will serve the purpose of many. And, you may find that some of your scripts are in the range of 80 to 90 percent redundant. Possibly varying by only a few lines of code. In this video, I present a very common pattern for many scripts. Treating them like a function and simply following a format for inbound and outbound data from that script. You'll also find a good number of tips regarding documentation, script composition and the big bonus is that we do this with a script which will give you the instant ability to send out text messages via the Twilio API! Click the title or link to this article to view the video. View the full article
  15. The number of features available within FileMaker Go on a mobile device is more than icing on the cake. It's just downright cool we have access to so many features. And, all without having to write super complex code. There is, however, some learning to do when it comes to interacting with URLs and web viewers. It turns out that many web sites, including Google's web based maps site, will change its url as you interact with the web viewer. This causes a problem when you supply an original url to the web viewer and the user expects the same result when clicking on a button which opens the external Google Maps iOS app. The url, which includes needed pieces of information, may vary depending on the interaction with the web viewer. Fortunately, this video covers all the information you need to know when working with urls and parsing them from either web viewers or from any other location. This video will help you not only interact with the Google Maps iOS application, but also with any other external application which is to be opened from within FileMaker Pro. Need to integrate other iOS apps with your FileMaker Go app? Give this video a view! 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.