# Forms - Data Normalize or not ?

**URL:** <https://forum.servoy.com/t/forms-data-normalize-or-not/9173>\
**Category:** Classic Servoy\
**Created:** [June 10, 2008, 12:34pm UTC](https://forum.servoy.com/t/forms-data-normalize-or-not/9173 "2008-06-10T12:34:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gordon](https://avatars.discourse-cdn.com/v4/letter/g/3da27b/32.png) [@Gordon](https://forum.servoy.com/u/Gordon)\
**Post date:** [June 10, 2008, 12:34pm UTC](https://forum.servoy.com/t/forms-data-normalize-or-not/9173/1 "2008-06-10T12:34:24Z")

</div>

Hi

I have a solution that will require 150+ forms with multiple pages and requires the storage of between 10 and 130 fields of data per form. The data types will be all varieties blobs, varchar, text, int, numeric etc etc

What I have done in the past with Lasso and ColdFusion is use two table normalized approach ie

Form Table  
Form\_Content Table

Where content is stored with a reference to the form and a sort order.

I am in a quandary how best to approach this with Servoy:

a) Do I carry on with a series of globals and then post them to the database using the normalized approach

OR

b) create multiple tables one for each form in my database

Key considerations:

1. I have normalized data to insert at some point in the future
2. This is sold as an saas solution and hence has several clients some of whom have many 000’s of form records
3. I want to be able to export data to excel easily and having one table per form lends it self it this approach
4. This is not a massive hit site so speed is not really an issue 2-3000 form submissions a day would be quite high.

Any opinions welcome - thanks in advance

Gordon

---

<div class="post-metadata">

**Author:** ![Westy](https://avatars.discourse-cdn.com/v4/letter/w/9de053/32.png) [@Westy](https://forum.servoy.com/u/Westy)\
**Post date:** [June 10, 2008, 1:38pm UTC](https://forum.servoy.com/t/forms-data-normalize-or-not/9173/2 "2008-06-10T13:38:48Z")

</div>

Gorden,

Take a look at the data structure used by the sample pdf form solution. It is elegant in its simplicity. It does require that you store your data as text field name/field value pairs (which is also good for xml). We use it for 650+ forms, some of which have over 500 fields per form, to store many millions of records, with no problems.

Based on your requirements, this will probably not take care of all your needs, however it is worth considering.

Dean Westover  
Choices Software, Inc.

---

<div class="post-metadata">

**Author:** ![Gordon](https://avatars.discourse-cdn.com/v4/letter/g/3da27b/32.png) [@Gordon](https://forum.servoy.com/u/Gordon)\
**Post date:** [June 10, 2008, 4:29pm UTC](https://forum.servoy.com/t/forms-data-normalize-or-not/9173/3 "2008-06-10T16:29:58Z")

</div>

> Westy:  
> Gorden,
> 
> Take a look at the data structure used by the sample pdf form solution. It is elegant in its simplicity. It does require that you store your data as text field name/field value pairs (which is also good for xml). We use it for 650+ forms, some of which have over 500 fields per form, to store many millions of records, with no problems.
> 
> Based on your requirements, this will probably not take care of all your needs, however it is worth considering.
> 
> Dean Westover  
> Choices Software, Inc.

many thanks will check this out

---

<div class="post-metadata">

**Author:** ![Robert\_Huber](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@Robert\_Huber](https://forum.servoy.com/u/Robert_Huber)\
**Post date:** [July 8, 2008, 2:29pm UTC](https://forum.servoy.com/t/forms-data-normalize-or-not/9173/4 "2008-07-08T14:29:34Z")

</div>

Hello

May be I don’t understand you correctly, but we are designing the database at least in 3rd normal form and design the application independant of how the database is designed. Was never a problem, even with large amount of data.  
Or did I completely misunderstand you (I am not sure as I don’t understand Westys answer as well)

May be this helps, Robert

> Gordon:  
> Hi
> 
> I have a solution that will require 150+ forms with multiple pages and requires the storage of between 10 and 130 fields of data per form. The data types will be all varieties blobs, varchar, text, int, numeric etc etc
> 
> What I have done in the past with Lasso and ColdFusion is use two table normalized approach ie
> 
> Form Table  
> Form\_Content Table
> 
> Where content is stored with a reference to the form and a sort order.
> 
> I am in a quandary how best to approach this with Servoy:
> 
> a) Do I carry on with a series of globals and then post them to the database using the normalized approach
> 
> OR
> 
> b) create multiple tables one for each form in my database
> 
> Key considerations:
> 
> 1. I have normalized data to insert at some point in the future
> 2. This is sold as an saas solution and hence has several clients some of whom have many 000’s of form records
> 3. I want to be able to export data to excel easily and having one table per form lends it self it this approach
> 4. This is not a massive hit site so speed is not really an issue 2-3000 form submissions a day would be quite high.
> 
> Any opinions welcome - thanks in advance
> 
> Gordon
