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 the
Demo file: file ids, table ids and field-level schema.zip (requires FM 18 or later) INTRODUCTION Recently I was asked to help document a FileMaker solution by creating and populating a “schema” table as per the above screen shot. One of the requirements was to programmatically determine internal ID numbers for the file and for the… Continue reading File IDs, Table IDs and Field-Level Schema Afficher la totalité du billet
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 l
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 scri
Do you have a hard time finding the right tools for your business?
What makes FileMaker a perfect solution is that it is a powerful and user-friendly platform with an affordable price. But in which fields and how can you use it? And, what’s more important, what FileMaker really is? Keep reading and find out how your business can benefit from using this flexible tool.
What is Filemaker?
Although its range of functions is extremely wide, FileMaker is a database - primarily, a softwa
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 bef
Demo file: set-variable-by-name-v2.zip (requires FM 16 or later) INTRODUCTION You’ve probably heard the old joke that goes… Patient: Doc, it hurts when I do this. Doctor: Don’t do that. Perhaps you’re also familiar with the FileMaker equivalent? Developer: It hurts when I try to assign certain variable names. FileMaker: Don’t do that. Or how about… Continue reading Set Variable By Name Revisited Afficher la totalité du billet
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
With a handful of simple scripts and just a few fields, you can easily accomplish some powerful image organization both inside and outside of FileMaker. In this video, we take a look at how FileMaker can be used to organize a collection of images. This is prior to sending them out or making them available for a web server to host them.
If your FileMaker solution needs to work with images used for verification or any form of media communication, then learning how you can make FileMaker bend to y
Chères consœurs, confrères,
Je vous partage cette petite astuce de formation, que j'utilise avec succès depuis 7 ans : le souvenir de la gentille dame de la bibliothèque, qui cherchait des informations dans ses armoires métalliques…
Non, ceci ne nous rajeunit pas ! 😁
Réjouissons-nous cependant d'avoir connu cette époque, car elle nous aide, et elle aide beaucoup de personnes à saisir le principe de base des bases de données relationnelles, et donc de FileMaker.
Using JSON for passing multiple parameters can be a real life saver. Because JSON keeps all individual parameters separate from each other, you can pass pretty much any type of data except for container data - although you can pass a reference to a container easily enough. Your parameters can also have as many levels as necessary and the JSON can easily be modified as it moves from script to script.
When writing a complex and large collection of scripts, you eventually hit errors and issues. Yo
Business Trends 2021 Wow, 2020, just wow! So many changes in the world and very obvious changes to the way in which businesses operate. How long will these changes last? Has the way in which we work changed forever? With so much uncertainty, it’s comforting to know that predictable emerging trends will see us [...]
The post Business Trends for 2021 appeared first on The Scarpetta Group, Inc..
Afficher la totalité du billet
It’s hard for those of us who aren’t in the know, to buy for those who are… so with Christmas 2020 just around the corner, we’ve compiled our top 8 favorite Christmas gifts for the tech geek in your life. Starting off with something super relevant, it’s the UVC Sterilizer Box with Wireless Charger. [...]
The post Christmas Gifts for Tech Geeks appeared first on The Scarpetta Group, Inc..
Afficher la totalité du billet
This versatile function offers quite a bit of value to any developer’s toolkit. It gives us the ability to interrogate the state of different layout objects (also called introspection) which allows us to make our calculations and scripts smarter. Today we’re going to just focus on a one of the options, the attributeName parameter to take a look at some interesting behavior that could be leveraged as another tool in our developer toolbelt.
objectName – in order to use this
FileMaker natively provides us with some really nice tools for user feedback. We can use the Show Custom Dialog or even create a dedicated dialog using a Card Window and Layout.
There are, however, times when you need something a little more subtle. Just a simple message on screen will often suffice. The next question is whether you need the user to interact with that message or not. The solution is simply to provide both options of course.
In this video and technique file, we explore a super
During agile development in FileMaker, sometimes you may notice an unwanted performance difference after adding a new feature, or display a new field to a layout. In this blog, I’d like to address what I have found to be the most likely culprits of the slow and unwanted Find or Sort dialogs on FileMaker layouts: summary fields and “unstored calculations”.
Inside the storage options of the calculation field definition is where developers decide if a calculation is stored or unstored
Demo file: a-value-list-experiment.zip Note 1: today’s demo is recycled from the one that accompanied Virtual Portal, part 2. All we care about today is how we assign the parent company; the remainder can be ignored. Note 2: if you’re unclear on value list basics, check out Thinking About Value Lists, part 1. “I want it… Continue reading A Value List Experiment Afficher la totalité du billet
The wonderful thing about creating software is it feels like you're able to create your own universe. You're the master of that universe and how it functions and reacts to its users. It's a very empowering feeling to know you can direct and control data in a way that makes it useful to others.
When considering all the directions that software can take there's always that simple fact that different people like different things. Heck, someone buys the Rhubarb from the grocery store - because they
If there’s one thing that can stop a sale dead in its tracks, it’s an objection. There are always going to be reasons your potential customers hold back from purchasing from you, and you can be one step ahead if you figure out these possible objections beforehand and address them in your website FAQs. [...] The post What are your customers’ pain points? appeared first on The Scarpetta Group, Inc.. Afficher la totalité du billet
All businesses have a target audience they want to reach, that much is obvious, but why it’s so important as well as how to define your target consumer, may be less so. Whether you’re offering a product or service, as a business owner, you’re going to want to make the most out of your [...] The post Know your audience appeared first on The Scarpetta Group, Inc.. Afficher la totalité du billet
A common feature I like to provide on my FileMaker list view layouts is clickable headers that sort records based on that column. Realistically, you don’t always have the luxury of being in a simple 1 table list view. In this blog, I will walk through a consistent way to dynamically sort related data in portals, using the column headers.
I would like to preface this blog by saying this is not a concept I invented. It was taught the concept from a coworker – who learned it from a blog or
Overview of when it would be beneficial to use abstraction in FileMaker
Sometimes you can benefit from a method called abstraction where you use what’s called “indirection.” Indirection is a way that you can automatically iterate through a series of steps like set variable or set field.
For instance, let’s say you needed to bring the contents of one set of fields in a table and create new related records in another, a process very common when dealing with legacy app data after import
Portals are wonderful tools for showing related data relevant to what your solution is solving. Sometimes, however, there's a trick to getting them to show exactly what you want. The combination of functions required may not always be obvious and it can be hard to achieve the desired result.
Essentially, you have to know how to extract the specific key values which allow you to filter only the desired rows. In this video, I walk through all the specifics of creating a custom function which allo