Help creating 3-digit padded ID formula in Coda

1

Hi everyone! I’m trying to make a formula that creates an ID in this format: XXX-YYY, where XXX is the country code and YYY is the site code.

Both should always be 3 digits, even if the number is short (e.g. 9 → 009, 45 → 045).

What’s the best way in Coda to left-pad a number to 3 digits before concatenating?

1 Like
2

hi @Elaina_Kreher ,

the left-pad is indeed a good suggestion.

what about this:

image
image1870×496 43.6 KB

Cheers, Christiaan

3 Likes
3

This works perfectly, thank you!

Best, Elaina

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.