Core Return Tracking

Hello,

I am currently working on setting up a Core Return Tracking workspace. We plan to track all of our parts in the system by adding them to a master sheet via a form.

Once a part is sold, we want the warehouse guy to be able to use a form type setup and just have to enter details on a few of the columns to update the core number, status, tracking information, carrier, and an image of the part.

Same situation when the core is received, he needs to be able to just quickly enter a core number and update a couple specific columns

- Possibly an index collect helper or something to use the core number he enters to update the row that has the same core number?

Is there a way to do this without having to require him to use a whole spreadsheet or report?

We are trying to keep it as simple as possible.

Answers