Jump to content

FileMaker Magazine

Moderators
  • Content Count

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

2 Followers

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. One of the best feelings for any database developer is knowing that duplicate data simply can't sneak into your solution. You've got clean data such that when you search for a specific email address you know there's only one and it belongs to the right entity. In the associated video and sample file you'll get all the details for how you can use FileMaker's Unique value validation option. You'll see how you can prevent FileMaker from showing it's annoying dialog box which uses the name of the field when a duplicate is entered. Additionally, you'll be able to execute your own script when the v
  2. One of the best feelings for any database developer is knowing that duplicate data simply can't sneak into your solution. You've got clean data such that when you search for a specific email address you know there's only one and it belongs to the right entity. In the associated video and sample file you'll get all the details for how you can use FileMaker's Unique value validation option. You'll see how you can prevent FileMaker from showing it's annoying dialog box which uses the name of the field when a duplicate is entered. Additionally, you'll be able to execute your own script when the v
  3. Pretty much all over the world you'll find technology which can scan barcodes. Smartphones with cameras just waiting to scan either their very first, or even their 1000th barcode scan. With just over a decade since the first iPhone came out, it's pretty hard to not find a use case where a barcode can help you retire some antiquated manual process. Barcodes can be used almost anywhere to make faster and/or easier solutions. Given that FileMaker Go supports all major barcode types, you simply need a method for creating your own barcodes within FileMaker. In 2017 I created an article about using
  4. Pretty much all over the world you'll find technology which can scan barcodes. Smartphones with cameras just waiting to scan either their very first, or even their 1000th barcode scan. With just over a decade since the first iPhone came out, it's pretty hard to not find a use case where a barcode can help you retire some antiquated manual process. Barcodes can be used almost anywhere to make faster and/or easier solutions. Given that FileMaker Go supports all major barcode types, you simply need a method for creating your own barcodes within FileMaker. In 2017 I created an article about using
  5. Out of the box, FileMaker is a really easy solution for inputing data and simply finding the results you want when searching that data. There are, however, times when you need to break away from FileMaker's "solve all" solution of case insensitive searching. Times where you simply want to present some data within your user interface - without setting up extra relationships or fields. Or, those times when you simply need to search based on the case sensitivity of the data within a field. In order to accomplish this, there are pretty much two different methods. In this video I show you how to
  6. Out of the box, FileMaker is a really easy solution for inputing data and simply finding the results you want when searching that data. There are, however, times when you need to break away from FileMaker's "solve all" solution of case insensitive searching. Times where you simply want to present some data within your user interface - without setting up extra relationships or fields. Or, those times when you simply need to search based on the case sensitivity of the data within a field. In order to accomplish this, there are pretty much two different methods. In this video I show you how to
  7. Some of my most favorite moments, when working with technology, are when you see the result of a few lines of code do what used to take hours and hours of work. Seeing the fruits of knowledge labor which replaces a lot of manual labor. It's glorious! The example I'm mentally referencing is any time you need to extract some content from a web page and it's literally SITTING RIGHT THERE in front of your face and you end up using your precious time doing the good old copy and paste. Every day there are SO many mistakes made by human error because of duplicate entry that if the data is in digita
  8. Some of my most favorite moments, when working with technology, are when you see the result of a few lines of code do what used to take hours and hours of work. Seeing the fruits of knowledge labor which replaces a lot of manual labor. It's glorious! The example I'm mentally referencing is any time you need to extract some content from a web page and it's literally SITTING RIGHT THERE in front of your face and you end up using your precious time doing the good old copy and paste. Every day there are SO many mistakes made by human error because of duplicate entry that if the data is in digita
  9. Who doesn't want to know how long something takes? It's not like we, as the busy bees we are, have all the time in the world - right? Well, how about some convenient progress information. One of the most common procedures within all of computing is to cycle or iterate over a set of something. In FileMaker, this comes in the form of records. A record loop is one of the most common things you'll ever do within FileMaker. Setting a field value to something else across a range of records? You'll likely use a record loop. So, what's the easiest way show the progress of that record loop? It's curr
  10. Who doesn't want to know how long something takes? It's not like we, as the busy bees we are, have all the time in the world - right? Well, how about some convenient progress information. One of the most common procedures within all of computing is to cycle or iterate over a set of something. In FileMaker, this comes in the form of records. A record loop is one of the most common things you'll ever do within FileMaker. Setting a field value to something else across a range of records? You'll likely use a record loop. So, what's the easiest way show the progress of that record loop? It's curr
  11. FileMaker Pro provides a variety of methods for extracting your data from its database. From memory, we have standard relationships and calculated concatenations, the Copy All Records script step, scripted data loops and using the ExecuteSQL function. In FileMaker 19, we're provided with yet one more method for pulling data out of the system. The Execute FileMaker Data API script step allows us to use what was formerly available only from outside of FileMaker Pro via a url. Now, within our scripts, we can use this fast retrieval method for extracting data in the popular and common JSON format
  12. FileMaker Pro provides a variety of methods for extracting your data from its database. From memory, we have standard relationships and calculated concatenations, the Copy All Records script step, scripted data loops and using the ExecuteSQL function. In FileMaker 19, we're provided with yet one more method for pulling data out of the system. The Execute FileMaker Data API script step allows us to use what was formerly available only from outside of FileMaker Pro via a url. Now, within our scripts, we can use this fast retrieval method for extracting data in the popular and common JSON format
  13. There's a great feeling about writing functional code when it's something you can rely on. You know it's just going to work. Which, for some import routines, doesn't always feel this way. Sometimes the import may fail or you can't figure out how to make it work. Columns may get renamed, they may be shifted around and vary or you may be importing from multiple different providers. If you're consolidating data from multiple sources or you have a situation where you need to manipulate the data before the import, then we've got a great solution for you. Not only is this video about server side i
  14. There's a great feeling about writing functional code when it's something you can rely on. You know it's just going to work. Which, for some import routines, doesn't always feel this way. Sometimes the import may fail or you can't figure out how to make it work. Columns may get renamed, they may be shifted around and vary or you may be importing from multiple different providers. If you're consolidating data from multiple sources or you have a situation where you need to manipulate the data before the import, then we've got a great solution for you. Not only is this video about server side i
  15. Every trade has its own tips for making your work go faster or happen more easily. During this holiday season I thought it would be great to bring you 12 Tips of Developing in FileMaker Pro. So, I opened FileMaker and stared at the blank screen of a new file thinking about the things that tend to help me out the most. I pulled down a CSV file from Data.gov and just let the tips flow out from there. I hope, with this list of 12 tips, you'll pick up some productivity enhancements that will carry you forward into the new year! Happy Holidays! Click the title or link to this article to view the
×
×
  • Create New...

Important Information

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