Imagine an architecture where transaction detail between users is embodied as text-based transaction objects in a long text field. You could store a list in a specific format that’s easily parsed, or as a JSON object as a collection of structured records. I’ve used this approach to create some very powerful one-to-many aggregations without ever using a single other record.
In my tests and in production, a single long text field can store far more than 200 lines of dense content, and likely more. This requires some careful programming using the script block or API but it would make it possible for 50,000 Airtable records to contain many hundreds of times that in detail transaction items.