A different way to VIEW form submissions.

[lawalty]

I'm just LOVING the new wb2.8!!!  I can't get enough of the easy of use of this CMS.

I use the awesome "MPForm" module.

My question to everyone is, is there another easier way to view my form submissions?  I understand to go to the page where my form resides, and scroll down to see the list of my form submissions, but I would like a way to view these puppies (submissions) in a simple web-based CSV format.   

I have 3 different pages on my site that uses forms, so of course I need them separated.

I do know of the module "CSV Export", but it has tremendous limitations.  I can export my form submissions to CSV, but there is no separation of what pages they came from, and it's not web-based.

I wish there was a module, or a Droplet, that with the right parameters (form page ids), can query my SQL database and echo the data on my screen in table format like excel? 

LaWalty

[erpe]

Hi

what about this one?
http://www.websitebakers.com/pages/modules/various/csvexport.php

rgds

erpe

[mr-fan]

Hi

what about this one?
http://www.websitebakers.com/pages/modules/various/csvexport.php

rgds

erpe

he wirte he knows this module....i don't know what he wants but i think this modul is also maybe important for his needs:

http://www.websitebakers.com/pages/modules/listings/various/sortable-table.php

i don't test this mod

regards martin

[Argos]

Formlist shows form submissions in the frontend. You can manipulate the output to show in tables. But you'll need to do some modifying as this is a separate module, not some addon to the other form modules.
http://www.websitebakers.com/pages/modules/interaction/formlist.php

I had a discussion with FrankH some time ago when I requested to add CSV export to MPForm, but he choose to not do it, referring to the existence of the regular CSV export module. Like you I see the advantage of having it as part of the module, but alas...

Ideal would be a situation where you can choose the output in the settings: email, CSV, WYSIYWG, and be able to choose 1, 2, or 3 of these options. I can imagine this would be a complex coding job, but it still would be cool   

[lawalty]

It seems to me that the Sortable-Table module is the best way to go (to display my form submissions in a 'like' excel spreadsheet format).  I just don't know what to put into the seperate fields areas to query the MYSQL database for the page/section id.

I have seperate forms for seperate pages (example: contact us form, and an employment form)  So creatings seperate pages/sections (for output viewing) is necessary to display this information seperately.

So, i would create a page that would only be viewable to a selected group.  The page would be titled 'Submissions'.  I'll have different sections on the pages using the Sortable-Table mudule.  Each section (on that page) would have a different title, one would be be titled 'Contact Us Submissions', then the other would be 'Employment Submissions'.  Each of these sections using the Sortable-tabe module would represent thier repective pages that the general public would see.

i do know that the form submissions are located in "mod_mpform_submissi ons" in the MYSQL database, i just don't know how to query this information correctly for each designated field in the the Sortable-Table module.

lawalty

p.s.
i hope i had given enough information to be clear of what I was talking about.
 

[FrankH]

I use the awesome "MPForm" module.
...
I have 3 different pages on my site that uses forms, so of course I need them separated.

After creating a form with mpform, the first step should be to go to the settings and set "Name suffix for results table" to an extension of your choice. This way you can separate output of different forms into different tables. I think I wrote this somewhere in the help file and in the tutorial. The setting is under "Settings for Multi Page Forms", may be I should move it to the "Geeral settings".
The problem is when you change the suffix after you already added fields, because the column for the field will be added only when the field is created.

May be I should change the default settings from "no suffix" to "section_id" as suffix?

Regarding wishes of further enhancements:
 Just yesterday an user in the german forum complained that WB should be easy, but the help file for mpform is already so large  The more features the module will have, the more users will complain that it is too complicated...
And I still think it is best to separate frontend output of a form into a different module, by the way.

[lawalty]

Grrrrrrrrr!  Never mind about the Sortable-Table module.  I have realized that I have to manually put the information into the fields. I thought there was a way for me to add some type of PHP (echo) line of code to auto-pull the data from the MYSQL tables.  I was sooooo wrong.

FrankH, thank you so much about the info about separating output of different forms into different tables.  It was a good help, and your RIGHT.

Now, i just need to figure out a way to list the data into a table like a static 'spreadsheet'.

my best bet (for now) is the CSV Export module.  It just puts all the submission info in one filed, it doesn't seperate the information into different fields.

I'm still researching for a best solution.

[kweitzel]

A simple SQL "SELECT" query will do the trick for displaying the stuff you want. Have a look at the original anynews code as reference.

cheers

Klaus

[FrankH]

my best bet (for now) is the CSV Export module.  It just puts all the submission info in one filed, it doesn't seperate the information into different fields.

Sure you need to export the right table  
It is called mod_mpform_results_ + the suffix you specify for the form.  
May be walking through the tutorial could be helpful for you

[lawalty]

Earlier this morning I took a look at your tutorial, which is VERY informative.  I can see what you mean about what MPForm and can do.

It is weired how the information that I want to show in a table format, is all located in one field "body", the other information is also good, but is really not needed (example: ip address, when submitted).

I guess i can use the built in way of how WB2.8 or MPForm shows the subbmissions by displaying pics of folders with the submission ID.  It's not exactly how I would want it to show.  They would have to click each on just to see the information in the submission.  ..  Grrrrrr!

[lawalty]

A simple SQL "SELECT" query will do the trick for displaying the stuff you want. Have a look at the original anynews code as reference.

The way the form modules are used, the information I want to query is located in a specific field.  Example, I just can get "Name", "Address", and "Email" in different fields - because that information (whithin the form) is all loacted in just ONE field "Body".  That is why using CSV Export will only show the information with one cell.

Arrggg!

[FrankH]

Hey, why did you not read my answer #8 completely ??

[lawalty]

 

I was taking tutorial, and I came to this page (listed below) but it wouldn't let me go any further through the tutorial:

http://wbdemo.heysoft.de/pages/en/mpform/mpform323.php#wb_section_40

4 Loops with forms (part 1)
If you ever tried to do programming tasks, you probably know what a loop means in the flow of a program. If not, just imagine you have to put a question like "list the names, birth dates and some more data of your childs" into a form, with a separate field for each data element. The possible number of childs ranges from 0 up to lets say 365 (though this extreme case happened some hundred years ago here in Saxony where I live, but who knows...) At least you should get the idea now:
You need to loop through the same page of the form until the answer to the question "Have you more children?" is No.

Now how can you do this with a WebsiteBaker form?

On the page which comes before the looping page, you put an option field "Do you have any children" with the possible answers Yes and No.
As success page, you do not set the next part of the form, but a page of type code you create.
In the code page, you decide (depending on the answer of the user) whether the next page to show either will be the page of the form who asks for children or (if there are no children, yet) the page following it.
Now you have a switch, but not a loop. But it is a good starting point.

Of course, it makes sense to write the code after all parts of the form are ready.


--------------------------------------------------------------------------------

Explanation to the following Multi Page Form (part 3)
Tha last field types are introduced: Select Box (with single and multi selectl) and Upload File.
In the backend settings you can set separate permissions for upload directory and uploaded files. Most often you probably do not want anyone to download the files. This is nearly impossible because the file name gets some random part, and it is totally impossible with correct permissions set. In this tutorial everyone can download the data (including final file names) entered by all participants, but still you can't download any file. But I have the permissions to download the files by ftp

The answer in the last field decides whether the next page will be skipped (answer No) or not. If you want to learn something more, you should answer Yes.


--------------------------------------------------------------------------------

It doesn't give me any way to advance to the next page. 

Now, it has answered some of my questions on how to set up a way for my website visitors to select from a dropdown menu an item, then after clicking "Submit Form" it would go to a pre-designated website address on depending what the visitor pre-selects from the dropdown list.

But, it still doesn't answer my original question on how to show the submitted content on a spreadsheet like table.

LaWalty

[FrankH]

Hi LaWalty,

Regarding tutorial:
just like on every other page of this tutorial you need to fill out the form below the text.
Probably I will change this some day.

Regarding the submissions:
You complained multiple times about all fields beeing in the body of the submissions table.
I wrote in answer #8:

Sure you need to export the right table  grin
It is called mod_mpform_results_ + the suffix you specify for the form.  wink

To say it more clearly now: You just downloaded the wrong table