I just started with glideapp and I’m building a custom inventory management app. I am trying to create the option for transfering goods/products from one warehous to another. Please any sugestion?
I already created the list of products, multi wearhouses, and need to register transfer products from main warehous to the others, but could not find the relation as it does not allow me to create a form which would allow me to chose the product, output from one warehouse, and than input to another warehouse.
So do you have a field to store the warehouse ID that is tied to the products in the Products table?
My thinking is, if you need to store the “log” of moving as well:
Create a Logs table.
In the details screen of the product, create a form that choose the new warehouse’s ID for the product to be moved to. Make sure you also log the product ID in the log.
Create a relation in the Products table using the product ID, to the Logs table.
Use a single column > last to get the last Warehouse ID tied to the product.
With the approach above, you would also need to think about how to log the first warehouse ID when the product is added to the system.
Hopefully you will find this Live Build from Loqode school helpful. Marco shows warehouse transfer set up in this video. Mind you, it is a multi-session build. The following is episode 2.
I am lacking my own Glide skills but want to be helpful to the community and Loqode school is where I dwell
I am also probably biased due to being his fiancé
I am lacking my own Glide skills but want to be helpful to the community and Loqode school is where I dwell 
