By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,337 Members | 2,084 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,337 IT Pros & Developers. It's quick & easy.

Generate fields on the fly for task manager

P: n/a
Hello,
I'm trying to create a task manager , for accounting firm, they have a
series of regular tasks they need to be able to control , research old
records,etc... The problem is that all of these tasks have a common
set of fields ,the problem is that some of them have some specific
fiels (most of them just text fields). Has anyone developed a similar
system and/or can give some hints on how I can alow the user to
generate these fields on the fly ?

May 22 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 22 ΝΑΚ, 14:29, Anibal Caixinha <anibalcaixi...@gmail.comwrote:
Hello,
I'm trying to create a task manager , for accounting firm, they have a
series of regular tasks they need to be able to control , research old
records,etc... The problem is that all of these tasks have a common
set of fields ,the problem is that some of them have some specific
fiels (most of them just text fields). Has anyone developed a similar
system and/or can give some hints on how I can alow the user to
generate these fields on the fly ?
I suppose you should use JavaScript. If the problem is in DB I usually
use such structure table FILEDS(id, field_name, filed_value)

May 22 '07 #2

P: n/a

nenegoro escreveu:
On 22 ΝΑΚ, 14:29, Anibal Caixinha <anibalcaixi...@gmail.comwrote:
Hello,
I'm trying to create a task manager , for accounting firm, they have a
series of regular tasks they need to be able to control , research old
records,etc... The problem is that all of these tasks have a common
set of fields ,the problem is that some of them have some specific
fiels (most of them just text fields). Has anyone developed a similar
system and/or can give some hints on how I can alow the user to
generate these fields on the fly ?

I suppose you should use JavaScript. If the problem is in DB I usually
use such structure table FILEDS(id, field_name, filed_value)
I'm considering that possibilitie, however I'm still not sure if I can
create a structure witch will be able to aplly to all of my tasks, as
I will surely have to be able to create several types of fields and
mybe even have some validations.

May 22 '07 #3

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Anibal Caixinha wrote:
I'm trying to create a task manager , for accounting firm, they have a
series of regular tasks they need to be able to control , research old
records,etc... The problem is that all of these tasks have a common
set of fields ,the problem is that some of them have some specific
fiels (most of them just text fields). Has anyone developed a similar
system and/or can give some hints on how I can alow the user to
generate these fields on the fly ?
While it is possible for one to change the database schema dynamically,
it's not recommended. Do end-users actually create the fields, or is it
just certain tasks (developer defined) that have special fields? If it
is the former case, use nenegoro's solution. If it is the latter case,
look into the Single Table/Class Table and Concrete Table Inheritance
design patterns.

- --
Edward Z. Yang GnuPG: 0x869C48DA
HTML Purifier <htmlpurifier.org Anti-XSS HTML Filter
[[ 3FA8 E9A9 7385 B691 A6FC B3CB A933 BE7D 869C 48DA ]]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGU0H9qTO+fYacSNoRApfvAJ0UO/4HxSaP6MOXxh3AhoUcU7KzaACfeUFR
lR66iCnJkPdz07sR9g9TLfY=
=Uz5N
-----END PGP SIGNATURE-----
May 22 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.