Solved: Item ID interpreted as number in scientific e nota... - Page 2

Rafael_ANEIC-PY · 12-01-2021 05:56 AM

Hello friends, i’ve had some weird occurences using unique_id(), generally when it generates an all-numbers combination, but today I found a new one !

I got an item with this unique_id() generated ID: 394677E6

The above item was referenced in another table, and it’s ID was saved in an appropiate [Item_ref] column, but it saved the reference as 3.95E+11, which throws the reference off in my app.

The fix is trivial, just change both ID’s, but how can I prevent this from happening again?

Suvrutt_Gurjar

Please check if the column type for UNIQUEID() column in the backend is set to “Automatic” . If so please change it to “Plain Text”. I think with column type as automatic, the UNIQUEID() having “E” is treated as a scientific number.

@Steve recently shared these useful tricks on spreadsheet formatting.

View solution in original post

Item ID interpreted as number in scientific e notation