How Disrupt Social Scaled a Forex Investment Tracker Beyond Its 100-Investment Limit Using Airtable and Make Automation

Client

Disrupt Social is a performance marketing agency specialising in direct-to-consumer brands, with expertise in creative media buying and data-driven marketing strategies. The engagement in question was on behalf of a Disrupt Social client managing a forex investment fund — tracking individual investor positions, weekly growth figures, deposits, withdrawals, and closing balances across a growing investor base. The client had self-built an initial Airtable tracking system that functioned at small scale but contained a fundamental automation design flaw that was preventing the fund from expanding beyond its existing investor count.

Challenge

The forex investment tracker had been built with a pragmatic approach to Airtable automation: every week, a new set of columns was created to capture that week’s opening balance, growth amount, and closing figure for each investment. This worked at small scale, but it carried a compounding structural problem — the base was growing wider every week, and Airtable’s native automation engine could not create the inter-row relationships needed to analyse investment performance across time without those ever-multiplying columns.

Automation Architecture Hitting Its Design Limit

The column-per-week automation model was unsustainable by design. Each weekly run added three new columns to the base — opening balance, growth amount, closing balance — meaning the table structure grew by three columns per week indefinitely. After months of operation, the base had become wide, difficult to query, impossible to report on coherently, and structurally incompatible with any row-based analytics or dashboard tool. The automation was not broken in the conventional sense — it ran every week — but it was building an increasingly unmanageable data structure with every execution.

Approaching the Investment Capacity Ceiling

Airtable’s native automation had an effective ceiling of approximately 100 investments for the existing data model. With 80 investments already recorded, the client was approaching that ceiling and had no viable path to growth within the current architecture. Continuing to add investors without a structural fix would either break the automation entirely or require manual intervention with every new addition — neither of which was acceptable for a fund under active management.

No Reporting or Dashboard Capability

Fund managers and investors need analytical visibility: performance trends over time, comparison across investment classes, and summary views of opening and closing positions. The column-per-week model made structured reporting impossible — each week’s data lived in a different column, preventing any time-series analysis without significant manual data reshaping. The client had no dashboard and no way to build one without first fixing the underlying data structure.

Goals

The redesign needed to remove the capacity ceiling, fix the automation architecture, and create a foundation for reporting — all without requiring the client to migrate away from Airtable or retrain on a new platform.

Journey

The Ajackus team approached the Disrupt Social engagement with a constraint-first design philosophy: the solution had to work within Airtable, had to preserve existing data, and had to control ongoing automation costs as the investment fund grew. Rather than recommending a migration to a more capable platform, the Ajackus team identified a structural redesign that addressed all three constraints simultaneously.

Data Structure Redesign in Airtable

The Ajackus team replaced the column-per-week model with a row-based weekly tracking table. Each week’s data for each investment is captured as a new row, recording the opening balance, profit percentage, calculated profit value, any deposits or withdrawals, and the closing balance. This structure is inherently scalable — adding a new investor or a new week adds rows, not columns — and is directly compatible with Airtable’s reporting and view capabilities. The redesigned table structure also makes historical performance analysis straightforward: filtering by investor or by date range returns clean, consistently structured data without any manual reshaping.

Make Automation for Inter-Row Relationships

Airtable’s native automation engine cannot create relationships between rows in the same table — a limitation that makes week-over-week calculations (opening balance = previous week’s closing balance) impossible without external automation. The Ajackus team integrated Make to establish these inter-row links, building a workflow that runs each week to create the appropriate relationship between each investment’s current and prior week records. Make’s more flexible trigger and action model allowed the Ajackus team to implement logic that Airtable’s native automations fundamentally cannot execute — making it the correct tool for this specific requirement rather than an over-engineered addition.

Cost-Optimised Dual Workflow Architecture

Make charges based on the number of operations executed per workflow run. As the investment fund grows and the number of weekly records increases, a single unrestricted workflow would consume an increasing number of operations per run — potentially escalating the client’s Make subscription tier. The Ajackus team addressed this proactively by building two workflow variants: a full-population workflow for comprehensive data processing, and a defined-week workflow that limits operations to a specific number of weeks, controlling cost at scale. The client can choose which variant to run based on their current operational needs, giving them direct control over their automation costs as the fund grows.

Results

The redesigned system operates seamlessly within Airtable — no migration, no retraining, no disruption to existing records — with the structural capacity to grow well beyond the previous 100-investment ceiling and the data foundation needed for dashboard and reporting development.

What went well:

Operational Improvements

• The hard investment capacity ceiling of ~100 records has been removed — the row-based weekly structure scales with fund growth without any structural changes or manual intervention
• Weekly data entry is now consistent and structured: opening balance, profit percentage, calculated profit, deposits/withdrawals, and closing balance are captured in a single row per investment per week
• All existing investment tables and records were retained intact — fund managers required minimal retraining and experienced no disruption to ongoing operations during the transition
• The dual-workflow architecture gives the client direct control over Make operation consumption, preventing subscription cost escalation as investor count grows

Technical Achievements

• Make automation establishes inter-row relationships in Airtable that its native automation engine cannot support, enabling accurate week-over-week balance calculations without manual data entry
• Row-based data model is directly compatible with Airtable’s views and reporting capabilities — the client now has a reporting-ready data foundation without additional tooling
• Two Make workflow variants (full-population and defined-week) provide operational flexibility and cost control across different fund management scenarios

Business Validation

• The client immediately requested additional enhancements to support parallel investment classes — a direct signal that the redesigned foundation met their operational requirements and that they trust the architecture to support further development
• Fund managers reported satisfaction with the solution, confirming that the redesign addressed their core pain points without introducing operational complexity