How to create an Inventory Check In & Check Out System?

Hi Everyone,

I’m trying to create a checklist or switch buttons to check out equipment, check in equipment and collect data on which user checked out & in each piece of equipment.

If the equipment is checked out on the Check Out page, it will populate as an option on the Check In page and vice versa. I’ve tried variations of Boolean & Not statements but can’t find a solution.

Any thoughts?

I think you can just have two lists on two different tabs, then have buttons that are appropriate to them.

In the Check In page, assuming a “true” boolean shows equipments that are checked in, you show a list filtered by boolean is not checked, and your button would set the boolean column to true.

Vice versa for the Check Out page.