Hi

I need help with two issues here.

Firstly, I have a formula I used in Airtable that creates a unique ID based on the row number, see below.

‘RL’ & RIGHT(‘0000000’ & Autonumber,7)

This will give the result: RL0000001 depending on what row number is used

I’ve tried to convert this to Coda but it gives me the output: RL 1

“RL” + " " + RIGHT(“0000000” + Autonumber, 7)

My second issue (well not an issue but more of a request), I would like to create a unique id that takes the first 4 digits of the name followed by a number. i.e. Name: Jo Bloggs Company, would be JOBL01. If this already exists then it would be JOBL02 and so on.

Here’s my formula but it will not add the 0 so it ends up being JOBL1, it won’t also check if it exists on a previous row and add as it get’s the 1234 etc from autonumber.

UPPER(LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Company Name]," “,”"),",",""),".",""),"/",""),"?",""),";",""),":",""),"’",""),"-",""),"!",""),"@",""),"&",""),"_",""),"+",""),"+",""),4)) + RIGHT(‘00’ + Autonumber,2)

Thanks