New Entry via Google Forms shifts the row in sheets
started a topic
7 months ago
I tried to use Document Studio to create a booking system, similar to the cake example as demonstrated on the YouTube video.
The problem I encountered was everytime I entered data via Google Forms to Sheets, the row was moved downwards. As a result of this, the vlookup formula was not able to fetch the price, because the search_key encountered a blank cell. This led to the invoice being generated without any amount.