⚠️ AppSheet/Google Sheets recognized the ID as exponential function

I encountered a bug with one of my apps, and this might also affect yours, though the chances are very low due to the numerous combinations produced by using UNIQUEID().

Scenario:

The ID of the record in Table 1 is 981660e6. When I add or update a record in Table 1, it creates new rows in Table 2 through automation. However, when the automation finishes running, the app or Google Sheet returns 981660000000 instead of 981660e6 and will not return any child rows in the app

JuneCorpuz_0-1696952523067.png

 (This is the ID from Table 1)

JuneCorpuz_1-1696952535330.png


(These are the rows added in Table 2)

2 6 288
6 REPLIES 6
Top Labels in this Space