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
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 column to use the relation instead of the table.
i am actually quite new to all this, and I am having hard time understanding what u mean by:
Can u plz elaborate, 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.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
