how to separate numbers with a dash? I have pole field type "numbers" named "kod" with the postal codes, string of numbers 05430... How to separate these numbers to look like this 05-430 ?? I tried this formula but it doesn't work > CONCATENATE(LEFT({Code}, 2), "-", RIGHT({Code}, 3)) how to do it?
I'm trying to make a unique ID number for each project I'm tracking in airtable. Is there a way I can grab the first letter of the clients name, the last four numbers of their Phone number and the date it was created? Or maybe there is an easier way to make a simple ID number.
Interested in scaling your back end operations without doing it all alone? Schedule a call using www.optimizeis.com/main
great
You are a really good teacher Ben. Thank you!
Thank you so much Simon! Very much appreciated!
Merci beaucoup, tu m'as beaucoup aidé !
Je vous en prie !
Thanks!
You bet!
how to separate numbers with a dash? I have pole field type "numbers" named "kod" with the postal codes, string of numbers 05430... How to separate these numbers to look like this 05-430 ?? I tried this formula but it doesn't work > CONCATENATE(LEFT({Code}, 2), "-", RIGHT({Code}, 3)) how to do it?
Any way of editing custom text with formula applied? so each record would have custom text input plus what the formula adds at the beggining.
Yes, you can use the concatenate formula to do this. You have to have the text editable field as a separate field to the formula
I'm trying to make a unique ID number for each project I'm tracking in airtable. Is there a way I can grab the first letter of the clients name, the last four numbers of their Phone number and the date it was created? Or maybe there is an easier way to make a simple ID number.
Absolutely! Watch a video on this here -> ruclips.net/video/lR9j39ND7fw/видео.html