Library and Self Check out Help

Hi everyone,

i feel like this might not be possible but thought i would give it a try.
i’m building a library at my business where students can check out equipment to use at home.

i will have a specific number of items and was hoping that i can have them check out the equipment using a form view. i cant seem to figure out how to build an inventory system that will stay up to date with the equipment that currently available.

any thoughts or samples out there?

appreciate any help on this!

Hey there! Give this one a go, courtesy of the Airtable Universe: