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
-
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!
Answers
-
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!