What is JSONQuery? A custom function to query JSON, authored by Steve Senft-Herrera. Kevin Frank of FileMaker Hacks fame will demo many of the functions of this great tool.
Basic things JSONQuery does: Query: Allows for finding elements that match a supplied value, with a variety of options for operators. Aggregate: Allows for returning an aggregate, e.g., SUM, AVG, LIST, etc., of values taken from either the matched elements, or all of the input. Transform: Allows for customization of how the results are returned, with the option to pick-and-choose what attributes are included in the output, and how they are named.
Find out about JSONQuery’s numerous new features, as well as improvements on existing features.
Chris Moyer: Tech News Roundup
In his monthly segment, Chris Moyer of The Moyer Group will present another thrilling summary of significant news, both directly related to FileMaker and Claris, and from the larger world of technology.
Chris Jackson: Multilingual Database Case Study
Angel City Data’s Chris Jackson will be demonstrating a database that has been designed with multilingual support, allowing users in different countries to comfortably interact with the system in their own language. The system dynamically changes all UI text on buttons, tabs, tool tips and field labels to the desired language of the end user. He will be showing how to implement a multilingual solution and keep performance high, while making maintenance easy.
SCHEDULE
9:30 am - 10:00 am Log in, hang out, socialize 10:00 am - 11:30 am Kevin Frank, JSONQuery Now and Next 11:30 am - 12:05 pm Chris Moyer - Tech News Roundup 12:05 pm - 12:25 pm Break/Breakout Rooms, Announcements 12:25 pm - 1:00 pm Chris Jackson, Multilingual Database Case Study
Demo file: FM-22-Pseudo-Indexing.zip (works w/ FM 16 or later) When I wrote about Sort Values and Unique Values back in 2017, I made passing reference to an article I'd written a couple years previously on the topic of "pseudo indexing", i.e., displaying a list of unique values for a specific field for a found set, rather…
Claris International Inc., formerly FileMaker Inc., is a computer software development company formed as a subsidiary company of Apple Computer (now Apple Inc.) 🍎. https://www.claris.com/
FMTraining.tv has a Top Rated Video Training Subscription with over 70 hours of video content AND one copy of Claris FileMaker Pro! 🎥 👨💻. https://fmtraining.tv/subscription.php
RCC is the creator of FM Starting Point, the popular and most downloaded FREE Claris FileMaker CRM Starter Solution. https://www.fmstartingpoint.com
Demo file: boxed-summary-groups.zip Recently I needed to produce a summary report with variable height rows and each group enclosed in a rectangular box. To make the challenge more interesting, there were multiple fields in the body part, and it was not known in advance for any given record which would be tallest. At any rate,…
Since Claris announced FileMaker 2025 on July 8, I was looking for the best words to describe this release. I ended up deciding to borrow from Neil Armstrong. I truly believe that, while it may seem like one small step for a developer, it's actually one giant leap for the platform. #FileMaker #Performance #Released #Connect #Claris #Upgrade #Studio #JSON
Two notable features in FileMaker 2025, GetRecordIDsFromFoundSet and Go To List of Records, help simplify record manipulation, enhancing efficiency by eliminating the need for complex relationships and unnecessary fields. They enable users to effortlessly select and display various records, reducing technical debt and improving user experience.
This is a quick follow up to A Tip for MBS “Check Variable Names” from earlier this year. The other day I noticed variable name checking wasn't working in one of my scripts. The culprit turned out to be MBS's default 500 step limit for variable name checking. According to the documentation, the limit exists…
Join our development team as we share real-world insights from recent API integration projects—including SharePoint, Shopify, QuickBooks, and Claris Connect. From handling authentication quirks to leveraging tools like Postman and n8n, this DevCast dives into the decisions, roadblocks, and solutions behind the systems we build. Whether you're navigating OAuth, working with REST vs. GraphQL, or exploring Claris Connect and workflow automation, there’s something here for every FileMaker and API tinkerer.
The Portage Bay Solutions team of Certified FileMaker developers has a deep understanding of the Claris FileMaker platform and is experienced in helping businesses customize and extend the software to meet specific needs. Whether you need help with FileMaker design, deployment, database development, maintenance — or everything — Portage Bay is the perfect partner to help you realize the full potential of your FileMaker investment. https://www.portagebay.com/
FILEMAKER FIXIT! Get live answers to your FileMaker questions. Our experienced FileMaker developers are happy to assist you no matter what experience level you’re at. Get help with:
Claris FileMaker questions Hurdles you are experiencing Your own FileMaker or Claris Connect ventures API integrations for your solutions
Regular maintenance of Linux servers is crucial for security and performance. Monthly updates and backups help protect against vulnerabilities and ensure system reliability. For FileMaker and web applications, updates can enhance performance and provide new features. Local and offsite backups and real-time monitoring are essential for data protection and prompt issue resolution.
FileMaker 2025 introduces significant improvements in JSON handling with JSONParse and JSONParsedState functions, allowing access a native JSON representation stored in memory. This enhancement drastically boosts performance, enabling faster processing of large JSON payloads and streamlining script efficiency, making development more effective for complex data scenarios.
This specification adds basic grouping and aggregation functionality (e.g. sum, min, and max) to the Open Data Protocol (OData) without changing any of the base principles of OData.
To get content containing either thought or leadership enter:
To get content containing both thought and leadership enter:
To get content containing the expression thought leadership enter:
You can enter several keywords and you can refine them whenever you want. Our suggestion engine uses more signals but entering a few keywords here will rapidly give you great content to curate.
Scoop.it!
Your new post is loading...
