Inventory Check In/Check Out with Forms

MMaydel

Hey Everyone,

I'm looking for how to automate a check in/check out process utilizing forms.

What I want:
Tech fills out form with the item's serial number and checks a box for if they're checking in or checking out

This creates a new row in a helper sheet (CHECK OUT)

A master inventory sheet (EQUIPMENT) update's the availability of that item based on matching the serial number

How do I get this to work based on the latest entry for that serial number on the helper sheet?

I tried =INDEX({B6NA CHECK OUT Equipment Inventory Range 1}, MATCH([Barcode Number]@row, {B6NA CHECK OUT Equipment Inventory Range 2}, 0))

{B6NA CHECK OUT Equipment Inventory Range 1} is the checkbox column indicating it's checked in

{B6NA CHECK OUT Equipment Inventory Range 2} is the column containing the serial number

I know this isn't right because if a new entry is added that matches the other criteria and the check in box isn't checked, it isn't unchecking it in the master sheet. I don't understand how to add an IF THEN statement that checks or unchecks based on if the check in box or check out box is checked in the latest entry.

Paul Newcome

Are you able to provide some screenshots for context?