Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formatting an autonumber [SOLVED]

7557 6
cancel
Showing results for 
Search instead for 
Did you mean: 
nnnnneil
8 - Airtable Astronomer
8 - Airtable Astronomer

I’m trying to automate an order ID. So when a new row is added, it is given an automatic ID. The existing ID from pre-AirTable looks like: LS000000

E.g. LS and then six zeros. The first order should look like LS000001, the next order like LS000002 etc

Currently I use:

Field 1 - AutoNumber (AutoID)
Field 2 - Formula = CONCATENATE(“LS00”, (AutoID))

Which gives LS001, LS002 etc. It looks right when we get to LS001000 e.g. all 6 digits now present.

Any ideas how to force the six zeros from the start?

6 Replies 6

You need to count the ID characters and fill with zeros till 6.

'LS' & REPT(0,6-LEN(CONCATENATE({ID}))) & {ID}

a3ff30394816da2e6495a74a1c3b1189939c6e5b.png

nnnnneil
8 - Airtable Astronomer
8 - Airtable Astronomer

Awesome! Thanks :grinning_face_with_smiling_eyes:

Just an alternative solution, for fun:
“LS” & RIGHT ( “000000” & ID )

I don’t understand :thinking:

Captura de pantalla 2018-07-19_02-57-27_p. m..png

I think you meant: 'LS' & RIGHT('000000' & ID,6)

A lot cleaner :grinning_face_with_sweat:

Oups !
Yes that’s it, six digits from the right. !
Sorry !

NLOIA
6 - Interface Innovator
6 - Interface Innovator

Nice!

But I'd like to go further: I need automatic numbering as a Taxonomic Numbers: 1.; 1.1; 1.2; 1.2.1; 1.2.2; 1.3; .....

I tryed through this post:  How to automatize hierarchical or outline numberin... - Airtable Community, but no answer at all.

Does anybody have a hint for me?