Case studies / Robert Rauschenberg FoundationFoundation · artist residency · 2022–2024

A residency's operations, built to be run by its own staff

The Rauschenberg Residency on Captiva Island brought cohorts of artists through the same sequence every session: invitation, intake, scheduling, contracts, travel, and housing. The foundation asked us to make that sequence run in one system, and to leave its staff able to build on it themselves.

Robert Rauschenberg Foundation
Captiva Island. Courtesy of the Robert Rauschenberg Foundation.
INVITEINTAKESCHEDULECONTRACTSFACILITIESARCHIVEONE SOURCE OF TRUTHROBERT RAUSCHENBERG FOUNDATION · SYSTEM MAP
System map, simplified◆ automated   ● human-owned

The situation

Each residency cohort meant re-creating the same steps by hand: inviting artists, collecting their information, matching them to sessions, sending contracts and tax paperwork, arranging travel and housing. The stated goal of the engagement, written into the agreement, was to increase the staff's confidence in building Airtable solutions for themselves.

What we built

  • A residency management base with an invitation automation for four resident types, an intake form, and session-preference views. It went live in September 2022: 100 artists were invited and 35 responded in the first week.
  • A facilities and maintenance base, with buildings and lots catalogued by staff, a vendor list, maintenance request forms, and inventory. After Hurricane Ian damaged the island that fall, this base became the tool for tracking repairs and replacements during the recovery.
  • Training throughout for the studio manager, who by the end was cataloguing buildings and building his own email automations.

What changed

Reopening after the hurricane took longer than anyone expected, so the second-generation communications workflows we designed in late 2023 were not run with a live cohort before our engagement ended in 2024. What the foundation kept from our work was a working invitation system, a facilities system it used through the recovery, and a staff member who could extend both.

In 2025 the foundation announced that it would sell the Captiva property and bring the residency to a close, citing recurring storm damage, broader climate risks, and rising maintenance costs. More than 500 artists had been in residence there since 2012.

The takeaway

The most durable thing we can leave behind is a person on staff who can change the system without us.

Want this kind of clarity for your organization?

Book a free 30-minute call. Tell us what's happening, and we'll tell you where we would start.