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
Hierarchical JSON Viewer / Editor
By Andy Persons & Doug West
One of the standout new features of FileMaker Pro 16 is native support for the JSON data-interchange format. In addition to providing easy integration with a host of online services, it also provides developers with the tools to create robust hierarchical structures for use entirely within FileMaker. This hierarchical JSON viewer / editor file provides some tools for visualizing, manipulating, and leveraging JSON text.
Features
Michael Layne from Gearbox Solutions presents on FileMaker’s new JSON functions. He does a deep dive into FileMaker’s new JSON functions and demos several examples of how they are using JSON for passing parameters, populating form data, validation and rollback, managing session info such as value lists as global. Michael also demos REST client and REST server with new data API.
The post FileMaker JSON, REST, and the Data API appeared first on Blue Feather - FileMaker Developer, Android, We
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
GoDraw3 is a FileMaker drawing tool for users. For FileMaker developers, however, it is full of customization. A developer can do with it what she wants.
The post GoDraw3: Hack the Heck Out of It appeared first on Geist Interactive.
View the full article
Having recently consulted with a newer developer unfamiliar with the way FileMaker hosting/sharing works, I found that discussing the process would be a good primer for anyone just starting with FileMaker. If you've only ever worked or developed your file on your local machine, then learning how to host that file will be a big benefit. Especially if you need to collaborate with another developer.
One of the key benefits of developing with FileMaker is the fact that it allows for collaborative l
There’s a reason why Google owns over 92% of the search engine market: it’s quick, dynamic, and helps users find the information they need. It even suggests and refines searches depending on what you type into the search bar.
Users have come to expect this kind of efficiency, but if you’re looking for this functionality in FileMaker, it can be tough to set up on your own. However, with the right approach, you can make FileMaker searches easier for both your developers and users.
Curious abou
Over the years I've created a number of videos about restoring user state. Returning windows to their last viewed location, restoring tabs and slider panels to those last viewed, etc. I've also created videos about super quick startup and managing users within a Users table.
What I haven't shown is how I combine all of those processes into a powerful user environment restoration routine. Along with highly maintainable (and transportable) code. I've used this approach on most all of the solution
Twilio is a leading cloud communications platform that works well for both reaching out to customers and receiving communications. Learn how to integrate Twilio with FileMaker using webhooks and a few lines of code to notify you via a screen pop when you receive an incoming call from Twilio. Includes a video and sample file. Read the full article here.
Recently we’ve discussed optimizing SQL queries in FileMaker, and had some fun with various SQL experiments. Today we’re going to explore some ways FileMaker can use ExecuteSQL and the While function to perform letter frequency and text pattern analysis on candidate words for the popular Wordle game. The list of words comes from https://github.com/tabatkins/wordle-list and… Continue reading Exploring Wordlespace with SQL and WhileView the full article
Hi there!
In this article we talk about an age old situation in FileMaker where two Auto-Enter calculations reference one another. We explain the order of execution and why this never leads to a desired result. We then show a cool solution to this issue such that you can build circular references that work the way you want them to.
Example file included as always.
Check out the article here!
Thanks for reading!
Daniel
Sometimes, it's just good to reflect on how you use certain FileMaker features. You know, the simple ones. Like Show Custom Dialog and Get ( LastMessageChoice ). If you use FileMaker for mobile a lot, then Show Custom Dialog is a great way to go. With Desktop, you might have less than optimal results because users can reposition and resize the dialog.
Aside from those few issues, however, it's probably one of those script steps you find yourself sprinkling all around your FileMaker solution. Th
INTRO Today we’re going to pick up where we left off last month, and today’s article will assume the reader is familiar with the material we covered last time (in SQL Multi-Table Query Optimization). This time we’re going to dig a little deeper into multi-table SQL queries, conduct some SQL experiments, and look at a… Continue reading SQL Multi-Table & Miscellaneous ExperimentationView the full article
Hi all,
I have just posted a new article at FileMaker Weetbicks entitled "A Clever CSS Chat Display". I hope you like it.
In this article I present a very easy to implement CSS-based chat 0 which is perfect for implementing a messaging system in your solution. The chat display is presented as a standard instant messaging format with a two-sided conversation. It is also able to handle formatting, and messages of any size.
As always an example file is included which should contain
When you really want to master creating all kinds of powerful solutions within FileMaker, then you'll have to be familiar with as many functions as possible. In fact, it doesn't hurt to know and have used every single one at least once or twice. The sooner you become familiar, the more things you'll be able to accomplish.
Reflecting on my own journey with learning all of FileMaker's functions, I remembered working with a dog-eared paper manual with sticky notes popping out all over the place. T
Martha Zink will host the podcast, continuing the tradition of interviewing the Claris community on various topics. Have some ideas or want to be on the podcast? Drop us a line and let us know! We want it all, including technical deep dives, customer stories, conceptual chats, and other topics that benefit the people in our community (and help spread the word on how awesome this community is).
The post The Context Podcast: The Modern FileMaker Revolution appeared first on Proof+Geist (formerly
Are you sending text messages to your customers? Although 54% of consumers prefer to chat with brands via text message, only 11% of brands use texting to communicate.
Texting may sound too complex, or too costly. But with open rates at 98% (compared to 20% for email), text message marketing is a great way to get in touch with your customers with less hassle.
Learn why text messages are so critical for your business, as well as how you can start sending texts through FileMaker with the Twilio A
Hi all,
I have just posted a new article & example file entitled "A Cooler Color Picker". In this article we present a javascript based color picker utility which can be reused multiple times on a layout, or across multiple different windows at once. We present it in both popover & card window varieties (so it can be usable within a portal). We also show a quick and simple way to generate a color swatch from the chosen hexadecimal code, as well as some other interesting tidbits in t
Some developers who start with FileMaker never extend beyond it. Hopefully, that's not you. Or, at least you're willing to look into learning some other languages and see how they can benefit your FileMaker solutions!
In FileMaker 19 we gained both a new script step named "Perform JavaScript in Web Viewer" and a JavaScript function embedded into the Web Viewer named "FileMaker.PerformScript()". If you haven't taken the time to investigate how these new features work, then allow me to give you t
Demo file: sql-multi-table-query-optimization.zip Recently a colleague requested help w/ a SQL query that was performing slowly. I wrote back: Make sure there are no records open locally, i.e., on your machine, in the tables you are querying (for more information see this article by Wim Decorte: ExecuteSQL – The Good, The Bad & The Ugly)… Continue reading SQL Multi-Table Query OptimizationView the full article
Personally, I've always been dismayed by how portals are positioned within the world of FileMaker instruction. When I see other developers teach about portals, they start with the primary use of portals and then stop. They talk about how portals are there to show related data and that's about it. No way! That's certainly not the end of things. Portals are one of the primary ways to present data however you wish.
If portals were limited to simply showing related data based on a normalized schema
Your business relies on your FileMaker solution, which means that when it needs an upgrade or a major overhaul, you can't put it off. These types of big projects are exactly what the Custom Development Team at PCI works on every day.
But what about…everything else?
Time and time again, we see clients with wishlists that get deprioritized in favor of just keeping things running. A new button, a report that's easier to read, a portal upgrade -- these are the things that always hang out at the bo
Companies that use both FileMaker and ShipStation often find themselves transferring data back and forth between systems. In this article, we will demonstrate how you can eliminate the hassle of manually creating or updating your order by integrating your FileMaker solution with ShipStation. Includes a video and sample file. Read the full article here.
