...
- Perform the submission query so the data that you to download displays in the table. The default columns in the submission table appear in the spreadsheet even if you are not displaying them in the table. Hide the columns in Excel if you do not want to display them in your spreadsheet.
- Click the Download button to save the csv file.
- Open the file in Microsoft Excel.
- Show/Hide columns in the spreadsheet if desired.
Switching from Export to Excel to CSV Download
Cloud Customers:
The maximum number of Searchable fields
- Edit each form/flow where Export to Excel is configured
Click the Setup Searchable Fields link
Click the Saved Fields tab and review the fields previously set up as Saved Fields
Click the Searchable Fields tab and add every field into the Searchable Field list that was in the Saved Fields list
Save your changes
Email support@frevvo.com to request that the Insight Batch job be run on your tenant if you want to update older submissions with the changes.
- In-house Customers:
If you have forms/flows exporting more than 20 fields to Excel, add the frevvo.max.searchable.fields parameter to the frevvo.xml file
Change the value to the number of searchable fields that you want.
Edit each form/flow where Export to Excel is configured
Click the Setup Searchable Fields link
Click the Saved Fields tab and review the fields previously set up as Saved Fields
Click the Searchable Fields tab and add every field into the Searchable Field list that was in the Saved Fields list
Save your changes
Manually run the Insight batch job to if you want to update older submissions with the changes.
Changing the Column Order in the CSV file.
...