Unfortunately, there is a downside to this method of powerful, free data display. Implementing
Our team at Soliant wants to encourage and support FileMaker developers in leveraging J
Chicago, IL — March 25, 2019 — In a world full of tight competition, setting yourself apart from the crowd is no small feat.
Over the last 10 years, our Salesforce team has grown from a few self-taught, highly-motivated individuals to a powerhouse group, earning certifications and churning out strategic applications left and right. They strive to learn something new every day and build each Salesforce application even better than the last.
As a result of this hard work and dedication to a comp
The Ideas and Insights Get Bigger in Texas!
In January Soliant Consulting’s entire team descended onto the City of the Violet Crown for our annual offsite. Our 2019 retreat was our first time in Texas, and Austin did not disappoint. We spent the week trading insights, sharing ideas, and learning more about our fellow team members. Of course, we also had quite a bit of fun together, as we always do.
Because our team comprises four offices and dozens of remote employees across the gl
Not ( Having a Computer Science Background )
The FileMaker developer community seems to consist of people with quite a wide range of backgrounds, much more so than is the case with developers from other programming languages and software development platforms. I suspect this is a consequence of the rapid application development (RAD) nature of the platform and its lower learning curve. This makes it possible for individuals to change course in their careers once they serendipitously encounter F
Chicago, IL. – February 11, 2019 – Soliant Consulting is proud to have earned recognition as one of the Best and Brightest Companies to Work For® in the nation. The competition honors companies dedicated to their employees, identified by confidential employee survey responses.
Award winners are selected based on exceptional leadership, employee engagement, and human resources efforts to champion and support team members. 512 organizations were awarded out of 2,400 nominees.
At Soliant, we focu
FileMaker Templates are out! Our team here at Soliant was lucky enough to help build the files and tutorials, and I wanted to share our hopes for how you can make use of them. Three templates are available so far, and each one targets a different business model: Job Tracking, Event Management, and Memberships.
Each template comprises a few parts:
A core file
Tutorials for how to add Build-On features
A final file that includes all Build-ons
The idea is that you begin with a core file and
Our team worked with FileMaker to build several template files to help businesses launch specific functionality. These files encourage workplace innovation without requiring extensive development experience.
File Foundation Built for You
At the core of these templates, you’ll find a solid, consistent design, clean look, and strategic user interface and user experience. Look under the hood and you’ll find much of the same. That wasn’t by accident. Our team spent a great deal of time determining
Do you miss the statistics chart?
Figure 1. FileMaker 16 Admin Console with Statistics live view
The admin console was rewritten in FileMaker Server 17, and the Statistics section was not carried over to the new version. And when you are dealing with server performance issues, having a live view of the FileMaker Server statistics can be critical.
If your FileMaker Server runs on Windows, you can regain most of this lost functionality using the Performance Monitor tool ("Perfmon").
FileMaker introduced a very different kind of capability with the ExecuteSQL function. First introduced in FileMaker 12, it allows you to perform “select” queries against your FileMaker data, as opposed to the more familiar “Find” functionality available in FileMaker.
SQL (Structured Query Language) is a standard used with other, more traditional, database servers. Using SQL, SELECTS on indexed data is blazing fast and efficient. It allows you to construct relationships in SQL that do not neces
Many companies rely on out of the box software to run all, or at least many parts, of their business. As companies evolve, however, this software often cannot meet their needs to streamline workflows and improve productivity. Their complex business rules simply outpace their native out of the box software. They need something more robust to handle their workflows.
Custom software solutions are the obvious next step, but companies may pause at this option because of pain points that arise when c
More than the Robot Revolution
Even as we approach 2019, AI still feels like a foreign, futuristic ideal to many. We think of robots and reference movies like The Terminator, Blade Runner, or Ex Machina.
But AI is here. You can use it right now. It’s accessible, and it’s powerful.
Businesses, specifically, have unique opportunities to use their existing technologies with AI capabilities to make smarter decisions. They can leverage the information at their fingertips through the power of data
One of the biggest risks in undertaking a big software development project is underestimating the time and effort involved from start to finish. Our team has provided estimates for hundreds of projects, and sometimes we’ve missed the mark, especially in the early days of our business.
Over the years, we’ve put together a strong model for estimating how much time and effort a project is likely to require; our employees undergo annual training on the method. Using these methods ensures we present
Einstein is the new generation of AI available directly within your Salesforce CRM data. It learns from your existing data and can gives you predictions, insights, next steps, and recommendations. Why waste time calling on opportunities that are unlikely to convert?
The Einstein Prediction Builder can help you anticipate which opportunities are most likely to close and even which products prospects are most likely to purchase.
Einstein delivers scores; such as a lead score and how likely the le
What Are Script Parameters?
Script parameters are one of many tools that all FileMaker developers should learn to utilize when developing custom FileMaker applications. Numerous benefits include writing fewer scripts, increased code reusability, and improved coding organization.
By designing your scripts to pass parameters, you can use a single script with logic branching (i.e., IF, ELSE IF, ELSE) to perform multiple actions within your FileMaker solution. For example, you can create a Sales Or
In my series of component-based posts, I have another small, but useful, component - an auto resizing text area.
Salesforce Lightning Dynamic Text Area
For some of my other component based blogs, look here:
How to build a Date Picker
How to build a Multi Select Component
How to build a Drag and Drop Duelling Picklist
This time, I'm going to show you how to create an Auto Sizing Text Area.
FileMaker Portal Columns
I was recently asked to sort portal columns for a client, and I figured there has to be a newer and cooler technique out there to accomplish portal sort than when I did it last. I reached out to the other FileMaker developers at Soliant, and I got a great sample file from Ross Johnson. He shared a really cool technique with me, crediting mr_vodka (sounds like a fun guy!). Read mr_vodka’s original post here.
For my client, I was also asked to filter the portal and batch
Take Your Portals to the Next Level
FileMaker portals are invaluable for showing related data; there are several techniques for enhancing their functionality. Our demo contains three methods for adding the ability to sort, filter, and batch update portals.
Follow along with our step-by-step guide and get started with expanding the functionality of the portals in your FileMaker solution.
Complete the form to receive the demo file:
Trouble with this form? Click here.
The post FileMaker P
As Dreamforce 2018 spins up we’re reminded of the speed at which technology and the Salesforce platform is evolving. In just a few short years the Salesforce ecosystem has fully embraced Lighting as both an experience and development platform.
Dreamforce is a key event for our team; it exposes our developers, architects, and administrators to the latest patterns and solutions that the platform and its partners can offer. Our first day has already been quite packed, learning about new tools - li
Gemini to Apollo
Just like trailblazers such as Gus Grissom, working on the Mercury, and later, Gemini projects for NASA, we sometimes require separate or parallel environments in project deployments. Gemini could be viewed as the “Dev” phase that led up to the “Prod” project that followed, Apollo. Development environments are a critical part of projects where experiments and testing can be done without risk to critical resources, allowing bugs to be found and worked out.
Similarly, in FileMa
This is the final post in my series about the demo I presented during my “IoT and the FileMaker Data API” session.
The 'master' branch is the more interesting one as it uses the viseme information that Amazon Polly provides. For this to work I needed some linguistics help to interpret what those visemes mean.
In my DevCon session I jokingly stated that the session happened because of the help of both my daughters, one is in university studying Biology (fish, get it?) and the oth
This is the fourth in a series of posts about the demo I presented during my “IoT and the FileMaker Data API” session.
Making it Work in Python
The first half of my DevCon presentation would be about collecting sensor data from a Raspberry Pi and sending that data to FMS through the Data API, and I am using Windows 10 IoT and .NET code for that. If I could do the second half of the presentation using Python, then it would show off the versatility of both the Raspberry Pi device and the FileMak
This is the third in a series of posts about the demo I presented during my “IoT and the FileMaker Data API” session.
Construct #2 - Billy Bass Bones
As mentioned in my previous post, I decided to do everything from the Raspberry Pi to control the Billy Bass toy.
While I was scouring eBay looking for pristine Billy Basses I came across this one as shown in Figure 15.
Figure 15 - Ordering a Billy Bass
I thought that would be funny and I could make the story about the fact that almost 20
This is the second in a series of posts about the demo I presented during my “IoT and the FileMaker Data API” session.
Construct #1 - the original Billy Bass
I wanted to find a Billy Bass that was as close to the original one used in the 2001 DevCon session, so I started digging around on eBay, and this is the one I ended up buying:
Figure 9 - Buying an original Billy Bass
When it arrived, I unscrewed the back to see how I could get at the motors (see Figure 10). There's a small controller