frevvo comes with a built-in submissions repository. The repository can run on top of most SQL databases. By default, your form data is stored in the repository and can be viewed from the Submissions page. Fields in your form/workflow, set up as Searchable fields by the designer, can be used as criteria when searching submissions. You can also filter by default fields such as error, error description, submitter id, lock user id, started date, etc. The Insight Server and the Insight service must be running for the Submission view to work.
...
The frevvo mail server limits email size to 30MB. If emails sent in Activity Doc Action or Document Actions exceed this limit, your tenant admin may receive an email bounceback from "Mail Delivery System <"MAILER-DAEMON@sysops+stage"@frevvo.com>" that contains an error like this "message size 34559092 exceeds size limit 31457280 of server smtp.sendgrid.net[107.20.8.136]".
The only workaround for this issue at this time is to limit the Upload control max size and/or min # properties in your form. If you have a submission that has hit this error, you must edit the submission, delete some of the attachments and then resubmit.
Editing Submissions
Only submissions in the SUBMITTED state can be edited. If you have the correct permissions, submissions can be edited easily by clicking the form name rendered as a clickable URL on the submission. In this image below click on "Product Order Form" to edit the submission.
...
- Perform the submission query so the data that you want to download displays in the table. The SubmissionTable 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.
...
This happens because Excel makes assumptions about the way imported data should be formatted; usually leading zeros are mathematically insignificant, so they are removed. You can keep the leading zeros in CSV files by using Excel's Text Import Wizard. (These instructions may vary based on your Excel version.)
- Launch Excel Spreadsheet. Click the Data tab.
Click the From Text/CSV icon. Use the file manager to locate the CSV file you want to import.
Click Import.
- Select Comma from the Delimiter dropdown.
Click Transform Data.
Select the column(s) that contains the data with leading zeros. Change the Data Type to "Text". The preview will refresh to show your data with leading zeros.
Click Close & Load.
...