Skip to main content
Solved

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

  • May 30, 2021
  • 2 replies
  • 59 views
C
Forum|alt.badge.img+3

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?

Thanks,
Chintan

Best answer by Kamille_Parks11

LEN() doesn’t work on numbers.

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

2 replies

Kamille_Parks11
Forum|alt.badge.img+27

LEN() doesn’t work on numbers.

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

C
kuovonne
C
Forum|alt.badge.img+3
  • Chintan_Savali1
  • Author
  • Known Participant
  • May 30, 2021

LEN() doesn’t work on numbers.

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


This is perfect, thanks.!!

Terms & ConditionsAccessibility statement