There are times when users submitted a form (in my case it is a pre-booking for limited edition cassette tape.) within millisecond and it seemed like glide will forget to bring me the very last string. Still not sure why.
as you may see these 2 rows happened between the milliseconds. As you can see here even the rows are a bit out of place, not even sorted correctly.
Next 2 pictures show that the SKU column supposed to receive the value from the form itself, but it did not. This became problematic in displaying the calculated results as you can see N/A appeared in other cells of the row.
how the app looks like
how the SKU cell had not filled with the word “retrospect1”
Is there any way to avoid this? Or if this happened from me arranging the code in a wrong way? kindly suggest. Thanks!