Jump to content
  • entries
    284
  • comments
    3
  • views
    15,159

Entries in this blog

 

Custom Function Database - Part 2

In the world of software development, you’re basically taking things apart. Adding data here, taking away data there and remixing things. Simply put, it’s all just a matter of how the data needs to be presented to those who wish to see it. In the first video in this series, we did the data collection and now we need to do something with that data. In most cases, you’re typically going to be parsing data if it’s not in a format ready to be stored. So, we need to parse the custom functions and th

FileMaker Magazine

FileMaker Magazine

 

Custom Function Database - Part 1

Developing software is simply a matter of solving a problem by organizing and collecting data in a manner which makes the data useful to the end user. So, we’re just a bunch of data organizers and presenters. One of the biggest benefits to a software developer is their known resources. There are tons of resources available to us every day. Sometimes, it’s a matter of knowing where those resources are and others it’s a matter of taking advantage of what we already have. In this video, I start a

FileMaker Magazine

FileMaker Magazine

 

Custom Function Database - Part 1

Developing software is simply a matter of solving a problem by organizing and collecting data in a manner which makes the data useful to the end user. So, we’re just a bunch of data organizers and presenters. One of the biggest benefits to a software developer is their known resources. There are tons of resources available to us every day. Sometimes, it’s a matter of knowing where those resources are and others it’s a matter of taking advantage of what we already have. In this video, I start a

FileMaker Magazine

FileMaker Magazine

 

Scripting Find Mode

Each time a new version of FileMaker is released there are more features and more information about what’s possible with the software. More functionality means more learning in order to take advantage of those features. There are, however, core features which should be known by all developers. This includes knowing how to script Find mode and building an interface around the search functionality. Knowing how to script an omitted find request may not be super obvious unless you think of Find mod

FileMaker Magazine

FileMaker Magazine

 

Scripting Find Mode

Each time a new version of FileMaker is released there are more features and more information about what’s possible with the software. More functionality means more learning in order to take advantage of those features. There are, however, core features which should be known by all developers. This includes knowing how to script Find mode and building an interface around the search functionality. Knowing how to script an omitted find request may not be super obvious unless you think of Find mod

FileMaker Magazine

FileMaker Magazine

 

Portal Filtering Options

It’s so easy with FileMaker, to simply add, add and add some more - especially to the Relationship Graph. You get the request to see a different set of data, and you hop right to it by adding a new relationship and table occurrence. Wait a second! Each time you add something new to your FileMaker solution you’re making an agreement with yourself that you’re willing to maintain an ever growing garden of technological spaghetti. With a bit of planning and know-how, you can easily satisfy a growin

FileMaker Magazine

FileMaker Magazine

 

Portal Filtering Options

It’s so easy with FileMaker, to simply add, add and add some more - especially to the Relationship Graph. You get the request to see a different set of data, and you hop right to it by adding a new relationship and table occurrence. Wait a second! Each time you add something new to your FileMaker solution you’re making an agreement with yourself that you’re willing to maintain an ever growing garden of technological spaghetti. With a bit of planning and know-how, you can easily satisfy a growin

FileMaker Magazine

FileMaker Magazine

 

Top 5 Reasons to know the Let() function

I can certainly understand why the Let function isn’t the first thing newer FileMaker developers decide to learn. First, it’s a very complex looking function, and it isn’t inherently obvious in terms of the benefits you’ll receive for knowing it. And, second, it likely just doesn’t show up on the “must-know” radar until you see it used in an effective way. However, the second you realize its true value, it becomes a must use function. I actually can’t see how someone would develop in FileMaker

FileMaker Magazine

FileMaker Magazine

 

Top 5 Reasons to know the Let() function

I can certainly understand why the Let function isn’t the first thing newer FileMaker developers decide to learn. First, it’s a very complex looking function, and it isn’t inherently obvious in terms of the benefits you’ll receive for knowing it. And, second, it likely just doesn’t show up on the “must-know” radar until you see it used in an effective way. However, the second you realize its true value, it becomes a must use function. I actually can’t see how someone would develop in FileMaker

FileMaker Magazine

FileMaker Magazine

 

Relationship Based Data Filtering

For some developers who are new to FileMaker, they may not come from a background of having worked with SQL or some other query language. Creating joins on the fly, as data is needed, is a foreign concept. Yet, when you create a relationship within the Relationship Graph, you’re creating a join which will be permanent for the life of the file or until deleted. This isn’t the case with SQL based solutions. With FileMaker, the notion of joins comes in the form of persistent relationships within t

FileMaker Magazine

FileMaker Magazine

 

Relationship Based Data Filtering

For some developers who are new to FileMaker, they may not come from a background of having worked with SQL or some other query language. Creating joins on the fly, as data is needed, is a foreign concept. Yet, when you create a relationship within the Relationship Graph, you’re creating a join which will be permanent for the life of the file or until deleted. This isn’t the case with SQL based solutions. With FileMaker, the notion of joins comes in the form of persistent relationships within t

FileMaker Magazine

FileMaker Magazine

 

Managing Settings & Preferences

With most software, especially a growing software solution like a FileMaker database, you inevitably end up with settings and preferences. These settings may be used for the solution itself, certain features or even user specific settings. No matter what the settings or preferences, you often need an easy way to manage and access them. In this video, I showcase a method for handling settings which may be required for a server side script or client side operations. No matter when or how the sett

FileMaker Magazine

FileMaker Magazine

 

Managing Settings & Preferences

With most software, especially a growing software solution like a FileMaker database, you inevitably end up with settings and preferences. These settings may be used for the solution itself, certain features or even user specific settings. No matter what the settings or preferences, you often need an easy way to manage and access them. In this video, I showcase a method for handling settings which may be required for a server side script or client side operations. No matter when or how the sett

FileMaker Magazine

FileMaker Magazine

 

Single Portal Drill Down

We’ve all been inspired by the creativity and wide array of UI widgets which have come from the mobile side of computing. In fact, what you present and when/how you present it always offers the opportunity to find new ways if doing so. The whole swipe down to “rubber band” a refresh was a breath of fresh UI air. When presenting users with options, one of the more common methods for presenting these is using a Pop-up menu. After making a selection in an initial menu a second menu presents option

FileMaker Magazine

FileMaker Magazine

 

Single Portal Drill Down

We’ve all been inspired by the creativity and wide array of UI widgets which have come from the mobile side of computing. In fact, what you present and when/how you present it always offers the opportunity to find new ways if doing so. The whole swipe down to “rubber band” a refresh was a breath of fresh UI air. When presenting users with options, one of the more common methods for presenting these is using a Pop-up menu. After making a selection in an initial menu a second menu presents option

FileMaker Magazine

FileMaker Magazine

 

Photo capture & manipulation

If you’re capturing photos with an iPhone or iPad and FileMaker Go, then everything should work just fine as long as you do everything within FileMaker Pro. You see, FileMaker takes care of presenting the user the picture in the proper way. But, this isn’t how the photo is stored. As soon as you need to do any type of manipulation to the photo, then you’re headed for a shock when the picture turns out upside down or sideways. This video discusses what you need to know in order to manipulate ph

FileMaker Magazine

FileMaker Magazine

 

Photo capture & manipulation

If you’re capturing photos with an iPhone or iPad and FileMaker Go, then everything should work just fine as long as you do everything within FileMaker Pro. You see, FileMaker takes care of presenting the user the picture in the proper way. But, this isn’t how the photo is stored. As soon as you need to do any type of manipulation to the photo, then you’re headed for a shock when the picture turns out upside down or sideways. This video discusses what you need to know in order to manipulate ph

FileMaker Magazine

FileMaker Magazine

 

Using hashes for validation

Earlier in the year I released a video about using Google Forms in order to capture and then import data into FileMaker Pro. The code I was personally using was a bit more advanced than what I wanted to show at that time, so I simplified the process. Having implemented, and used, many more Google Forms since that time, and knowing that I was exercising a great degree of control over the import process, I decided to reveal it all. So, in this video I showcase the method I use to verify that an

FileMaker Magazine

FileMaker Magazine

 

Using hashes for validation

Earlier in the year I released a video about using Google Forms in order to capture and then import data into FileMaker Pro. The code I was personally using was a bit more advanced than what I wanted to show at that time, so I simplified the process. Having implemented, and used, many more Google Forms since that time, and knowing that I was exercising a great degree of control over the import process, I decided to reveal it all. So, in this video I showcase the method I use to verify that an

FileMaker Magazine

FileMaker Magazine

 

Creative Layout Design

While recently teaching the layout/design portion of an in-person FileMaker training course, I found myself showing off one of the features which FileMaker has had since version 12. It’s an often overlooked feature which can be used quite creatively when you know how it works. It’s the Layout Background style of the layout theme. When you understand the order in which FileMaker displays things, you’re free to create nice modern looking layout designs. Further, when you combine this with knowled

FileMaker Magazine

FileMaker Magazine

 

Creative Layout Design

While recently teaching the layout/design portion of an in-person FileMaker training course, I found myself showing off one of the features which FileMaker has had since version 12. It’s an often overlooked feature which can be used quite creatively when you know how it works. It’s the Layout Background style of the layout theme. When you understand the order in which FileMaker displays things, you’re free to create nice modern looking layout designs. Further, when you combine this with knowled

FileMaker Magazine

FileMaker Magazine

 

Graph Management Techniques

When was the last time you opened the Relationship Graph and heard that little voice say “Wow, you’ve gotta clean this up!”? Maybe it was yesterday, maybe it was just a few moments ago. Whenever the voices come, it’s a pretty easy task to accomplish when you apply some solid understanding to how the graph works and what it represents in the whole of your solution. If code could write itself, then organization would never be necessary because no one would need to maintain or revise it. It would

FileMaker Magazine

FileMaker Magazine

 

Graph Management Techniques

When was the last time you opened the Relationship Graph and heard that little voice say “Wow, you’ve gotta clean this up!”? Maybe it was yesterday, maybe it was just a few moments ago. Whenever the voices come, it’s a pretty easy task to accomplish when you apply some solid understanding to how the graph works and what it represents in the whole of your solution. If code could write itself, then organization would never be necessary because no one would need to maintain or revise it. It would

FileMaker Magazine

FileMaker Magazine

×
×
  • Create New...

Important Information

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