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
Viewing Microsoft Office files directly in FileMaker has always been a real headache for developers, until now. In this article we demonstrate how to easily use Microsoft Offices online app viewer tool to view your office documents directly in FileMaker. We also talk about Google's similar offering, and how files can be easily placed online for viewing using the file.io service.
Check out the article and accompanying example file at the bottom of the article.
Read the article here
When mobile devices first became prevalent over a decade ago, it was a pretty easy process to design for both mobile and desktop. You just made one layout for each respective device. There weren't as many variations as there is now.
In fact, these days, things are much more complex. If you decide to design for smartphone, tablet and desktop you could easily end up having to create three layouts for each possible view. This isn't something I'm personally fond of. I'd much rather limit myself to
Today I want to talk about a potential problem lurking in a small percentage of FileMaker solutions, and discuss various options for mitigating it. As you may know, there are three ways to display a new window… Via the New Window script step Via the Go To Related Record script step Manually via Window > […]
View the full article
WidgetStudio makes it easy to use, design and share powerful interface widgets, like calendars, gauges, charts, and timers. Pick from the constantly growing set of included widgets or build your own. Freely share them with your customers or friends.
The post Announcing WidgetStudio – FileMaker WebViewer Widgets appeared first on Geist Interactive.
View the full article
Ahhh... the ubiquitous notes field. Seems simple, right? In a way it is. Just slap down a field and resize it to show more data. Add a scroll bar and you're done. The problems occur when you are trying to locate an important note, print a report or perform a find. Data can be strewn all about a text field that allows free form entry and supports up to ten million characters. Imagine hundreds of different users trying to follow the exact same format for data entry. Pandemonium! This article will
Ahhh... the ubiquitous notes field. Seems simple, right? In a way it is. Just slap down a field and resize it to show more data. Add a scroll bar and you're done. The problems occur when you are trying to locate an important note, print a report or perform a find. Data can be strewn all about a text field that allows free form entry and supports up to ten million characters. Imagine hundreds of different users trying to follow the exact same format for data entry. Pandemonium! This article will
I Got Quicker at Debugging and So Can You
Eradicate those Annoying Little Code Demons with these Tools and a Few Lines of Custom Code I Developed
by Michael Suhrbier, eXcelisys Web App Developer
You’ve probably heard of these PHP / MySQL debugging techniques:
Xdebug — Great if you can get it working.
BackTrace(), print_r(), var_dump(), etc. — Very useful but usually very ugly and not easy for humans to read and understand.
PHP / MySQL logs — Fine for the average user, but let’s e
When you're the one creating the database, you're the one who says which data makes it in and which data doesn't. This all happens through the various methods of data validation.
Data is either considered valid or not - and this happens according to your data validation rules. If the data is valid, then everything proceeds as normal. If, however, the data isn't exactly what's required, then you get to choose what happens.
In most cases, you can let the user keep taking a whack at it until they
Join us for a free webinar about Otto, our Automated Deployment and Dev-Ops utility for FileMaker Server. Otto handles the tedious, and error-prone tasks of transferring files to servers and performing data migrations. If you regularly have to perform data imports and data migrations on your FileMaker systems, you will want to attend this webinar. In this webinar, […]
The post Otto Webinar appeared first on Geist Interactive.
View the full article
If you don’t know which method FileMaker uses for record locking, optimistic vs pessimistic, then you’ll find out during his talk. He’ll share his journey into how he became an optimistic database architect. What are the critical things be aware of when allowing FileMaker to work with optimistic record locking. We’ll look at security considerations when using this approach, and architecture and building solutions for maximum performance while maintaining data accuracy and reliability.
Under
The Microsoft OneDrive API can allow you to edit files without downloading and re-uploading to FileMaker. Integrate FileMaker with Microsoft OneDrive to store documents in the cloud and improve sharing while keeping your database lean and mean.
Be sure to check out the full article: https://dbservices.com/articles/filemaker-onedrive-integration/
Includes free sample database and tutorial video
dbservices.com
Scripts that run on the opening of a FileMaker file allow you to accomplish so many different tasks. Open scripts can initialize global fields, setup variables, determine which layout to display based on security or platform, perform sub-scripts, install menu sets and so much more. This article will cover some of the most important uses of Open scripts but each FileMaker solution will likely have unique open script steps.
View the full article
Scripts that run on the opening of a FileMaker file allow you to accomplish so many different tasks. Open scripts can initialize global fields, setup variables, determine which layout to display based on security or platform, perform sub-scripts, install menu sets and so much more. This article will cover some of the most important uses of Open scripts but each FileMaker solution will likely have unique open script steps.
View the full article
Prior to FileMaker 13 we never even had the option of performing scripted tasks where the data actually exists. The processing of a script, client side, always had, and still does, make a full round trip for all kinds of these processing activities. Many times, FileMaker does it's best to optimize whatever is being done, but it's still not as fast as executing certain things directly on the server.
With the addition of Perform Script on Server we gained a REALLY BIG performance boost by being a
We are releasing a major upgrade to Otto, our powerful Data Migration and Developer Operations tool. Otto automates the complex and error-prone process of migrating and upgrading FileMaker solutions, making it a key component of your Workplace Innovation Platform.
The post Otto v1.6.1 Released appeared first on Geist Interactive.
View the full article
To Be … Or Not to Be – A FileMaker Certified Developer
Should You Hire Only FileMaker Certified Developers?
How Do Developers Earn Certification and What Does it Mean?
When you search for a root-canal doc, board certification is no crock. But what about your developer? Can an uncertified developer needle their way through your software project without inflicting any pain? Must you hire a FileMaker Inc. certified developer to get your app built right?
We asked a bunch of developers about th
The Script Step reference pages in FileMaker's help is a useful source for all developers, new and experienced alike. It's worth our look once in awhile. There's a lot to learn and to be reminded of on each page.
The post FIleMaker Script Steps Reference: Worth the look appeared first on Geist Interactive.
View the full article
The FileMaker help functions pages are a worthy set of documents to review many times in a developer's career. There's a lot of information about each function. Here we take a look at the pages and see how their set up.
The post FileMaker Help Functions: Always more to learn appeared first on Geist Interactive.
View the full article
Geist Interactive is sponsoring the CIO/CTO Focus event series. The next event will be Feb 19, 2019, and will feature a discussion with leading Chief Information & Chief Technology Officers (CIO & CTOs) from the area. Todd Geist, CEO of Geist Interactive will be moderating the event. Register using the link below.
The post Geist Interactive Hosts Local CIO/CTO Focus appeared first on Geist Interactive.
View the full article
The FileMaker help guide is a useful set of documents, and we can use the context-sensitive help feature to get to the relevant help pages quickly. It is worth our time to review what is written.
The post FileMaker Help: A Worthwhile Read appeared first on Geist Interactive.
View the full article
One of the most wonderful aspects of FileMaker, or any development project, is implementing a portion of the software which can be used system wide. Meaning you don't have to recreate functionality over and over again in order to benefit from what you implement initially. Especially when it can be used in all locations universally.
In this video, I show you how to implement a Universal Tagging System in which you can apply tags to any other element you're managing within your database system. A
Out with the Old & In with the New,
Updating PHP is Essential for You!
Why PHP & WordPress Updates Should Top Your New Year’s “To Do” List
Do you own or operate a WordPress, Joomla!, Drupal, Magento or WooCommerce site? Then you’re using PHP and should read this to prepare for critical changes this new year.
By Michael Suhrbier, eXcelisys Web App Developer
What is PHP?
Hypertext Preprocessor (PHP) is an amazing and popular server-side programming language used in web developmen
I've always been intrigued with how to mimic a web browser's back and forward buttons... as have many other developers. While I don't usually include them in a professional solution, I do find the exercise of creating an airtight historical navigation solution challenging. I prefer well designed navigation over history buttons. Therefore, I present this article as a brain teaser and not necessarily as a recommended solution. But, I'll let you make the decision. I'll go into why I don't think his
