Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to find the LEN of an 'Autonumber' field?

Topic Labels: Formulas
Solved
Jump to Solution
549 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi guys, I’m trying to create a unique alphanumeric code(length 4) out of Record ID and Autonumber. But I am getting an error while doing so. Is there any way to find it?

image

Thanks,
Chintan

1 Solution

Accepted Solutions

LEN() doesn’t work on numbers.

So try LEN({Random}&"") to force it to calculate for a string.

See Solution in Thread

2 Replies 2

LEN() doesn’t work on numbers.

So try LEN({Random}&"") to force it to calculate for a string.

This is perfect, thanks.!!