Help

Costum ID

Topic Labels: Formulas
Solved
Jump to Solution
1693 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Konstruction
4 - Data Explorer
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
TheTimeSavingCo
18 - Pluto
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:

Screenshot 2023-01-28 at 10.47.15 PM.png
Here's a link to a base where this is set up that you can duplicate and play with

See Solution in Thread

3 Replies 3
TheTimeSavingCo
18 - Pluto
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:

Screenshot 2023-01-28 at 10.47.15 PM.png
Here's a link to a base where this is set up that you can duplicate and play with

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