I have a google spreadsheet that connected to the google form, this form has the name, family name, email address and... questions.
I want my spreadsheet takes name and family name and combine them and put them in the desired column each time someone submits a form.
for example, I submit a form with name: ExampleOne, family name: ExampleTwo; this two value go to row 2, column A in sheet 1 and row2, column B in sheet 1 I want this to combine them and the spreadsheet put them together in row 2, column K.
I don't know js well so if you want to tell me a solution with the script, please write it with good details.
thanks so much.