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 f
Whether you’re just starting your business, or you’ve been established for quite some time, you’ll likely understand that networking plays a huge role in the success of your business. It’s also likely you can think of at least one professional relationship you have that has had a positive impact on your business. The term [...]
The post Networking Online – What’s the Etiquette? appeared first on The Scarpetta Group, Inc..
Afficher la totalité du billet
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 nee
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.
Remove the background from an image? Did you ever need to remove the background from an image? For example, maybe you have user photos in your FileMaker database and want all of the photos to be uniform for an ID. Or maybe a product photo that is too busy and it would [...]
The post Remove the Background? There’s an API for that? RemoveBG appeared first on The Scarpetta Group, Inc..
Afficher la totalité du billet
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