I created a Google Sheet that will record entries from Google Forms. There are many people that submit their respective facility's information before this google Forms.

I have pasted all data into that Google Sheets which records the entry from Google Form Whenever any new entry is submitted through google Forms it Overwrite the data that i have pasted manually.

I hope there will be solution to it. Your help will be much appreciated.

CodePudding user response：

Is this the Form Responses Sheet? The issue is that forms doesn't detect whether that row is populated or not. It depends on the count of responses rather than the content of the sheets.

I recommend that you create a sheet similar to the Form Responses where you do your manual inputs there, while the Form Responses sheet will handle form submissions.

Then you collate both sheets' data into another sheet which combines both form data and manual inputs.

Form response sheet:

Manual input sheet:

Output:

Step by step:

1. Add the header first

'Form Responses 1'!A1:C1;

2. Add both data from form and manual sheet, then sort them using the timestamp (1st column)

sort({
filter('Form Responses 1'!A2:C, 'Form Responses 1'!A2:A <> ""); 
filter('Manual Inputs'!A2:C, 'Manual Inputs'!A2:A <> "")
}, 1, true)

3. Wrap them all in a curly bracket and output as 1 formula.

Final formula:

={'Form Responses 1'!A1:C1;
sort({
filter('Form Responses 1'!A2:C, 'Form Responses 1'!A2:A <> ""); 
filter('Manual Inputs'!A2:C, 'Manual Inputs'!A2:A <> "")
}, 1, true)
}

Submitted another form response: