Database i'm having trouble with

[strawbs]

i have made a form in sheets and i’m trying to collect data from the form into the data sheet? but thing is everytime i enter the data into the form the persons name goes into the email section? when the persons name is meant to be going into the name section! heres the code

// Clear Form

function ClearCell() {

var ss =SpreadsheetApp.getActiveSpreadsheet();

var formS=ss.getSheetByName('Form'); //Form Sheet

var rangesToClear=["B6","B8","B10", "B12", "D6","D8","D10"];

for (var i=0; i<rangesToClear.length; i++) {

formS.getRange(rangesToClear[i]).clearContent();

}

}

//------------------------------------------------------------------

//input values

function SubmitData() {

var ss =SpreadsheetApp.getActiveSpreadsheet();

var formS =ss.getSheetByName('Form'); //Data entry Sheet

var dataS=ss.getSheetByName('Data'); //Data Sheet

var values = [[formS.getRange('B6').getValue(),

formS.getRange('B8').getValue(),

formS.getRange('B10').getValue(),

formS.getRange('B12').getValue(),

formS.getRange('D6').getValue(),

formS.getRange('D8').getValue(),

formS.getRange('D10').getValue()]];

dataS.getRange(dataS.getLastRow()+1,1,1,7).setValues(values);

ClearCell();

}

//---------------------------------------------------------------------

var SEARCH_COL_IDX= 0;

function SEARCH() {

var ss =SpreadsheetApp.getActiveSpreadsheet();

var formS=ss.getSheetByName('Form'); //Form Sheet

var str = formS.getRange('D3').getValue();

var values=ss.getSheetByName('Data').getDataRange().getValues();

for (var i =0; i <values.getlength; i++) {

var row= values[i];

if (row[SEARCH_COL_IDX] ==str) {

formS.getRange('B6').setValue(),

formS.getRange('B8').setValue(),

formS.getRange('B10').setValue(),

formS.getRange('B12').setValue(),

formS.getRange('D6').setValue(),

formS.getRange('D8').setValue(),

formS.getRange('D10').setValue()

} }}

//----------------------------------------------------------------------

function Update() {

var ss =SpreadsheetApp.getActiveSpreadsheet();

var formS=ss.getSheetByName('Form'); //Form Sheet

var dataS=ss.getSheetByName('Data'); //Data Sheet

var str = formS.getRange('D3').getValue();

var values=ss.getSheetByName('Data').getDataRange().getValues();

for (var i =0; i <values.getlength; i++) {

var row= values[i];

if (row[SEARCH_COL_IDX] ==str) {

var INT_R = i+1

var Values1 = [[formS.getRange('B6').getValue(),

formS.getRange('B8').getValue(),

formS.getRange('B10').getValue(),

formS.getRange('B12').getValue(),

formS.getRange('D6').getValue(),

formS.getRange('D8').getValue(),

formS.getRange('D10').getValue()]];

dataS.getRange(INT_R, 1 ,1 ,1, 7).setValues(Values1);

SpreadsheetApp.getUi().alert( 'Data Updated');

} }}

//-------------------------------------------------------------------------

function Delete() {

var ss =SpreadsheetApp.getActiveSpreadsheet();

var formS=ss.getSheetByName('Form'); //Form Sheet

var dataS=ss.getSheetByName('Data'); //Data Sheet

var ui = SpreadsheetApp.getUi();

var response = ui.alert('Delete ?' ,ui.ButtonSet.YES_NO);

// Process the user's response

if (response == ui.Button.YES) {

var str = formS.getRange('D3').getValue();

var values =ss.getSheetByName('Data').getDataRange().getValues(); //Data Sheet

for (var i =0; i <values.getlength; i++) {

var row = values[i];

if (row[SEARCH_COL_IDX] ==str) {

var INT_R = i+1

dataS.deleteRow(INT_R);

ClearCell();

}}} }

also heres the sheets link

google sheets

also the search isn’t working