# Forwarding inventory number

**URL:** https://community.glideapps.com/t/forwarding-inventory-number/64456
**Category:** Ask for Help
**Created:** [July 28, 2023, 12:53pm UTC](https://community.glideapps.com/t/forwarding-inventory-number/64456 "2023-07-28T12:53:27Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Andreas\_Ramelsberger](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreas_ramelsberger/32/52780_2.png) [@Andreas\_Ramelsberger](https://community.glideapps.com/u/Andreas_Ramelsberger)
#### Post date: [July 28, 2023, 12:53pm UTC](https://community.glideapps.com/t/forwarding-inventory-number/64456/1 "2023-07-28T12:53:27Z")

</div>

Hey,

what is the best approach to create an inventory number that is forwarding.  
Like 000123 and that the next entry is 000124 and when a row is deleted its still the same number and so on.  
Does anyone has an approach for that?

Best  
Andi

---

<div class="post-metadata">

### Author: ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [July 28, 2023, 1:09pm UTC](https://community.glideapps.com/t/forwarding-inventory-number/64456/2 "2023-07-28T13:09:11Z")

</div>

The best approach is to delegate the task to a third party like Make or Zapier… then write it back using Glide API

---

<div class="post-metadata">

### Author: ![Andreas\_Ramelsberger](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andreas_ramelsberger/32/52780_2.png) [@Andreas\_Ramelsberger](https://community.glideapps.com/u/Andreas_Ramelsberger)
#### Post date: [July 28, 2023, 1:53pm UTC](https://community.glideapps.com/t/forwarding-inventory-number/64456/3 "2023-07-28T13:53:40Z")

</div>

Is there any other option? For me it would be nice to solve it without a third party tool.  
I also dont need a number that is in a row…

I thought I could use the first 8 digits of the rowid… but that is also not 100% sure right? So that it then appears that I have two times the same Inventory-Number.

Best  
Andi

---

<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: [July 28, 2023, 1:53pm UTC](https://community.glideapps.com/t/forwarding-inventory-number/64456/4 "2023-07-28T13:53:52Z")

</div>

See below. Just be aware that if your App is heavily used then there is a risk of duplicate numbers.

> [@How do I create an auto-incrementing row number with Glide Tables?](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572):
>
> This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…
