Why Artists and Galleries Need Bespoke Software
The art world operates differently from most industries. An artist's studio does not need a CRM designed for sales pipelines. A gallery does not need an inventory system designed for widgets. The data that matters in this sector — provenance, exhibition history, edition details, image rights, insurance valuations — does not fit neatly into generic business software. Spreadsheets work until they do not, and that threshold arrives faster than most studios expect, often when a major exhibition or publication deadline is looming.
We have worked directly with artists and studios in Scotland, and we understand the specific demands of managing a body of work that spans decades. A painting created in 2003 might be in a private collection in New York, on loan to a gallery in London, or held in the studio. You need to know where it is, who owns it, what exhibitions it has been in, what publications it has appeared in, and whether there is a high-resolution image on file. That is a database problem, and it needs a proper database solution.
What We Build for the Creative Sector
Catalogue Raisonne and Artwork Databases
A catalogue raisonne is the definitive record of an artist's complete body of work. Building one requires a database that can handle structured metadata — title, date, medium, dimensions, series, edition details — alongside unstructured information like provenance notes, condition reports, and exhibition histories. We build FileMaker databases that serve as the backbone of a catalogue raisonne project, with data models designed specifically for this purpose.
Each artwork record links to its full provenance chain, exhibition history, publication references, and image files. The database supports advanced searching and filtering so that a studio manager can instantly find every oil painting from a specific year, every work currently on loan, or every piece that has never been exhibited. For artists preparing for a major retrospective or a catalogue publication, this kind of structured, searchable data is invaluable.
Image Handling and Container Management
Visual documentation is central to managing an art collection or studio archive. FileMaker's container fields allow us to store and display high-resolution images directly within the database, with external storage options that keep the database file size manageable while still providing instant access to images. We build batch import workflows that let you bring in hundreds of images at once, automatically matching them to existing artwork records based on file naming conventions.
For studios that need to provide images to galleries, publications, and press contacts regularly, we build export functions that generate image packages with accompanying metadata — captions, credit lines, dimensions, and media information — formatted for immediate use. This eliminates the manual process of hunting through folders for the right image and typing out caption details from memory.
Exhibition and Loan Tracking
Tracking where work is — and where it has been — is a core requirement for any serious studio or gallery operation. We build exhibition modules that record every showing: venue, dates, curator, catalogue details, and which specific works were included. Loan tracking covers outgoing loans to galleries and institutions, with fields for insurance valuations, shipping arrangements, condition reporting, and return dates. The system can flag upcoming loan returns and expiring insurance cover, ensuring nothing falls through the cracks.
For galleries managing a roster of artists, the database can track consignment stock, sales, commissions, and artist payments alongside exhibition programming. The relational data model means that a gallery can see the complete history of any work — from the moment it entered the gallery's inventory through to sale, exhibition, or return to the artist.
FileMaker Server for Studios
Our work with Callum Innes Studio is a direct example of what we deliver for the creative sector. Callum Innes is one of Scotland's most recognised contemporary painters, and his studio needed a robust, reliable system for managing a significant body of work spanning decades. We set up FileMaker Server for the studio, providing a multi-user environment where studio staff can access the catalogue database simultaneously, with proper backup scheduling and access controls in place.
FileMaker Server is particularly well suited to studio environments. It runs quietly on a Mac or Windows machine in the studio, handling multi-user access without the complexity of enterprise IT infrastructure. For studios with remote staff or advisors who need access from outside the building, we configure secure remote connections or deploy through FileMaker WebDirect for browser-based access. The server handles automated backups, so the studio's entire catalogue is protected without anyone needing to remember to run a backup manually.
Understanding the Art World's Requirements
We approach creative sector projects with an awareness that the data model matters deeply. The difference between an edition and a unique work, the distinction between a private sale and an auction result, the relationship between a study and a finished painting — these are not edge cases, they are fundamental to how the database needs to be structured. We take the time to understand these nuances before writing any code, working closely with studio managers and artists to ensure the system reflects how they actually think about and categorise their work.
We also recognise that creative studios are not IT departments. The software needs to be straightforward to use, visually clean, and reliable. Nobody in a studio wants to spend their morning debugging software when they should be preparing for a gallery opening. We build interfaces that are intuitive and provide the training and support needed to ensure the team is confident using the system independently.
If your studio or gallery is managing artwork records in spreadsheets, folders of unsorted images, or a legacy database that no longer meets your needs, we would welcome a conversation about what a modern, purpose-built system could look like. We understand the creative sector's requirements, and we have the technical skills to deliver a solution that works.