SCN2A
January 30, 2024, 7:24pm
1
Hi, I need to create a table with a column that acts as a counter (unique product code). I’m using Glide table and saw that rowid can be used. The problem is that it generates too complex code.
Can you help me?
Thank you in advance
SCN2A
January 31, 2024, 7:02am
3
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…
theoretically I know what needs to be done but it’s the first time I’ve used glide. Do you know if there is an example, a guide that can help me?
Each of the two examples in the linked post is accompanied by a video guide. Can you not follow those?