LinkedIn
Twitter
On one app in one account, if I enter a something like "12:34:567" into a Time type column, it causes an error during sync.
In another app on a separate account, it does not cause an error during sync, appears to fully sync, but the new value is completely discarded, and the old value comes back. Then looking at the backend GSheet, the value did not ever change. But the audit log record of the change exists. Also, if I change any other columns at the same time, those changes never make it as well, and are reverted.
Seems obvious that the different accounts have different rollouts on them, where the validation is working differently, right?
------
We've seen many threads over the years about in-app changes not updating the backend. Typically it's due to bots or actions or resetOnEdit that the user setup but forgot about, but sometimes it seems to be unsolvable. I'm wondering if I've found an explanation for some of these things here. It seems like there are 2 validation systems, one on the app client-side that immediately informs the user of invalid data, and another on the server-side where it stores the new data into the source. If it passes the first validation, but not the second, it either throws an error, or just.... completely discards the change??
Typically that second validation is important for sources such as SQL where it has its own data types per column (or maybe even a 3rd validation step for that, who knows...). Not so much for GSheets where you can just format everything as plain text. Both the above tests were on plain-text formatted GSheets to avoid any conflicting issues there.
Does this make any sense?
Can anyone can test this 3 seconds digits in a Time value thing on their end and report back on what it does?
