- I want to export more than 10,000 submissions
- I want to hide fields that are exported even though I thought I had deleted them
- I changed the order of the form fields, but it doesn't reflect in the exported data
- I want to transfer the data of the card within the same team, or to a form of another team
- I want to change the order of data fields on the spreadsheet
- I've integrated with the Spreadsheet (automatic output), but the data is no longer being reflected
The maximum number of submissions that can be exported at once is 10,000. Therefore, if you want to export more than 10,000 submissions, you'll need to divide it into multiple exports.
For this, please go to "List page>Advanced Search" and filter by Keyword, Card No., Status, Assigned Person, Current Situation, Label, Period, Date and Time. Then export multiple times based on these filters.
(Example) When filtering by Card No, please split the export into multiple parts, such as Card No. 1~10,000 and Card No. 10,001~20,000.
Note: If you have more than 10,000 form submissions and you try to export without filtering, the following modal will be displayed.
We also recommend using the auto-output feature to Google Spreadsheet, which automatically exports data every time a form submission is received. There is no maximum export limit when using this feature.
In formrun, even if the fields shown to end-users are deleted, those fields remain in the database (on the admin page).
The reason for this is to prevent the loss of data that was received in the past when changing the content of fields after publishing the form.
You can rearrange or delete fields on the database via the settings page. Once you organize the fields there, those fields will not be visible in the exported data.
For details on how to manage data fields, please check "Q6: I want to delete fields that are displayed on the card or list even though I thought I had deleted them".
Exports are not based on the form as seen by the end user, but
on the data fields displayed on the card.
Therefore, if you want to reflect the order change of form fields in the exported data,
you need to change the order of the data fields.
For organizing data fields on a card, please see "Q6: I want to delete fields that are displayed on the card or list even though I thought I had deleted them".
The URL of the form created with formrun is consistently
http://form.run/@◯◯ (any alphanumeric characters).
If you want to use the form with a domain on a different server,
we would appreciate if you could handle it with embedding.
If you want to transfer form submissions (card information) from Form A to Form B,
export all cards from the list page of Form A and
import them to Form B.
For tips on importing, please see here.
When you export submission data, you can change the order of data fields on the spreadsheet.
However, the method of changing the order of data fields differs for CSV Export Google Spreadsheet manual output and Google Spreadsheet automatic output.
For details on how to change the display order of data fields, please see here.
For the method to change the order of data fields in Google Spreadsheet automatic output,
since the output specification is based on the order of fields when the form was first created, please drag and drop columns in any order on the desired spreadsheet.
I have set up Google Spreadsheet integration (automatic output), but the data is no longer reflected.
The cause may be that the Google account selected for integration is no longer able to connect properly.
In the "Link Google Account" modal displayed when you click "Link" in the "Google Spreadsheet Integration" of the "Form > External Integration Settings" page, please use the same Google account and try linking again.