Start a new topic

New Entry via Google Forms shifts the row in sheets

Hi, 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. Please assist.

1 person has this question
Login or Signup to post a comment