[FMP Tip-N-Trick] Don’t Get Thrown for a Loop with FileMaker’s New While Function
Check Out This Custom Function for Merging JSON Arrays
By Rob Poelking, eXcelisys FileMaker Developer
FileMaker Inc. (errr, I mean Claris International) introduced a new function with the release of FileMaker 18 that I was both eXcited and intrigued by until I tried to use it the first time: the “While” function.
I’ve written a number of custom functions through the years and lots of loops in scripting to manag
Dogged by a Slow FileMaker Database?
Cache in on this Quick Tip to Improve Layout Load Times & Report Generation
By Joe Cellino, FileMaker Developer
Have you ever wondered, “What is taking this report so long to generate?” or “Why does this layout take so long to load?” It may be that your FileMaker fields are set up inefficiently. If you have unstored calculation or summary fields on your layout, this will most certainly be the issue. Just as the names indicate, “unstored” calculation fi
Dogged by a Slow FileMaker Database?
Cache in on this Quick Tip to Improve Layout Load Times & Report Generation
By Joe Cellino, FileMaker Developer
Have you ever wondered, “What is taking this report so long to generate?” or “Why does this layout take so long to load?” It may be that your FileMaker fields are set up inefficiently. If you have unstored calculation or summary fields on your layout, this will most certainly be the issue. Just as the names indicate, “unstored” calculation fi
Milcarb to Launch Remote Nitrogen & CO2 Beverage Gas Monitoring System
eXcelisys Builds Mobile IoT App that Delivers Tank Telemetry Directly to Android and iOS Devices
Gas (carbon dioxide and/or nitrogen) is a standard ingredient in beer. To achieve the ideal pour, pressurized gas is used to push the draught beer from the keg to the faucet. No gas = no beer. Milcarb’s N2UⓇ Nitrogen Generator provides on-demand nitrogen.
In most workplaces, it’s considered impolite to talk about passing
Milcarb to Launch Remote Nitrogen & CO2 Beverage Gas Monitoring System
eXcelisys Builds Mobile IoT App that Delivers Tank Telemetry Directly to Android and iOS Devices
Gas (carbon dioxide and/or nitrogen) is a standard ingredient in beer. To achieve the ideal pour, pressurized gas is used to push the draught beer from the keg to the faucet. No gas = no beer.
In most workplaces, it’s considered impolite to talk about passing gas. At Milcarb, that’s their job. For five decades, Milcarb ha
FileMaker Inc. Rebrands as Claris International
Looking Toward the Future, Software Company Revives Name From Past
FOR IMMEDIATE RELEASE: August 15, 2019
Names change. Google started out as Back Rub and Yahoo! was originally known as Jerry’s Guide to the World Wide Web. And FileMaker Inc.? That’s so old-fashioned. Last week, during FileMaker’s annual Developer Conference – AKA DevCon ’19 – the company announced it was going back to its roots, changing its name from FileMaker Inc. to Claris In
FileMaker Inc. Rebrands as Claris International
Looking Toward the Future, Software Company Revives Name From Past
FOR IMMEDIATE RELEASE: August 15, 2019
Names change. Google started out as Back Rub and Yahoo! was originally known as Jerry’s Guide to the World Wide Web. And FileMaker Inc.? That’s so old-fashioned. Last week, during FileMaker’s annual Developer Conference – AKA DevCon ’19 – the company announced it was going back to its roots, changing its name from FileMaker Inc. to Claris In
Metaphysical Supply Shop Finds Bliss with Magento Integration
eXcelisys Brings Tranquility to Crystal Vaults by Linking Inventory Database to Magento Webstore
As an informational website and webstore, Crystal Vaults enjoys a rock-steady flow of visitors. Some 8 million people a year come to Crystal Vaults to learn about the power of crystal energy and browse the healing crystals, amulets, talismans, pendants, earrings and other natural crystal creations for sale on the Magento eCommerce site
Metaphysical Supply Shop Finds Bliss with Magento Integration
eXcelisys Brings Tranquility to Crystal Vaults by Linking Inventory Database to Magento Webstore
As an informational website and webstore, Crystal Vaults enjoys a rock-steady flow of visitors. Some 8 million people a year come to Crystal Vaults to learn about the power of crystal energy and browse the healing crystals, amulets, talismans, pendants, earrings and other natural crystal creations for sale on the Magento eCommerce site
Medical Sales College Alleviates Administrative Complications with Custom Software Solution for New Student Recruitment
Bespoke FileMaker Pro Solution Injects New Life into Admissions & Speeds Job Placement Process at Med Device Sales School
As a post-secondary institution, Medical Sales College is committed to recruiting, enrolling, educating and placing students. For years, Medical Sales College used multiple FileMaker Pro databases for student record management and placement. But t
Custom FileMaker Go iPad App Reduces Chronic eXposure to Paperwork for Safety Training & Consulting Firm
OSTS Inc. Rids Itself of Unnecessary Data-Entry Hazards and Improves Occupational Health in Front Office
OSTS (Occupational Safety Training Systems) President Mike Geosano grew up in the safety supply industry. His father owned some distribution companies that sold safety products like first aid kits and hard hats. While this atmosphere sparked an interest in worker safety and pr
Untangle the Website Design Process with Wireframing
Need a sketch-builder to help you visualize pages and layouts for your site? Try Pencil, an open-source GUI prototyping tool.
by Justin Kwapich, eXcelisys WordPress Web Wizard
Wireframing with Simplicity
One of the first steps in constructing a new website is planning where the elements of your website will be placed. Building a website and then moving different components from page to page looking for the perfect placement could add up
The Paradox of Plugins: How to eXtend Your WordPress Site Safely & Sanely
Is it better to use a pre-made WordPress plugin or hire a developer to create a custom one?
As many a WordPress user has lamented, plugins can be a great asset — and huge liability — at the same time. Built right, plugins add crucial functionality to your WordPress site.
What is a plugin?
A plugin is a modularized section of code added to your website to do specific things. Plugins utilize the PHP scripting langu
[FMP Tip-n-Trick] FileMaker Developer Busts Through Stalemate to Create Chess Engine
FileMaker Database App Reigns in Gaming Platform
by Joe Cellino, eXcelisys FileMaker Developer
There are two things that bring me joy in this world — chess and FileMaker. I never thought that these two passions would cross paths in my lifetime, but now, that day has come.
Having spent the past several years immersed in the tech industry, I’ve seen how rapidly machine learning has progressed. From autonomou
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
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?
We asked a bunch of developers about the certification process and its impact on their work. As a consumer, you want to know what you’re paying for when you hire a developer with the FileMaker Inc. seal of approval. How do developers get certified — and what, eXactly, does it mean?
“I do think the certificate process
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
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 development. How prominent is it? Well, it’s powerful enough to run the biggest blogging system on the web (WordPress) and the largest social network platform in the world (Facebook)!
Holiday Light Maker Finds Peace on Earth with Sales Quoting & Fulfillment App
FileMaker Platform Brings Bright Sparkle to Global Operations at Christmas Northeast / Nicolas Holiday
Just as Santa relies on the elves to keep his North Pole toy shop churning, holiday light manufacturer Christmas Northeast / Nicolas Holiday depends on the FileMaker Platform to manage sales and distribution of its bulbous bling.
As the sole manufacturer of all GE-branded holiday lighting products, the compa
Survival Guide (7 of 7): Find, Hire & Work with a Software Developer, Successfully!
Bringing Your Vision to Life: Development, Testing & Deployment
Development styles — What to eXpect
Broadly speaking, there are three common approaches to development: agile, waterfall and prototyping. All are intended to get to the finished product in an efficient manner, but each takes a different approach. The agile development style practices discovery as development unfolds and requires
Is your site running an older version of PHP? Chances are … yes. According to W3Tech, 76.6% of websites are running a version of 5X. This December, support ends for versions 5.6 to 7.0, pushing them to end of life. This means no more security updates! What does this mean for you if your site is still running an older version of PHP? It means that if a new security issue is found it will not be fixed going forward. So, if you get hacked there may not be a simple fix. You can always roll back, b
Is your site running an older version of PHP? Chances are … yes. According to W3Tech, 76.6% of websites are running a version of 5X. This December, support ends for versions 5.6 to 7.0, pushing them to end of life. This means no more security updates! What does this mean for you if your site is still running an older version of PHP? It means that if a new security issue is found it will not be fixed going forward. So, if you get hacked there may not be a simple fix. You can always roll back, b
WordPress Website Redesign Boosts Placement Firm’s Candidate & Recruiter Traffic
Responsive Design & Custom Plugins Optimize Century Group’s eXternal & Internal User eXperiences
When businesses in Southern California, the Bay Area or Denver need a new CFO, controller, accountant or payroll coordinator, they turn to Century Group for help in recruiting the right candidate. Likewise, job-seeking finance and accounting professionals rely on Century Group when they’re on the h
Pond Care Company Uses FileMaker Pro with Field-Synced iPads to Deliver Photos & Service Records to Office Staff & Clientele; System Eliminates Paperwork & Improves Customer Communications
ASAP Aquatics is located in Indianapolis.
Lakes and ponds are lovely … when they are lovely. But not so much when frothy slicks of fluorescent algae bloom all over the surface. To fix this problem, the people of Central Indiana rely on ASAP Aquatics. Founded in 1996, ASAP Aquatics offers algae
Penny Newman Grain Co.
CLIENT Penny Newman Grain Co.
DATE 2012
TAGS Agriculture, Consulting, Database, Design-Development, FileMaker Go, FileMaker Pro, Mobile Applications, Synchronization
About Penny Newman Grain Co.
Penny Newman Grain Inc. is a grain/feed supplier to the cattle and livestock industry.
Challenge:
Penny Newman had an idea to try and convert their dealers from paper-based reportin
The Discovery Phase:
Taking the Final Leap: Define the Scope & Approve the Plan
When it’s time to actually begin development the tendency is to want to just get started. A lot of time and effort has gone into getting to this point, so there can be a lot of eXcitement about finally making things happen. However, there is one last step to take before your developer puts fingers to keyboard. The “discovery” phase is where the requirements gathering is done. It is the all important planning
