UNIQUEID() Key value is calculated with exponentation

[Kawano164]

Hi, every community member. This community encourages me a lot.

I have a problem with the key value. Would anyone give me some advice?

I have the enum list column for selecting keys generated by UNIQUEID(). And 599829e6, one of the key values is forcibly calculated with exponentiation as below.

①just after saved

 

② 2-3 seconds after saved 

The column detail is below. Although I set the base type as "text", it's always calculated automatically.

If I select two values, 599829e6 won't be calculated as below.

Thank you in advance for advice.

Regards

[WillowMobileSys · Accepted solution]

More than likely your datasource is treating the values as numbers instead of plain text.  What are you using for your datasource?  If a Google sheet, then set the column in the sheet as plain text.

[Kawano164]

@WillowMobileSys  THANK YOU!!

I use Google sheet for the data source. After I've changed the GS column type to plain text, the problem never occurs.

Thanks a lot.