Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...

Or... now make it easy with Facebook Integration
Connect via Facebook

Top Sellers

Dynamic Registration 4.0

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery 4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

XMod Pro 2.7 - Forms and Views for Databases

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

Smith Shopping Cart v3.88

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

Event Calendar and Registration 4.0

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

DNN Modules

Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
Name of the Table associated with the Form
Last Post 07-24-2013 05:35 AM by Ryan Bakerink. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
vr1001 vr1001User is Offline
river guide
river guide
Posts:115
Avatar

--
07-18-2013 11:19 AM

    Hi,

    I am trying to generate a report from the Form data (data submitted and stored in the database).

    Please point me to any resource.

    Also, how to format the Excel sheet exported in the "View Form Results" page please?

    Thanks a lot in advance!

    Vijay
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    07-19-2013 06:14 AM
    Hello Vijay,

    Dynamic Forms will store it's form submission results into DynamicForms_QuestionResponse. This table links to DynamicForms_Question based on DynamicQuestionID.

    Within the DynamicFOrms_QuestionResponse table, the UniqueResponseID column is responsible for dictating a single form submission. This means that a single submission will have 1 record per question on the form. So if there are 10 questions on your Dynamic Form, there will be 10 records in the DynamicForms_QuestionResponse table for that submission.

    Please note that the relationship between DynamicForms_Question and DynamicForms_QUestionResponse is 1 to many.

    There is no way to customize the layout for the Export to Excel of the View Form Results. This is always going to be a tabular export.

    Please let me know if you have any questions.

    Thanks,

    Ryan

    vr1001 vr1001User is Offline
    river guide
    river guide
    Posts:115
    Avatar

    --
    07-20-2013 04:20 AM
    Thank you!!

    I am seeking help from a friend who has good SQL skills. He is not familiar with DNN and Dynamic Forms; but he has excellent SQL and .NET skills. He is asking me to give the exact table name associated with my specific Form.

    I also have the Data Viewer module; but it is NOT displaying the list of Dynamic Forms module instances on my portal.

    So, he wants to directly connect with my DNN database and the Table associated with my Form.

    Please let me know where I can that?
    1. I can give SQL Database connection string from web.config (databse userid and password)
    2. Do I need to give my hosting account access also?
    3. Table associated with my Form instance?

    Sorry, I may be asking very basic questions

    Cheers,
    Vijay
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    07-24-2013 05:35 AM
    Hello Vijay,

    Yes if you go into your DNN's Web.Config under Host -> Configuration Manager, you can obtain the Connection String information to your DNN database.

    Once you provide the connection string information to your friend, he should be able to use this information to connect to your DNN Database. Within your DNN Database you'll find the DynamicForms_Question and DynamicForms_QuestionResponse tables.

    Please let me know if you have any questions.

    Thanks,

    Ryan
    You are not authorized to post a reply.

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
     
     

    Join our mailing list...

    Get current news and events the easy way
     
     
       
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi