How to update checked in/out status in inventory list based on latest form response

Hello everyone,

I am trying to build an inventory management system for the company I work for, where employees will be asked to fill in a form every time they borrow a piece of equipment as well as when they bring it back.
Now I've managed to set-up most things I need, including to calculate for how long an item has been out and to process the data to show me if something has not been checked back in etc..
What I still can't figure out is how to have an automatic update in the inventory list of the status of each item based on the latest form response, considering that an item can be multiple times in and out. Basically I just want in the inventory list, at the borrowing status to have "IN" or "OUT" next to an item so I can have a direct overview, without having to manually input this info every time someone fills in a form.

Hope that I've explained clearly enough and that someone has an idea. I would really appreciate it.


image 1 forum.png
image 2 forum.png
image 3 forum.png