filemaker-json-pivot solutions are among the fastest and most efficient ways to generate dynamic reports for veterinary clinics and organic farm management systems. This method allows us to transform complex datasets into clear, structured, and actionable insights.
Our approach to filemaker-json-pivot processing ensures high performance and optimized workflows. By building a single JSON structure that represents all animals, all exam types, and all result values, FileMaker can generate advanced reports in seconds—regardless of data size or complexity.
Using a filemaker-json-pivot architecture also allows the system to handle unknown or variable rows and columns with perfect consistency. Veterinary environments often deal with herds of unpredictable size, and animals can undergo different sets of tests. JSON makes this variability easy to manage.
Businesses that rely on filemaker-json-pivot techniques gain speed, clarity, flexibility, and long-term maintainability in their FileMaker solutions.
Pivoting Data in FileMaker: From Animals in Rows to Animals in Columns
In modern veterinary software and organic farm management systems, reporting is often one of the most challenging aspects. A frequent need is to pivot data—turning rows into columns or columns into rows so that managers can immediately read, compare, and interpret information.
At Lolli Group, a Claris FileMaker Partner with over 25 years of experience, we design high-performance FileMaker solutions capable of delivering such reports instantly. Our strategy centers on building a unified JSON model using FileMaker scripts and the FileMaker Data API.
How the System Collects and Prepares Data
To give clients a sense of how this works behind the scenes (without requiring technical knowledge), here is a simplified explanation.
Our solution uses two coordinated steps:
- A Data API request retrieves all animals belonging to a specific protocol or batch. This includes their basic details and the list of exams they performed.
- A server-side script (PSOS) processes the raw JSON and builds a structured dataset ready for pivoting.
This architecture is extremely fast because the heavy processing happens on the FileMaker Server, not on the user’s computer. Even large datasets are prepared in seconds.
Collecting All Exam Codes Automatically
The script scans all animals and collects every unique exam code found. This is done using modern JSON functions such as JSONListKeys and iterative loops. Instead of assuming how many exams exist, the system discovers them dynamically—essential in veterinary workflows where different animals may undergo different tests.
Once all exam codes are identified, they are sorted and grouped, becoming the foundation of the upcoming pivot table.
Building Dynamic Pages of 5 Animals at a Time
Because reports are designed to be printable, our filemaker-json-pivot solution automatically groups animals in blocks of five. If a farm submits an analysis for 28 animals, the system automatically produces six pages—no manual setup required.
Each group of five animals receives its own header, built with a small JSON fragment:
{
"p1": "Animal A",
"p2": "Animal B",
"p3": "Animal C",
"p4": "Animal D",
"p5": "Animal E"
}
This header is then stored inside each PRINT_CHEM record, making layout rendering extremely fast.
Matching Exam Values Across Animals
For each exam type, the script checks which animals have produced results. Because FileMaker stores exam details in related portals, this part of the script performs a lightweight search inside each animal’s JSON data.
If an animal did not perform a specific exam, the cell is simply filled with “–”.
This ensures the final report is always aligned and complete, even when animals have taken different tests.
Creating the Final Report Records
Once all data is organized, the script switches to the printing table and creates clean, standardised records ready for PDF export:
- Analita (Exam name)
- CAS (Chemical identifier)
- Requisito (Limit or requirement)
- jsonValues (All animal results for that row)
- jsonHeader (Column header with animal names)
- groupIndex (Page number for printing)
This makes it easy for FileMaker to render the report: the layout simply reads the JSON and fills in the cells. No complex relationships, no slow searches, no heavy recalculations.
Why This JSON-Driven Approach Is Ideal for Veterinary and Farm Data
1. High Performance
The entire report—often dozens of pages—is produced in seconds. The use of server-side scripts and JSON processing ensures maximum speed.
2. Scalability
Whether dealing with 5 animals or 500, the filemaker-json-pivot solution behaves consistently.
3. Flexibility
If new exam types are added or animals perform different tests, the system adjusts automatically.
4. Clean Architecture
The layout is simple and stable because all business logic is encapsulated in JSON structures.
A Pattern Useful Far Beyond Veterinary Systems
The same architecture is ideal for any FileMaker solution that needs advanced reporting:
- Quality control and compliance
- Food safety laboratories
- Production batch monitoring
- Inventory and multi-site comparisons
- Training and certification matrices
Whenever rows and columns need to pivot dynamically, JSON offers unmatched speed and clarity.
Why Choose Lolli Group
Lolli Group has been building advanced FileMaker solutions for over 25 years and is an official Claris FileMaker Partner. We work with major European brands and provide:
- Custom FileMaker development
- High-performance reporting and dashboards
- JSON workflow design
- API integrations
- International and multilingual support
Need Help with FileMaker JSON or Pivot Reports?
If you need a powerful filemaker-json-pivot reporting system, or if you’re planning a new veterinary or agricultural software project, Lolli Group is available for consulting and development.
Contact Lolli Group today
to discover how a JSON-based architecture can make your FileMaker reports faster, clearer, and easier to maintain.