I want users to be able to post to a Database and view the results

[rgecy]

I am looking for a mod or to create a mod that would create a custom form for users to put in data.  I then want to be able to view the data in a chart or table. 

A good example of what I am looking for is the Database feature in Yahoo Groups.

Any ideas?  Is there a mod that does this or similar? 

I had found a mod that created custom forms, and was great for creating the form I needed.  But it just posted the results to individual post on the forum and not to one tabe for viewing.

Thanks in advance,

RGecy

[mashby]

http://custom.simplemachines.org/mods/index.php?mod=1279

[rgecy]

mashby,

Thats the one I mentioned in my post, Custom Form Mod.  (I must have been editing when you posted)

It does not create the table view I am looking for.  It does do a great job of being able to customise the forms though.

RGecy

[[SiNaN]]

If you are not planning to frequently change the fields in the form and you just need a single form, as in Custom Forum Mod, I may help you with creating it. Otherwise you better try Mod Requests board or ask for a moderator to move the topic for you.

[rgecy]

Blue Dream,

Thanks!  No, once its set, the fields will not change.

What do you need from me?

RGecy

[[SiNaN]]

All the information about the form, I mean its structure. Mainly, what will be the name and type of each field?

[rgecy]

It is basically a wish list for future upgrades.  It needs to show

User Who Submitted
Date Submitted
Model Number
Sugestion (feature to add)
Why (explanation why it would be a good feature to add)
Software Version Feature was Added (these last two fields would need to be edited later if the feature was added in an update)
Comments on Update

Let me know what else you may need. 

Thanks,

RGecy

[rgecy]

SiNaN,

Just wanted to check and see if you would be able to help me with this.

Thanks,

RGecy

[[SiNaN]]

Sorry for delayed response. I've attached the file. It works with SSI.php. Just upload it to your forum root where index.php and SSI.php of your forum is located.

Fields are defined at the top of file:

Code Select Expand

$context['fields'] = array(
array(
'id' => 'model_number',
'label' => 'Model Number',
'type' => 'text',
),
array(
'id' => 'suggestion',
'label' => 'Suggestion',
'type' => 'textarea',
),
array(
'id' => 'why',
'label' => 'Why?',
'type' => 'textarea',
),
array(
'id' => 'version_feature_add',
'label' => 'Version Feature was Added',
'type' => 'text',
),
array(
'id' => 'comments',
'label' => 'Comments',
'type' => 'textarea',
),
);

You can add more or change their labels, type if you want. Note that it just have two types 'text' and 'textarea' as they were enough for the fields you listed.

You can reach the form by: http://whereyour.forum.is/form.php
The list of members submitted form is located at: http://whereyour.forum.is/form.php?action=list (only admins can view the submitted forms)

Also attached a few screen shots.

[rgecy]

Thanks for the reply.  The mod certainly works, but a user can only submit one item.  It changes it if you submit again.

I need to be able to display the data more like the second image in my original post.  The Custom Form Mod works great for creating the form and fields.  I need to change the way it is displayed once its posted.  More of a Database format I guess. 

Maybe a custom board format.  The Custom Mod Form can post topics to a specific board, and if we could designate a specific format for that board?  Is that possible?

Robert

[[SiNaN]]

Allowing multiple submissions require another table and more work. I won't be able to help about it any time soon, sorry.

As for displaying them in a tabular view, the attached one should do it.

I never used Custom Form Mod, so I can't help with that either. You may want to ask the author of the mod about it.