Creating Check out/in sheet and form?

Is it possible to create a check out/in sheet and form where the entries from the form will land on the same row?

I want to create a form where people can check things out/in on the same date. So I'd check things out the in the morning of 8/2 and check them in at closing time. I want all the data to land on the same row so I can run formulas (like Number of items out minus numbers in) to ensure items are not lost.

Is this possible? Any guidance or insights is much appreciated.

Best Answer

Answers