Google Sheets converting UNIQUEID() ref keys to scientific notation…
Has anyone experienced GS converting a parent ID to scientific notation when a new related row is inserted in a related child table?
Until now, I have always used UNIQUEID() to generate IDs for all my tables and until now, this has worked without issue. Now it seems that GS is converting any IDs containing “E” to scientific notation. The ID 323290E3 will be converted to something like 3.23E+08 when creating a child row related to 323290E3.
Has anyone run into this and found a reliable workaround? I think the following expression should workaround the issue: =TEXT(SUBSTITUTE(UNIQUEID(),“E”,“A”))