Creating Check out/in sheet and form?

mistone
✭✭
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
-
Kelly P. ✭✭✭✭✭
Form entries cannot land in the same row. However, you could use a form entry to check out and then use an update request to check in.
Hope this helps!