A few weeks ago I had an app with just one record that was behaving differently than the others. It kept losing references to child records. When I viewed the Google Sheet, the UNIQUEID() value had been auto-formatted in scientific notation, because it just happened to meet the format of [number] E [number], like 421e24.
I manually changed that one ID, and updated references in child tables. I figured the chances another key meeting that format were low enough that it wouldn’t be an issue. Then it happened again today.
This could be corrected by appending the UNIQUEID() with an &“x”, or some other character. Or you could turn off the default auto-formatting option in the Google Sheet. However, both these fixes require the developer to deploy the work-around in every app.
Since the default Google Sheet settings will interpret AppSheet’s UNIQUEID() improperly, I recommend that this be considered a bug. It will affect many new users who won’t think to deploy either of the fixes mentioned above.
Please consider updating the UNIQUEID() function to always end in a letter, or some other method of avoiding text strings that can be interpreted as scientific notation-- suddenly breaking the app due to the value UNIQUEID() returned.