The Inventory consists out of three different Tables / Pages.
This is the primary table collecting all the rolls you currently have in stock 🙂
Here you need to insert the Film Name, Brand, Stock, ISO, Format, Process and the Expiration Date of every type of film you currently have in Stock.
In the field "Base Stock" you can add the current amount of film rolls you have. This is a one time task. After the initial creation the amount is tracked via the next two tables.
In this table you can keep track of your film purchases. Adding rolls here will automatically increase the amount in the Film Inventory Table.
Film Roll Purchases - Template 1
Here you just need to add the linked Film Stock as well as the number of rolls. If you like you can also add the Price.
In this table you can keep track of the film rolls you shot. Adding rolls here will automatically decrease the amount in the Film Inventory Table