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.
[ 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
Free webinar introducing Karbon our free application framework for building ambitious custom business applications. If you are interested in using the FileMaker Workplace Innovation Platform at a high level you'll probably want to see what we have cooked up.
The post Karbon Webinar – Getting Started appeared first on Geist Interactive.
View the full article
In the past year and a half here at Geist Interactive, I’ve been tasked with some development work that involves connecting to various APIs. I’ve written modules for clients that get definitions, other forms, synonyms and antonyms, hypernyms and hyponyms of a term from the client’s internal dictionary and such public dictionaries such as Oxford […]
The post HTTP Request: I don’t know how, but it works appeared first on Geist Interactive.
View the full article
For the first time, DB Services has been ranked #3494 on the annual Inc. 5000 list, which ranks the country’s “fastest-growing innovators” based on overall revenue growth over a three-year period. The Inc. 5000 list has brought attention to America’s growing private businesses since 1982.
DB Services now joins the ranks of other Inc. 5000 list alumni such as Facebook, Zappos, Pandora, and others. DB Services is top ranked FileMaker Platinum Business Alliance Partner on the 2019 Inc. 5000 li
FileMaker offers many different options for charting, but if you need a chart that is not available in FileMaker, you should consider using Google Charts. Google Charts is a free Javascript framework that can be used in conjunction with web viewers in FileMaker to extend your charting capabilities: https://dbservices.com/articles/google-charts-in-filemaker/
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
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
Hi all,
Back with another article this time all about Modal Dialogs. Here we present a technique for modal dialogs we have used at Digital Fusion for over 10 years, and it still holds up. This method allows us to initiate modal processes from within an originating script, and have our modal process return its result (generally an ID, or an action followed by a resulting ID) back to the originating script in order to continue its execution. It's a nice simple scripting framework that works g
Importing data is a process that deserves a lot of careful thought. In this post, we review the concept of a target table.
The post Like a Boss: FileMaker Data Import–The Target Table appeared first on Geist Interactive.
View the full article
What would our world be if we didn't have list views? They're the ubiquitous method for viewing a selection of items in relation to each other. In FileMaker, you can sort them, filter them, apply conditional formatting and basically present your data however you wish. Heck, most of the smart phone revolution revolves around a list view. A list of data, a list of settings, a list of options, a list of pretty much anything and "the list" goes on an on.
There are, however, a number of settings wit
What's more fun than solving problems in FileMaker? Well hop on board Advent of Code 2018 as we innovate for fun. Read here to learn more about it.
The post Advent of Code 2018: Innovation for fun appeared first on Geist Interactive.
View the full article
Bien plus que celle des feuilles mortes, octobre, est pour la communauté FileMaker la saison des conférences européennes. L’équipe de 1-more-thing était bien évidemment de la partie pour y assister et y contribuer en tant qu’orateur. Au FM Summit de Gand, Andries nous emmena à la découverte de la nouvelle fonctionnalité de la version 17 […]
Cet article La saison des conférences est apparu en premier sur 1-more-thing.
View the full article
