# Transfer number of products from one warehouse to another

**URL:** https://community.glideapps.com/t/transfer-number-of-products-from-one-warehouse-to-another/71938
**Category:** Ask for Help
**Created:** [March 22, 2024, 8:50pm UTC](https://community.glideapps.com/t/transfer-number-of-products-from-one-warehouse-to-another/71938 "2024-03-22T20:50:58Z")
**Posts on this page:** 10
**Page:** 1

<div class="post-metadata">

### Author: ![Hkz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hkz/32/66778_2.png) [@Hkz](https://community.glideapps.com/u/Hkz)
#### Post date: [March 22, 2024, 8:50pm UTC](https://community.glideapps.com/t/transfer-number-of-products-from-one-warehouse-to-another/71938/1 "2024-03-22T20:50:58Z")

</div>

Hello

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.

Thanks in advance.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 23, 2024, 1:54am UTC](https://community.glideapps.com/t/transfer-number-of-products-from-one-warehouse-to-another/71938/2 "2024-03-23T01:54:59Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Nataliya\_Kovaleva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nataliya_kovaleva/32/67518_2.png) [@Nataliya\_Kovaleva](https://community.glideapps.com/u/Nataliya_Kovaleva)
#### Post date: [March 23, 2024, 3:51am UTC](https://community.glideapps.com/t/transfer-number-of-products-from-one-warehouse-to-another/71938/3 "2024-03-23T03:51:05Z")

</div>

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.

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7eb834de339b36ae0fc106f0998393b03bbe71f6.jpeg "🛠️ Live Build Session - Ultimate Inventory App (Part 2) - 20th July, 2023") ](https://www.youtube.com/watch?v=M2xkIwWtAjc)

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 23, 2024, 4:01am UTC](https://community.glideapps.com/t/transfer-number-of-products-from-one-warehouse-to-another/71938/4 "2024-03-23T04:01:48Z")

</div>

Are you Marco’s new marketing manager? 😂

(just kidding - his stuff is always great)

---

<div class="post-metadata">

### Author: ![Nataliya\_Kovaleva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nataliya_kovaleva/32/67518_2.png) [@Nataliya\_Kovaleva](https://community.glideapps.com/u/Nataliya_Kovaleva)
#### Post date: [March 23, 2024, 4:32am UTC](https://community.glideapps.com/t/transfer-number-of-products-from-one-warehouse-to-another/71938/5 "2024-03-23T04:32:16Z")

</div>

😅 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é 😊

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 23, 2024, 8:20am UTC](https://community.glideapps.com/t/transfer-number-of-products-from-one-warehouse-to-another/71938/6 "2024-03-23T08:20:09Z")

</div>

> [@Nataliya\_Kovaleva](#):
>
> I am also probably biased due to being his fiancé 😊

Today I learned. We can allow this type of bias 😅 .

---

<div class="post-metadata">

### Author: ![Hkz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hkz/32/66778_2.png) [@Hkz](https://community.glideapps.com/u/Hkz)
#### Post date: [March 23, 2024, 7:01pm UTC](https://community.glideapps.com/t/transfer-number-of-products-from-one-warehouse-to-another/71938/7 "2024-03-23T19:01:25Z")

</div>

> [@ThinhDinh](#):
>
> - 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

Thanks a lot ThinhDinh for your instruction, for sure need to work more on these.

---

<div class="post-metadata">

### Author: ![Hkz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hkz/32/66778_2.png) [@Hkz](https://community.glideapps.com/u/Hkz)
#### Post date: [March 23, 2024, 7:09pm UTC](https://community.glideapps.com/t/transfer-number-of-products-from-one-warehouse-to-another/71938/8 "2024-03-23T19:09:00Z")

</div>

I found it very helpful, there are many good things that I’m going to implement.

Please, may you share with me also the other parts/episodes of same Build Session? I checked in YouTube channel, seems that are not listed…  
🤝

Thanks a lot 👋

---

<div class="post-metadata">

### Author: ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)
#### Post date: [March 23, 2024, 7:15pm UTC](https://community.glideapps.com/t/transfer-number-of-products-from-one-warehouse-to-another/71938/9 "2024-03-23T19:15:59Z")

</div>

Have you checked at [http://loqode.com/](http://loqode.com/)

---

<div class="post-metadata">

### Author: ![Hkz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hkz/32/66778_2.png) [@Hkz](https://community.glideapps.com/u/Hkz)
#### Post date: [March 23, 2024, 7:33pm UTC](https://community.glideapps.com/t/transfer-number-of-products-from-one-warehouse-to-another/71938/10 "2024-03-23T19:33:18Z")

</div>

yep. I just asked for joining 🙂

Thanks
