New Client Story: Lab9 & ClickWorks

How do you scale internal systems to support a growing retail and service network; without losing agility?

From building their first FileMaker tool in-house back in 1993 to powering daily operations for 300+ employees today, Lab9 has always valued efficiency and innovation. When their internal platform needed a complete redesign, they partnered with us at ClickWorks.

Together, we reimagined their platform by refining design, improving day-to-day usability, and supporting teams across service, retail, and operations. It’s a collaboration that still continues today.

Read the full story here - https://www.clickworks.eu/en/case/inside-lab9-a-custom-platform-a-lasting-partnership/

On June 27, many members of the Claris Engineering team, including Lucy Chen and Clay, will join me for an under the hood look at Claris FileMaker 2023. Two sessions: 9:00 a.m. PDT and 4:00 p.m. PDT. [Register here](https://content.claris.com/claris-fm2023-webinar-uth-fmforums).

The task at hand was finding an API for one of our clients that could provide a comprehensive list of their clients stores. The goal was to cross-reference this with our database, ensuring each store was accounted for. Despite my efforts, the search came up empty. However, their website presented an intriguing alternative: a detailed directory segmented by state and country.

My initial approach was to examine the website's HTML, yet this only yielded the default data. Attempts to append the URL to load data from different countries proved futile. The website's dropdown appeared to use JavaScript to pull varying data sets. My initial assumption was that each selection triggered a new query. However, upon closer inspection, I discovered a JSON object nestled just before the closing body tag. Rather than querying anew each time, the JavaScript simply drew from different arrays within this pre-loaded object.

Enter ChatGPT, OpenAI's conversational AI. 

Claris's VP of Marketing Ann Devens just announced Claris Engage - February 6-8, 2024 on the Apple campus in Austin, Texas.

We'll share more details about registration, speaking, hotels, and exhibiting soon.

I hope to see you there!

This is essentially a port of WORDLE built-in FileMaker there are many who are addicted to this daily challenge.