Solved: Unique Code Creation customized way - Page 2

Saraappsheet · 08-24-2022 12:19 PM

Hi I would like to get advice on uniqeid creation, is there any way to make the customized auto generated unique id instead of what appsheet generate.

I would need to have DATE+Unique Alphaphat leters + Unique Number

Example : 08252022-ABC-0011

I tried to combine date clm + Row number but still it's not fulfilling my req. even date come as 08/25/2022

Any sollutions?

dbaum

Building on @SkrOYC's information regarding date:

CONCATENATE(
  TEXT(TODAY(), "MMDDYYYY"), 
  "-", 
  MID("ABCDEFGHIJKLMNOPQRSTUVWXYZ", RANDBETWEEN(1, 26), 1), 
  MID("ABCDEFGHIJKLMNOPQRSTUVWXYZ", RANDBETWEEN(1, 26), 1), 
  MID("ABCDEFGHIJKLMNOPQRSTUVWXYZ", RANDBETWEEN(1, 26), 1), 
  "-", 
  TEXT(RANDBETWEEN(0, 9)), 
  TEXT(RANDBETWEEN(0, 9)), 
  TEXT(RANDBETWEEN(0, 9)), 
  TEXT(RANDBETWEEN(0, 9))
  )

View solution in original post