Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
Solved
Jump to Solution
1951 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.!!