Generate fields on the fly for task manager

[Anibal Caixinha]

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 ?

[nenegoro]

On 22 ÍÁÊ, 14:29, Anibal Caixinha <[e-mail]:

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)

[Anibal Caixinha]

nenegoro escreveu:

On 22 ÍÁÊ, 14:29, Anibal Caixinha <[e-mail]:

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.

[Edward Z. Yang]

-----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-----