Versions Compared

Key

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

...

This is the most common type of form where you drag and drop controls from the palette. The form is shown below in the Designer. It contains a Section named Personal. Inside this Section there are two Panels. Each panel has two controls. Below this Section is a Repeating Section called Incident which itself contains two controls.

 

Image Removed

Image Removed

 

 

...

Section
bordertrue
Column
width100px

 Image Added

Form with Section and Repeat

Column
width100px

Image Added

Use Mode form filled with data

...

The form is shown filled in above. We've filled in all the fields and added a second repeating incident. When the form is submitted, frevvo generates an XML document that looks like the one below:

...

Code Block
languagehtml/xml
<ns:form xmlns:ns="http://www.frevvo.com/schemas/_5PqoILXnEeCqU4w2X0ufGw" name="FNLN2"> 

    <Info>    
         <Personal>       
            <FN>John</FN>       
             ...     
         </Personal>     
         ...   
    </Info> 
</ns:form>

 Why Why is this important? It's only important if you are using the form to edit existing submissions, i.e. to edit the XML documents they have generated. To do so, the form must first be initialized using the XML document. If the structure of the XML document does not match the structure of the form (or more accurately, if the XML schemas are incompatible), the initialization will fail and you cannot edit the submission using the form.

...

Tip

An upcoming version of frevvo (currently estimated for late Q1 or Q2 2012) will permit versioning of forms/flows so existing submissions can be edited using older versions of the form/flow.

 

...

.

...

Submissions Database

Submissions can be accessed directly via database SQL queries. By default frevvo's submissions are stored in the built-in HSQLDB. You can easily [[V4_Installation_Instructions#Changing_from_HSQLDB_to_another_database | configure frevvo to use a different database]] such as mySql, MS SQL Server, etc.. Doing so can make direct access to the submission database simpler.

...