How can I generate numerical code with UniqueID()

AppSheet AppSheet Q&A
, ,
1

Hello guys

How can I generate a 5-digit numerical code with UniqueID()

2

Sure, here’s the translation:

Actually, I only need to generate a 5-digit numeric code.

I already managed to do it, but the problem is that when I want to edit the record, it says “Invalid input”.

3

This formula has worked well for me RANDBETWEEN(10000, 99999)