Help

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

Topic Labels: Formulas
Solved
Jump to Solution
1810 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Chintan_Savali1
6 - Interface Innovator
6 - Interface Innovator

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
Kamille_Parks
16 - Uranus
16 - Uranus

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
Kamille_Parks
16 - Uranus
16 - Uranus

LEN() doesn’t work on numbers.

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

This is perfect, thanks.!!