The Support Group Blog

The Support Group

The Support Group
Find me on:

Recent Posts

FileMaker 2024: AI Integrations

Perhaps the most anticipated new features in FileMaker 2024 are the advanced integrations using artificial intelligence.  Users can leverage their existing data in new ways with these AI capabilities: query data using natural language through the new semantic search feature, improve workflow efficiency with AI, and gain new insights and trends with company data. One of the main goals of using a database is to turn your data into information, and these new AI abilities can allow you to greatly expand the amount of information you can gain from your data.

Read More

Custom FileMaker Property Management Software

Empire State Properties (ESP) is a full-service real estate company that provides sales, rental, and management services for hundreds of New York City property owners. Suzanne Miller founded the company in 1991 and has been going strong since. ESP takes pride in the stature of its properties and the clientele it services. Many of the residences offer luxury accommodations and amenities that leverage the beauty and convenience of living in New York City. And the properties offer a variety of options in terms of layouts, furnishings, leasing options, etc.

Owners and investors rely upon ESP to manage and find tenants for their apartments on both short-term and long-term bases. In addition to lease management services, ESP offers various related services, including housekeeping, finances, and other apartment utilities such as high-speed Wi-Fi, cable television, and linens. Each residence is unique and offers individualized leasing terms and amenities to occupants. There are quite a number of details that ESP has to track and handle professionally and efficiently. As such, ESP turned to technology and The Support Group to help them with their lease management software.

Read More

Custom Software Development Cost: From Design To Maintenance

The first-ever software dates back to the late 1940s and technology has experienced many quantum leaps since then.  It permeates virtually every aspect of society, from communication and entertainment, to education and business, and beyond. Frankly, technology, specifically software, can be the basis for success or failure, profit or loss, frustration or satisfaction.

Do you want custom software that fits your needs? It might not be as bank-breaking as you might suspect. Custom software development involves several factors that influence its cost.

Read on to learn all about custom software development cost factors.

Read More

How to Export from FileMaker to Excel

One common request we often receive as FileMaker developers is to give users the ability to export the data out of the FileMaker app into Excel. While FileMaker provides the ability to do this quite easily with the tools built into the app, users often want more flexibility and customization when it comes to the formatting of the exported Excel sheet. 

There are a variety of options that are available here – plugins exist to make this possible, and we have a blog post that outlines a routine way to export custom headers from FileMaker using XSLT sheets. But we can also export data from FileMaker to Excel with the power of JavaScript.  

Read More

Tips for Improving Software Performance and Scalability

Is your application in dire need of an update? With operating systems becoming more advanced and offering better app usability, ensuring our software performance and scalability are up to par is more important than ever. So, how exactly can we keep our custom software relevant? Here are some things to consider when an opportunity to upgrade or enhance our applications presents itself.

Read More

FileMaker 2023: Layout Calculation

TL;DR

Layout Calculations allow for calculations in text objects, but this feature has a few nuances. 

  • Removes the need for extra fields or scripts or layout objects simply for display
  • Need to have version 20.3 or greater of FileMaker client
  • Works for labels of regular buttons
  • Use fully qualified field names so the calculation refreshes properly
  • Can set data format so the formatting of text field works

The Support Group has been using FileMaker to provide solutions for clients for almost forty years, and for more than half of those years, we've been advocating for the layout calculations feature. So, we are very excited about its release. 

Read More

Integrating Claris Connect with ChatGPT

There are many practical applications for ChatGPT with a low-code development tool like FileMaker. We've explored a chatbot, image generator, and audio transcription ChatGPT integration with FileMaker. We've also shared an example of using ChatGPT to summarize our notes.

We want to explore how integrating FileMaker and ChatGPT via Claris Connect works. Though not necessarily ideal, we'll use an annual performance review as the foundation for our example. Of course, performance appraisals are highly individualized, so artificial intelligence isn't recommended, but most people can relate to this process's fundamental objectives and structure. We will use it as a simple case to demonstrate the workflow and results.

Read More

Data Debt Management

In the ever-evolving landscape of technology, businesses today face several challenges in managing their digital assets. Among these challenges, one prominent issue often surfaces – data debt. Data debt results from poor data quality, mismanagement, or neglect, hindering business operations and decision-making. But, data debt does not have to be a terminal issue. We can tackle it by applying practical data conventions, implementing regular review and purge tactics, running system audits, etc.

Read More

FileMaker Document Management System for Research and Development

Genentech is a leading biotechnology company headquartered in San Francisco, CA. Since 1976, they have been dedicated to discovering and developing treatments for severe and life-threatening illnesses and diseases. In 2009, Roche Group acquired Genentech and currently operates as an independent subsidiary. 

With more than 13,000 employees, The Support Group has worked with various departments within Genentech since 2011. We've built various custom applications to help teams streamline workflows and maximize productivity. We recently developed a records management system for the Quality Systems department.

Read More

FileMaker 2023: Send Mail OAuth

The FileMaker Send Mail script step is a valuable function for developers, but in recent years has become unreliable. Many conventional email service providers have gradually made using Simple Mail Transfer Protocol (SMTP) relays more complicated, primarily due to security concerns. Here at The Support Group, we've been transitioning clients to Gmail or Azure Application Programming Interfaces (APIs), depending on their email provider. Another option is SendGrid from Twilio, but that's a different blog post. Now, FileMaker 2023 offers an enhancement to our Send Mail options, a game changer, in our opinion.

Open Authorization (OAuth) is a widely used framework that allows different applications to interact with one another. It's most appreciated for its ability to facilitate those interactions without having to share access credentials. Instead, a private key verifies the user's identity. It's relatively easy to implement and maintain.

Read More
BrowseMode

Sign up to receive news and information about the FileMaker platform and other custom app development tools.

Keep me posted

Most Popular

Developer Resources

News, Tips & Tricks and Demos

Archives