JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Google Spreadsheet Integration: Merge submissions dated last 6 months?Asked by stevedellar on October 13, 2016 at 09:15 AM
I need to integrate the last 6 months is that possible that would be best for me?
I do this in sheets by =QUERY(Submissions!A1:BL,"Select * ORDER by A DESC LIMIT 600 ",1)
but by data will soon exceed google limits
I'm sorry, I'm not sure if I understood your concern.
If you integrate a form to Google spreadsheet, it will automatically fetch all existing submission of your form and populate it on the new spreadsheet that was created after the integration.
If you could provide us more details of what you would like to do, please do share.
We'll wait for your response.
This is because the data may exceed the google sheet limit for the number of cells used
According to Google docs...The theoretical limit of the number of rows in a spreadssheet is 200,000 rows, provided you have one sheet and a single cell wide column. See also the limits below.Spreadsheets Each spreadsheet can be up to 256 columns, or up to 200,000 cells, or up to 100 sheets -- whichever limit is reached first. There's no limit on number of rows. Each spreadsheet can have up to 20,000 cells with formulas. Of this total, the following limits apply:You have a limit of 1000 spreadsheets. The spreadsheets that are shared with you do not count against 1000 limit. Up to 1,000 GoogleFinance formulas Up to 1,000 GoogleLookup formulas Up to 50 Import formulasThe limit on spreadsheets open at one time is 11.
I assume you want to download all of the existing submission data from 6 months of a single form. You can just download it as CSV file format and then use another external editor to combine all the CSV data. I as far as I know you can import the CSV file into google spreadsheet as well.
You can import the CSV data in single column in spreadsheet and it will have a limit of 200,000 rows approx.
Hope this help. Let us know if oyu need further assistance.