Data/Form/Fields plugin providing macros to include form-like fields/data on a wiki page (stored in a db)

[James Mills]

I'm quite happy to develop a plugin that'll implement what I'm proposing... But I would like a few pointers, and helpfull starters.

It'd be nice to be able to create wiki pages that contain input fields and drop-down boxes that users can fill out and submit.

The process of submitting can either then be stored in a local db or submitted as a ticket with the values given.

Macros to display a list of the data stored and maybe manipulate it and/or query it.

cheers JamesMills

[Noah Kantrowitz]

The problem is that a totally general system is often too complex for practical usage. It would be nice though :)

[James Mills]

True, you're probably right. Though I tend to think that a clearly defined scsope of features could be implemented.

​PWiki2 (​Trac) a PHP Wiki Engine I wrote and still use but unmaintained, had a Data Plugin that allowed you to do similar things to the ones mentioned above. It could:

• create input fields on the page
• submit them to an internal db
• list/print the internal db on the page
• email the resulting form to somewhere.

See: ​DataPlugin

--JamesMills

[Noah Kantrowitz]

The major problems are that it is hard to do anything other that just show the data in a table, and that data security is a big issue.

[anonymous]

It'd be nice to be able to create wiki pages that contain input fields and drop-down boxes that users can fill out and submit.

I've done this by hacking the NewHackMacro to take a form stored as a wiki page and a template stored as a wiki page and output a new wiki page whose name is based on input from the form.

The process of submitting can either then be stored in a local db or submitted as a ticket with the values given.

It would probably be fairly easy to modify the above described macro to submit info as a ticket or to store it in a seperate table or seperate db altogether.

Macros to display a list of the data stored and maybe manipulate it and/or query it.

We've done this also, in the form of a couple macros:

• One allows you to manipulate a table directly
• the other allows you to submit a custom select query that is displayed in a nice html format

They should be posted on trac-hacks in the coming weeks. We just have a metric ton of other things to do.

[Ryan J Ollos]

I tried using the TracFormsPlugin which seems to have this functionality, but it doesn't seem to be working for me: Ticket #5319.