Jump to content


Successful UI Design - Part 2

FileMaker themes are simply a collection of the popular CSS standards plus a few extra attributes which are FileMaker specific. Each element on your FileMaker layouts is defined by these CSS settings. They can be seen when extracting them from the clipboard, and if you know the right location to retrieve and store them, can be defined by any enthusiastic developer. When FileMaker, now Claris, first introduced themes they likely had the intention of allowing users and/or third parties to create

When 2 is greater than 10

Today we’re going to take a quick look at a potential “gotcha” that can crop up when doing numeric comparisons. Jason DeLooze and I discussed the general behavior back in 2011 (Space Is The Place), but this time around I want to focus on one particular set of circumstances where the problem can arise. At… Continue reading When 2 is greater than 10 Afficher la totalité du billet

Successful UI Design

How easy is it for you to design the user interface of your FileMaker database? Are there any tips you have which makes the process easier? If so, then I would love to hear them! In this video, I'm providing you with the best information I have about a successful UI design process. It's the opening video to a deep dive about how themes actually work within FileMaker. I start with a blank layout and go over the major areas of what I consider when starting the design of a new database or a re-ski

Top 5 inspirational quotes to help you get things done

This month we’ve been looking at how we manage our time more efficiently in order to be more productive, you can check out our blog post on this – Practical tips for improving time management. But sometimes, your own will and way just doesn’t do the trick, so we’ve come up with a list of [...] The post Top 5 inspirational quotes to help you get things done appeared first on The Scarpetta Group, Inc.. Afficher la totalité du billet

Fun with SQL Joins and Currency Formatting

Demo file: sql-join-fun-etc.zip requires FM 18 or later. Recently I was asked to create a mini-report combining data from a pair of related tables via ExecuteSQL. This provided an opportunity to think about SQL joins, and also to come up with a way to apply currency formatting to dollar amounts in the SQL query result,… Continue reading Fun with SQL Joins and Currency Formatting Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

Catching Duplicates with Validation

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

Networking Online – What’s the Etiquette?

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

Securing QR Barcodes

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

Case Sensitive Searching

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 ord

Remove the Background? There’s an API for that? RemoveBG

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

Native Web Scraping with JavaScript

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

File IDs, Table IDs and Field-Level Schema

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

FileMaker Hacks

FileMaker Hacks

Card Window Progress Bars ( updated )

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

Execute FileMaker Data API

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

What is Filemaker Used for in Business for Improvements?

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

Server Side Importing

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

FileMaker Magazine

FileMaker Magazine

Set Variable By Name Revisited

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

FileMaker Hacks

FileMaker Hacks

12 Tips for Developing in FileMaker Pro

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

FileMaker Magazine

FileMaker Magazine

Organizing Images

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

FileMaker Magazine

FileMaker Magazine

Les bases de données aux temps de dinosaures 🦖🦕

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. Lien LinkedIn

Jérémie Gimenez

Jérémie Gimenez in Formation

Validating JSON for Scripts

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

FileMaker Magazine

FileMaker Magazine

Business Trends for 2021

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

The Scarpetta Group

The Scarpetta Group

Christmas Gifts for Tech Geeks

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

The Scarpetta Group

The Scarpetta Group

  • Create New...