Generate fields on the fly for task manager

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Anibal Caixinha
    #1

    Generate fields on the fly for task manager

    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 ?

    Tags: None
    • nenegoro
      #2
      Re: Generate fields on the fly for task manager

      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)

        Comment

        • Anibal Caixinha
          #3
          Re: Generate fields on the fly for task manager


          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.

            Comment

            • Edward Z. Yang
              #4
              Re: Generate fields on the fly for task manager

              -----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.o rg 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 +fYacSNoRApfvAJ 0UO/4HxSaP6MOXxh3Ah oUcU7KzaACfeUFR
              lR66iCnJkPdz07s R9g9TLfY=
              =Uz5N
              -----END PGP SIGNATURE-----

                Comment

                Previous template Next
                Working...