Forms data populating worksheet

jharper56136

I have created a form and I have it set to populate at the top of the worksheet.  I have a summary section at the top of the worksheet so I can show all the in progress, completed, etc. for all the contracts.  I need the form data to start below that summary level on row 7.  How do I set this up to happen.  When I set it to load at the bottom, it puts all the data way down on the sheet.

Andrée Starå

Hi,

Unfortunately, it's not possible to choose where the submissions should start except on the top or the bottom of the sheet. You could add them on the top and then move them down to after the summary.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

sean59916

Adding to Andrée's response, you could also, move your summary to another sheet and reference the data sheet, set the form data to submit to the top.

Paul Newcome

What do you mean by it puts it way down on the sheet? If you are referring to having a bunch of blank rows between your summary and first form entry, it could be that those empty rows just need to be deleted.

jharper56136

Thanks!  I will give that a try 1st.  I am not sure why it is putting them at the bottom.

jharper56136

Thanks so much!  I will give that a try.

jharper56136

Thanks Andree!  I will try a few things and see if it works.

Andrée Starå

Happy to help!

Best,

Amdrée

Paul Newcome

Happy to help. 

 

Regarding form entries, there are only two different types of rows, and forms can only populate one of those types.

 

There are blank rows. These HAD data in them, but the data has since been deleted. Even though there is no data in them, they are still considered as "used" and a form cannot populate them.

 

And there are unused rows. These rows have NEVER had any data in them. These are the types of rows that form entries can populate.

 

If you had test data or any other kind of data in a row and have the forms set to populate at the bottom of the sheet, the new entries will go to the first UNUSED row. That means all of those blank rows need to be deleted to move the first available unused row to the top of the sheet.