This is a sample base demonstrating an approach to check-out / check-in processing in Airtable, such as might be used for a media library, or for tracking loans from an inventory of tools, equipment, props, wardrobe, … whatever!
Most notably, this implementation tracks the full history of who had what, when, in dedicated tables that can be searched, sorted and filtered as needed. Lookup/Rollup and formula fields are used behind the scenes to put relevant linked values in view where they're needed most.