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
(This is the ID from Table 1)
(These are the rows added in Table 2)
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |