Welcome to our community, full of great ideas on developing your FileMaker solutions effectively,
for peer-to-peer support of the FileMaker Platform and related products and services.
Author’s note: Inevitable comparisons will be drawn between the new While function and the venerable CustomList custom function, which I wrote about at length several years ago. Preliminary testing indicates that CustomList is faster under certain circumstances and While is faster under others. In my opinion, both of them belong in your developer tool kit. […]
View the full article
The FileMaker Let function is your tool to make a calculation readable, well formatted and easy to debug. Let us discuss how it can be used.
The post Like a Boss: Let us Discuss the FileMaker Let Function appeared first on Geist Interactive.
View the full article
[ Edit: 3/16/2016 - With the help of some other people, we have been able to recover, or recreate some of the original images from original thread. ]
Security is always a big topic when it involves data, or people, or possessions. Recently, over on the FileMaker Community, there was a very beneficial discussion regarding security. Unfortunately, that discussion was the victim of a necessary action...and was deleted. It was deleted, because the discussion was tied to a video that, as was det
Hi all,
Today I'm happy to announce the release of Elemental for FileMaker. This is a free fully unlocked solution containing some cool user interface and design stuff that I hope you find useful and can incorporate into your own solutions.
You can grab a copy now at https://www.elemental-fm.com
In Elementals first version you'll find the following:
Avatars
Over 20 API integrations with avatar generators. These are uniquely generated based on a name y
The FileMaker Script Debugger is powerful. Its features are often overlooked. In this post we examine the buttons that control stepping through a script.
The post Like a Boss: Using the Script Debugger to its Full Potential appeared first on Geist Interactive.
View the full article
It's a curious question and the answer may be good or bad depending on your perspective. "Why doesn't FileMaker have a time picker?". It has a calendar widget for working with date fields, why not time values?
The solution to the problem, as is often the case, can be managed by simply creating your own picker. In fact, if you don't like FileMaker's desktop based date picker you can create any variation you desire based on being able to create any style of layout you can imagine. While the same
It’s been a few years since we last had a tips ‘n’ tricks article here at FileMaker Hacks… long enough for some new items to accumulate in the old developer bag of tricks. (If you like this sort of thing, you may also want to check out part 1 and part 2.) Some of these […]
View the full article
Unless you've got a billion dollars to send out tens of thousands of cars with specially fitted technology mounted on their roofs; and, you can send them all across the planet, then you'll likely need to rely on mapping data from a third party.
So, here we go with learning how we can leverage Google Maps APIs within FileMaker. This video will cover the essential knowledge you need in order to make the requests about geolocations whether they be latitude longitude coordinates or an address.
As
For many professionals, their calendar is an important tool that helps keep things running smoothly.
In this article we cover how to integrate your Outlook calendar with FileMaker to keep you staying on top of your efficiency game!
Be sure to check out our tutorial: https://dbservices.com/articles/filemaker-outlook-calendar-integration/
dbservices.com
Clients are always asking me why the contents of portals do not duplicate along with a record. It makes sense. Portal data looks like it's part of the parent record so it should duplicate just like the local fields, right? After explaining how relationships work, the client still wants the related data to duplicate. The great thing is, the script isn't that difficult to write. There's just a few gotchas, opportunities for efficiency and, of course, the patented Philosophy of FileMaker considerat
Clients are always asking me why the contents of portals do not duplicate along with a record. It makes sense. Portal data looks like it's part of the parent record so it should duplicate just like the local fields, right? After explaining how relationships work, the client still wants the related data to duplicate. The great thing is, the script isn't that difficult to write. There's just a few gotchas, opportunities for efficiency and, of course, the patented Philosophy of FileMaker considerat
Aux bords du lac de Paladru ( Isère ) on trouve d’autres trésors que ceux laissés par les chevaliers paysans de l’an mil… On y dégote par exemple des développeurs FileMaker chevronnés ! En cette fin d’année 2018, nous sommes ravis d’accueillir dans l’équipe de 1-more-thing Yann Trauchessec, un développeur multi-langage avec comme prédilection celui […]
Cet article Bienvenue Yann ! est apparu en premier sur 1-more-thing.
View the full article
We at Geist Interactive, Barbara, Dave, Lance, Jeremy and Todd (and the ghosts) wish everyone a happy holiday. No matter your celebration plans this season, we wish it to be full of warmth and love and joy. Thank you for coming along with us as we continue to push what is possible in FileMaker and […]
The post Happy Holidays & End Of Year Sale appeared first on Geist Interactive.
View the full article
If it's not obvious by the types of videos I produce, one of my most favorite areas of software development and design is the user interface. It's where the real test of your software happens. A user either "gets it" or not. If they don't, then you're back to the drawing board.
Of course, there's always the learning curve which is present for anyone, but if you can create something that has less of a learning curve, then you feel like a winner.
In this video, I cover a wide variety of topics r
In years past many of you FileMaker people have supported our non-profit learning center, One Spark Academy, with an end of the year tax-deductible donation. We are very grateful. This year, due to some terrible tragedies, we need your help more than ever.
The post You Can Help. One Spark Fundraiser appeared first on Geist Interactive.
View the full article
Our JSONAdditions.fmp12 file provides additional useful custom functions. One of them is a FileMaker filtering JSON function: JSON.FilterByExpression
The post The FileMaker Filtering JSON function appeared first on Geist Interactive.
View the full article
Recently we’ve looked at two methods to generate a “faux” subsummary to address a shortcoming of FileMaker native subsummaries… namely that in a multipage report you can have orphaned entries at the top of a given page with no indication of what parent entity they belong to. The methods were documented here: Conditional Summary Report […]
View the full article
Script triggers often solve problems that otherwise couldn't be overcome. While script triggers are incredibly useful, don't abuse this feature or you may encounter script conflicts. Alternatives to script triggers are auto-enter calculations, manually run scripts and many other FileMaker features. Become familiar with every tool on your belt so you can choose the right feature for the job at hand. Hesitate to use triggers but when they solve the problem better than any other approach, use their
Script triggers often solve problems that otherwise couldn't be overcome. While script triggers are incredibly useful, don't abuse this feature or you may encounter script conflicts. Alternatives to script triggers are auto-enter calculations, manually run scripts and many other FileMaker features. Become familiar with every tool on your belt so you can choose the right feature for the job at hand. Hesitate to use triggers but when they solve the problem better than any other approach, use their
These are often asked questions regarding setting up a new FileMaker database system. "How can I limit when the user can enter data into the field?" Or, the alternative, "Once the user enters data, how can I make sure they don't change it unless I want them to?"
Both of these types of questions can be answered using a variety of methods. The core to understanding their answers is that there's really only only two methods for limiting field access. One is controlling the display of the field and
Is your site running an older version of PHP? Chances are … yes. According to W3Tech, 76.6% of websites are running a version of 5X. This December, support ends for versions 5.6 to 7.0, pushing them to end of life. This means no more security updates! What does this mean for you if your site is still running an older version of PHP? It means that if a new security issue is found it will not be fixed going forward. So, if you get hacked there may not be a simple fix. You can always roll back, b
Is your site running an older version of PHP? Chances are … yes. According to W3Tech, 76.6% of websites are running a version of 5X. This December, support ends for versions 5.6 to 7.0, pushing them to end of life. This means no more security updates! What does this mean for you if your site is still running an older version of PHP? It means that if a new security issue is found it will not be fixed going forward. So, if you get hacked there may not be a simple fix. You can always roll back, b
One of the nicest additions FileMaker made awhile back was within an area you wouldn't quite expect. It was within the Summary functions that FileMaker added a simple new option named ListOf. This happened with FileMaker version 13 and this one type of summary field can be use for so many different things within the user interface that it's quite invaluable for driving all kinds of user feedback.
With a ListOf summary field, you can control the content of a custom portal, grab data necessary fo
Using FileMaker, your data, and a word processor such as Microsoft Word, you are able to reduce the amount of double data entry as well as human error by using Mail Merge.
In this article, we cover how you can achieve that goal within your FileMaker solution: https://dbservices.com/articles/mail-merge-with-filemaker/
dbservices.com
WordPress Website Redesign Boosts Placement Firm’s Candidate & Recruiter Traffic
Responsive Design & Custom Plugins Optimize Century Group’s eXternal & Internal User eXperiences
When businesses in Southern California, the Bay Area or Denver need a new CFO, controller, accountant or payroll coordinator, they turn to Century Group for help in recruiting the right candidate. Likewise, job-seeking finance and accounting professionals rely on Century Group when they’re on the h
Phantom fields can haunt your custom app. FMPerception can hunt those down for you, showing you those lingering fields on a layout.
The post FMPerception: The Phantom Field Hunter appeared first on Geist Interactive.
View the full article
Just about every database contains at least one date, time and timestamp field. Just think about the housekeeping fields for starters. Every table should contain a date and time when a record was created and modified to track record maintenance. I also add manually entered and scripted date fields to almost every table to track when events occur. It ends up being a lot of date fields! While most of your fields will be text, date fields are more commonly calculated and therefore more important to
Just about every database contains at least one date, time and timestamp field. Just think about the housekeeping fields for starters. Every table should contain a date and time when a record was created and modified to track record maintenance. I also add manually entered and scripted date fields to almost every table to track when events occur. It ends up being a lot of date fields! While most of your fields will be text, date fields are more commonly calculated and therefore more important to
