How to add a line break in the integrated Google Sheets

Sehr geehrte Damen und Herren,

Ich möchte ein Formular, als Anmeldeformularerstellen.

Allerdings habe Ich das Problem, dass es mir bei mehreren Personen, alle Personen bei Excel in eine Zeile schreibt.

Ist es möglich, einen Zeilen Umbruch im Excel einzustellen?

Mit freundlichen Grüßen

Dominik Maier

Hello Dominik,

Thanks for reaching out to Jotform Support. Our German Support agents are busy helping other Jotform users right now, so I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in German, let us know and we can have them do that. But, it might take a while until they're available again.

Now, coming back to your question, I looked at the URL to your form and found that Person 1 and Person 2 both have their own form fields, which link to one column. It is only possible if you are the one who will manually add a line break to your Google Sheets.

Reach out again if there’s anything else we can help you with.

Vielen Dank, für Ihre Antwort,

Dies bedeutet, dass es nicht möglich ist, mehrere Personen in einem Formular einzutragen, und diese in verschiedenen Excel Zeilen zu bekommen?

Mit freundlichen Grüßen

Dominik Maier

Hello Dominik,

Please note that each submission will be placed into a single row. That being said, every additional submission you submit will be added to the row below. Take a look at the screenshot below to see my results:

Reach out again if there’s anything else we can help you with.

Das habe Ich verstanden, allerdings hätte Ich gerne Person 1 und Person 2 in verschiedenen Zeilen

Hello Dominik,

You can use the Configurable List Widget, so the respondents will get the option of adding another set of the same questions for another person just in the same line.  Let me show you how it's added to your form.

1. In Form Builder, click on the Add Form Element menu. 
2. Under the Widgets tab, drag and drop the Configurable List Widget to your form.
   
   
3. Then, configure the type of fields based on your preference.
   
   

Check out the screencast below to see my results:

We also have a guide about How to Set Up the Configurable List Widget that you can check out.

Give it a try and reach out again if you have any other questions.

Vielen Dank für diese Möglichkeiten.

Ist es auch Möglich, die Werte in eine bestehende Excel Tabelle einzuspielen?

Hello Dominik,

Did you mean you want to integrate your existing submissions to an existing Google Spreadsheet? If so, yes it's possible. Let me show you how to set that up:

1. In Form Builder, in the orange navigation bar at the top of the screen, click on Settings.

2. Click on Integrations on the left side of the screen.

3. Select the Google Sheets Integration.

4. Now, select or connect your Google account.

5. Click on Use an Existing Spreadsheet.

6. Select your Google Spreadsheet and your form fields.

7. Now, click on Save and you're done.

We also have a guide about How to Integrate Forms With Google Sheets that you can check out.

Give it a try and reach out again if you have any other questions.