Forwarding inventory number

[Andreas_Ramelsberger]

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

[Eric_Penn]

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

[Andreas_Ramelsberger]

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

[Darren_Murphy]

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?

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…