Jump to content

FileMaker Magazine

Moderators
  • Posts

    889
  • Joined

  • Last visited

  • Days Won

    4

FileMaker Magazine last won the day on August 4 2016

FileMaker Magazine had the most liked content!

2 Followers

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.

FileMaker Magazine's Achievements

Veteran

Veteran (13/14)

  • First Post
  • Collaborator
  • Posting Machine Rare
  • Conversation Starter
  • Week One Done

Recent Badges

11

Reputation

  1. In the process of creating a simple media archiving database I found I had used the same skill twice because of how FileMaker returns data from certain functions. Hence, I decided to provide you with my simple little start to a Media Archiving solution. Simply, it asks for a folder, then pulls the paths to all files from the selected, and enclosed, folders into the database. It's really a pretty simple thing because it's managed with one simple function from the BaseElements plug-in. However, not all simple things are that simple. There are many things you need to account for when importing something from an external file and how you go about addressing things like prompting a user for a required plug-in. Regardless of whether you're needing a media archiving solution or not, there's always something more you can learn about working with FileMaker in order to accomplish your desired goals. Click the title or link to this article to view the video. View the full article
  2. In the process of creating a simple media archiving database I found I had used the same skill twice because of how FileMaker returns data from certain functions. Hence, I decided to provide you with my simple little start to a Media Archiving solution. Simply, it asks for a folder, then pulls the paths to all files from the selected, and enclosed, folders into the database. It's really a pretty simple thing because it's managed with one simple function from the BaseElements plug-in. However, not all simple things are that simple. There are many things you need to account for when importing something from an external file and how you go about addressing things like prompting a user for a required plug-in. Regardless of whether you're needing a media archiving solution or not, there's always something more you can learn about working with FileMaker in order to accomplish your desired goals. Click the title or link to this article to view the video. View the full article
  3. What makes FileMaker development so fun is the variety of different functions and script steps. They provide an almost infinite number of combinations to solve a wide variety of technical problems. There isn't always just "one way to do it". So, what happens when you stop to think about a more recent feature in light of how you've "always done it before"? Like... sorting... for example. Have you always simply attached the Sort script step to your list view headers and called it a day? What if you could use just two simple scripts to provide single field sorting solution wide? This seems pretty cool since you can manage the sorting of all list views and be able to quickly add this feature to any given layout. Reusable code is a great thing. That's exactly what this video is all about. Taking advantage of lesser known features in order to create technical solutions which provide a high degree of leverage. Let's learn how to sort any field with just two simple scripts! Click the title or link to this article to view the video. View the full article
  4. What makes FileMaker development so fun is the variety of different functions and script steps. They provide an almost infinite number of combinations to solve a wide variety of technical problems. There isn't always just "one way to do it". So, what happens when you stop to think about a more recent feature in light of how you've "always done it before"? Like... sorting... for example. Have you always simply attached the Sort script step to your list view headers and called it a day? What if you could use just two simple scripts to provide single field sorting solution wide? This seems pretty cool since you can manage the sorting of all list views and be able to quickly add this feature to any given layout. Reusable code is a great thing. That's exactly what this video is all about. Taking advantage of lesser known features in order to create technical solutions which provide a high degree of leverage. Let's learn how to sort any field with just two simple scripts! Click the title or link to this article to view the video. View the full article
  5. Continuing on with the two part series about Narrow vs. Wide tables, this video will go into how to best filter your data, especially if you have a large amount. It will present the data within the structure we'd created within the first video. Knowing the impact of data operations isn't just limited to the structure of your tables. It's also about how much data is loaded and shown to the user based on what the user needs to see. If you have a relationship resulting in hundreds of thousands of possible records, it doesn't really make sense to show anything other than what the user really needs to see. If the user only needs to see 3 months of data then simply load the three months and allow the UI to provide options to adjust. That's exactly what we cover within this video. Let's learn how to limit what is shown within your narrow table structure. Click the title or link to this article to view the video. View the full article
  6. Continuing on with the two part series about Narrow vs. Wide tables, this video will go into how to best filter your data, especially if you have a large amount. It will present the data within the structure we'd created within the first video. Knowing the impact of data operations isn't just limited to the structure of your tables. It's also about how much data is loaded and shown to the user based on what the user needs to see. If you have a relationship resulting in hundreds of thousands of possible records, it doesn't really make sense to show anything other than what the user really needs to see. If the user only needs to see 3 months of data then simply load the three months and allow the UI to provide options to adjust. That's exactly what we cover within this video. Let's learn how to limit what is shown within your narrow table structure. Click the title or link to this article to view the video. View the full article
  7. Like any good craftsperson, you should know your tools and your methods for accomplishing things in the most efficient and best performing way. This is always most obvious when it comes to that every slowing FileMaker solution which started out innocently as a simple "helper" database. Then... it ended up being used for all kinds of things. Critical things even! It was thrown together based on how you mentally "see" the data and not how the data should have been structured. This is one of those painful lessons where you have to go in and retrofit the data to a new structure or make plans to migrate to an updated solution. In this video, I discuss the ever important topic of Narrow vs. Wide tables. It's a common problem in a large number of FileMaker solutions. I know because I've seen tables with field counts within the thousands. This just shouldn't be the case. FileMaker is an all-or-nothing data solution when it comes to records. If you have 1,000 fields, then FileMaker will give you all the data from all 1,000 fields. This is unlike SQL, where you only return the data you specifically ask for. With FileMaker, you have to plan your solution's data management much more carefully! Watch this video for a better understanding of how to make your tables more narrow. Click the title or link to this article to view the video. View the full article
  8. Like any good craftsperson, you should know your tools and your methods for accomplishing things in the most efficient and best performing way. This is always most obvious when it comes to that every slowing FileMaker solution which started out innocently as a simple "helper" database. Then... it ended up being used for all kinds of things. Critical things even! It was thrown together based on how you mentally "see" the data and not how the data should have been structured. This is one of those painful lessons where you have to go in and retrofit the data to a new structure or make plans to migrate to an updated solution. In this video, I discuss the ever important topic of Narrow vs. Wide tables. It's a common problem in a large number of FileMaker solutions. I know because I've seen tables with field counts within the thousands. This just shouldn't be the case. FileMaker is an all-or-nothing data solution when it comes to records. If you have 1,000 fields, then FileMaker will give you all the data from all 1,000 fields. This is unlike SQL, where you only return the data you specifically ask for. With FileMaker, you have to plan your solution's data management much more carefully! Watch this video for a better understanding of how to make your tables more narrow. Click the title or link to this article to view the video. View the full article
  9. It seems like it's taken decades for many businesses and government agencies to move from pushing paper into the digital age of transactions. Recently, I was reminded of this by heading into town hall and having to push a bit of paper myself. Banks and other financial institutions still actually offer paper options surprisingly. I guess being in the world of tech comes with its own biases. But, despite the seemingly slow adoption, the migration is still happening and more and more things are going pure digital. The real estate markets are finally making the switch to mostly digital and this means it's a great time to know how to take advantage of this fact. Fortunately, storing a PDF into FileMaker is as easy as drag-n-drop or the click of a button. Getting information out of that PDF still requires some type of external software. In the FileMaker market you'll find a variety of options including both free and paid options. In this video, I'll walk you through one of the easiest and freely available options for pulling PDF content into FileMaker. With this license-free options you'll never be scared of getting the exact content you wish to extract from any PDF. Click the title or link to this article to view the video. View the full article
  10. It seems like it's taken decades for many businesses and government agencies to move from pushing paper into the digital age of transactions. Recently, I was reminded of this by heading into town hall and having to push a bit of paper myself. Banks and other financial institutions still actually offer paper options surprisingly. I guess being in the world of tech comes with its own biases. But, despite the seemingly slow adoption, the migration is still happening and more and more things are going pure digital. The real estate markets are finally making the switch to mostly digital and this means it's a great time to know how to take advantage of this fact. Fortunately, storing a PDF into FileMaker is as easy as drag-n-drop or the click of a button. Getting information out of that PDF still requires some type of external software. In the FileMaker market you'll find a variety of options including both free and paid options. In this video, I'll walk you through one of the easiest and freely available options for pulling PDF content into FileMaker. With this license-free options you'll never be scared of getting the exact content you wish to extract from any PDF. Click the title or link to this article to view the video. View the full article
  11. Even if it's not a super interesting topic, and really only applies if you're managing a FileMaker server, it always pays to know how things work behind the scenes. If you've never used FileMaker's external authentication via LDAP then you'll want to watch this particular video. If you're creating any type of FileMaker solution which needs to know when your users both enter and exit the system, which especially applies to using external authentication, then you'll enjoy the super simple access log discussed within the video. There's even a great tip about adding a unique backdoor for emergency access to your files - should you forget your master password for Full Access. Remember, this may seem like a boring topic but it's critical information to have if you're going to be managing any type of complex solution with centralized access controls. Click the title or link to this article to view the video. View the full article
  12. Even if it's not a super interesting topic, and really only applies if you're managing a FileMaker server, it always pays to know how things work behind the scenes. If you've never used FileMaker's external authentication via LDAP then you'll want to watch this particular video. If you're creating any type of FileMaker solution which needs to know when your users both enter and exit the system, which especially applies to using external authentication, then you'll enjoy the super simple access log discussed within the video. There's even a great tip about adding a unique backdoor for emergency access to your files - should you forget your master password for Full Access. Remember, this may seem like a boring topic but it's critical information to have if you're going to be managing any type of complex solution with centralized access controls. Click the title or link to this article to view the video. View the full article
  13. Recently, having had a conversation with a fellow developer about a FileMaker theme potentially causing issues with slow performance, it was asked about how it's possible to update a theme. Whether you simply want to update existing styles and/or remove and add others, there's only a few critical things you need to remember about updating and migrating a theme. If you can get those few things right, then making any number of updates to your existing theme can be quite easy to accomplish. The great thing about updating a theme is that it can be accomplished in a completely separate copy of your live file. All you need to do is download the file from FileMaker Server and then make the desired changes/deletions/additions and then simply apply the updated theme onto the previous version. This migration can be done with minimal fuss provided you keep both the theme name and the theme styles named exactly the same. Needing to update your FileMaker theme for all your layouts? Watch this video if you'd like some insight into how you can go about migrating your theme from an older version to a newer version. Click the title or link to this article to view the video. View the full article
  14. Recently, having had a conversation with a fellow developer about a FileMaker theme potentially causing issues with slow performance, it was asked about how it's possible to update a theme. Whether you simply want to update existing styles and/or remove and add others, there's only a few critical things you need to remember about updating and migrating a theme. If you can get those few things right, then making any number of updates to your existing theme can be quite easy to accomplish. The great thing about updating a theme is that it can be accomplished in a completely separate copy of your live file. All you need to do is download the file from FileMaker Server and then make the desired changes/deletions/additions and then simply apply the updated theme onto the previous version. This migration can be done with minimal fuss provided you keep both the theme name and the theme styles named exactly the same. Needing to update your FileMaker theme for all your layouts? Watch this video if you'd like some insight into how you can go about migrating your theme from an older version to a newer version. Click the title or link to this article to view the video. View the full article
  15. FileMaker has had the ability to use an internal PDF writer since version 8. It has, however, not always had the ability to merge multiple PDFs into one master and make this work as seamlessly as possible. Being able to do this server side is a really BIG benefit! In this video, we take a look at a subscriber's question about a particular printed layout issue in conjunction with taking advantage of FileMaker's best possible output options. With the ability to Save Records As PDF we can certainly make the process much more streamlined and as easy as possible. If you need to generate a complex multipage PDF report then you'll find a lot of value in this video. We discuss what to do about page numbers and how to merge multiple PDF files into one single master. This video and technique file will get you a stronger familiarity with how to generate the type of PDF output you desire. 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.