I am trying to create an inventory management app that lets me check tools in and out from storage and updates their location in the app. I am able to create the entries for the check in/out with no issues, however, I would like these entries to update the location of these tools in my inventory view.
Currently, I have a "Tools" view which has the name, brand, serial #, and location of the tool. I have a "Tool Log" view that uses a form to create entries stating the tool's ID, whether its being checked in or out, and the location at which the tool is being checked in or out from a list of job sites. I can create entries perfectly fine, however, I cannot figure out a way to have these entries update the location field for these tools in my Tool view, which is linked to a different sheet than the log.
I have tried setting up bots to automatically update the tool location field when an entry is created but I cant seem to be able to figure out how. Both sheets have the tool ID, which is how I would know which tool's location to update, but there can be repeat tool IDs in the log view, which means I cant use the MAX() statement.
If there is any more information I can provide to help make a recommendation, please let me know. Any help would be greatly appreciated
LinkedIn
Twitter
