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
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.
...
| Code Block |
|---|
18:07:09.654 |-ERROR [http-nio-8082-exec-3] [.s.s.FormSubmissionService] [mycompany designer] [5750c49b-be25-4715-81f1-2d3a94c30e1b 76DF75577B56B8BBEE392ACB16CEE3CE] [ ] - Could not send submission to insight server. org.springframework.data.solr.UncategorizedSolrException submission to insight server. org.springframework.data.solr.UncategorizedSolrException: Server refused connection at: http://localhost:8983/solr/mycompany; nested exception is org.apache.solr.client.solrj.SolrServerException: Server refused connection at: http://localhost:8983/solr/mycompany; nested exception is org.apache.solr.client.solrj.SolrServerException: Server refused connection at: http://localhost:8983/solr/mycompany |
...
Reports will show the message "No data available in table". Once the Insight server is restarted, the submissions will show in the Recent Submissions report and submissions will redisplay reporting the error. Remember, the Error Description column is the last default column in the Submission table.
Email Size Exceeded Error
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 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 except to limit the upload control max size and/or min # properties. 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.
...
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 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.
...