Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 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.

...

Email Size Exceeded Error

This section applies only to  Cloud Customers.

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 is to limit the upload 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.

...

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.)

  1. Launch Excel Spreadsheet. Click the Data tab. 
  2. Click the From Text/CSV icon. Use the file manager to locate the CSV file you want import.

  3. Click Import.

  4. Select Comma from the Delimiter dropdown. 
  5. Click Transform Data.

  6. 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.

  7. Click Close & Load.

...