Creating Length formulas


I have installed baserow self-hosted on windows 10 using dockers.

I need help for a formula which i was usingin Airtable

In column “ID” i have values like DA03.2278733 or DA03.7474 and DA03.228964 . I want to create another column “Barcode” and want these values to be converted into 0002278733 or 0000007474 and 0000228964 for barcode machine which recognizes 10 digit format with leading Zeros automatically added if number length after “DA03.” is less than 10.

What formula can i use? can anyone post the correct formula for it


You can do this with a pretty long if…else statement checking the value of the number: Better number formatting - #4 by frederikdc