Where is Form Wizard Pro submitted data stored?

This is an open forum for any mojoPortal topics that don't fall into the other categories.

This thread is closed to new posts. You must sign in to post in the forums.
3/8/2011 2:28:10 PM
jlaco
Gravatar
Total Posts 4
View Posts

Where is Form Wizard Pro submitted data stored?

Hi,

     Hopefully this is the right place for my question.  I'm new to MojoPortal and I am thinking about buying Form Wizard Pro.  I plan to have a scheduled task that runs a script that looks for new records that were submitted via Mojo forms.  When a new records are found, other automation steps will take place at the SQL db level.

Here is my question.  When data is submitted via a form created by Form Wizard Pro, where is it stored?  Does each form have it's own table?  If so, how is the table named?

Thanks in advance..

Jamey

3/8/2011 6:49:46 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Where is Form Wizard Pro submitted data stored?

Hi Jamey,

It doesn't create tables per form, it has a set of 5 tables currently, in alphabetical order:

  • sts_WebForm
  • sts_WebFormOption
  • sts_WebFormQuestion
  • sts_WebFormResponse
  • sts_WebFormResponseSet

so the sts_WebForm table represents the instance of Form Wizard Pro (of which you can have as many as you like)

ResponseSet represents a completed form and has a guid that ties the Response rows together which of course are related to the questions.

In the UI we make it look like the form is represented as a table for download and export, but it isn't really stored like that.

You could poll for new rows in sts_WebFormResponseSet and then use a query to extract all the data.

In the future we have planned to implement a provider model for a form completed event that would allow you to write a handler for that event in .NET code and plug it in and get access to the completed form objects.

Best,

Joe

 

3/8/2011 8:26:53 PM
jlaco
Gravatar
Total Posts 4
View Posts

Re: Where is Form Wizard Pro submitted data stored?

Hi Joe.  Thanks for the quick and thorough answer.  Looks like it will do what I need it to for now.  Time to purchase.

 

Take care,

Jamey

You must sign in to post in the forums. This thread is closed to new posts.