# Re: Costum ID

Solved
1186 1
cancel
Showing results for
Did you mean:
4 - Data Explorer

Hi there. I'm trying to make a custom auto number. The constant is kasse 00 and then want the autonember to be kasse 001, kasse 002, kasse 003 and so on. Can anybody send me in the right direction?

And off cause will there be a problem when I reach kasse 010. It needs to be kasse 010 and not kasse 0010

best regards

Thomas

1 Solution

Accepted Solutions
18 - Pluto

Try out this formula:

``````SWITCH(
LEN(CONCATENATE(ID)),
1, "kasse 00" & ID,
2, "kasse 0" & ID,
3, "kasse " & ID,
'Default'
)``````

Which should give you this:

Here's a link to a base where this is set up that you can duplicate and play with

3 Replies 3
18 - Pluto

Try out this formula:

``````SWITCH(
LEN(CONCATENATE(ID)),
1, "kasse 00" & ID,
2, "kasse 0" & ID,
3, "kasse " & ID,
'Default'
)``````

Which should give you this:

Here's a link to a base where this is set up that you can duplicate and play with

4 - Data Explorer

It works... Thanks a lot. Btw. Is it possible to switch the 2 column. I need the kasse 001 numbers as but not the ID and when ID is in the first row I can't hide it

Regards Thomas

Hm, I don't fully understand what you're asking,  sorry.  If it helps, the column order doesn't matter; as long as the formula's pointed at the right field name it'll work