Hi, it happened to me suddenly that adding data from Form shows in App but not written to Google Sheet.
I did not use any array and no data was appearing in the last line. I tried to insert an entry from GlideApp Data and it worked. The data appeared just below my last last data line in Google sheet (and not the last row). Inputting data from Google sheet also worked well, the Glide App was able to see it.
The problem remains that adding data from Form shows up in Glide App data but not written to Google Sheet.
Any expert can advise please?