I need to make a customized unique code for each object. For that I need an index. Index is incremented each time new item is created, but it should start from zero again in the next year. And process should happen over and over Can u anyone tell me how to do it? Thank u

When you set up a lookup column, you can choose between tables and relations. Be sure to choose the relation. It sounds like you already have a lookup column, but you just need to make a small change to it to use the relation instead of a table. [Screenshot_20240729-231701]

[image] How do I create an auto-incrementing row number with Glide Tables? Community Resources 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.…

Sounds helpful, I think it helps. Thank u very much.But I am particularly struggling with index that starts from 0 every next year. Can u help me with it too?

Which numbering method are you using?

First, in a separate column, I gathered all row ids using look up. Then, I found index of each row id in row ids array I got using look up. But I think this is not effective method since literally a lot of row ids will be continuously saved

That method shouldn’t be a problem. It’s all computed columns. It’s not saving anything anywhere. To have the number start over with zero each year (assuming you already have a column with the year), you just need to add a relation column linking the year column to itself. Then change to Lookup …

i am actually quite new to all this, and I am having hard time understanding what u mean by: [image] Jeff_Hager: Then change to Lookup column to use the relation instead of the table Can u plz elaborate, thank u

Auto increment index

Ask for Help

Jeff_Hager July 26, 2024, 6:38am 2

Topic		Replies	Views
Fullproof autonumber with native Glide columns Community Resources tutorial	11	986	May 21, 2023
How do you have a column index that can count from 1 to 100? Ask for Help	2	933	April 22, 2022
Does glide have auto increment id ?or number other than this one Ask for Help	2	199	November 25, 2024
How to create index numbers in columns, autocomplete addresses Robert pettito Ask for Help	4	438	September 29, 2023
How do I create an auto-incrementing row number with Glide Tables? Community Resources tutorial	54	10559	April 18, 2025

Auto increment index

Related topics