Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.

    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support

    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

Development
  1. OpenProject
  2. Forums
  3. Development
  4. Calculated custom field.

Calculated custom field.

Added by Tanakrit Winichayakul about 6 years ago

I created 2 custom fields and would like to calculated these custom fields
from other field eg. ACTUAL DURATION is  ACTUAL FINISH - ACTUAL START.
 Is there any way to do like this?


Replies (3)

RE: Calculated custom field. - Added by Zack Glennie about 6 years ago

I don't believe such a capability exists, short of writing an external script that sets the computed values via the API. Your idea for a "calculated custom field" is interesting. I have worked with systems that have this type of thing -- Intuit QuickBase, for example -- and it can certainly be useful.

In database-driven web apps, the more common way to achieve this is not to refer to it as a "calculated field" (which would feel like part of the schema for the entity), but as part of a report that can be generated for these entities.

In OpenProject, these reports are the Work Package Table Views (with URLs like "/projects/<project_name>/work-packages"). These views are configurable, and can be saved and shared, so one way to address the feature you are describing would be to make an addition to the view configuration modal:

The new configuration could be under "Columns", or under a new tab.

Of course, this leads to questions about whether the calculated columns can be used for filtering and sorting. There's definitely some specification needed for a feature like this.

edit: I just noticed that there is another topic about this: https://community.openproject.com/topics/9575

RE: Calculated custom field. - Added by Tanakrit Winichayakul about 6 years ago

Thank you for your reply Zack Glennie. How about Regular Expression in the custom field setup. Is there anyway to use this field to setup for calculated this custom field.

RE: Calculated custom field. - Added by Zack Glennie about 6 years ago

Do you mean for validation? If so, that sounds like a separate topic.

Edit - re-reading your question, it sounds like maybe you are asking if regular expressions could be employed as a mechanism for effectively creating a Calculated Custom Field. I haven't seen anything about regular expressions anywhere in OpenProject, actually, so I think the answer would be no.

  • (1 - 3/3)
Loading...