How to update Start Dates of projects & tasks ?

RiteshGiri
RiteshGiri Member
in Product Releases

Hi ,

We use Projects & Tasks in DOMO to manage workitems.
Is there a way we could update start dates on project and tasks in DOMO ?

Answers

  • ColemenWilson
    ColemenWilson Coach

    For projects, there is no start date, only the created date of the project.

    For tasks, there is no start date, only created, updated and due dates.

    If I were wanting to track start dates, I would run the Domostats report "Tasks" through a Magic ETL dataflow that appends each update. I would then use the MIN updated date when the status is In Progress to create a new field called "Start Date". It won't be perfect, as it is likely changes will be made between runs of the Domostats and updates will be missed, but it would get you close.

    Alternatively, you could use the Tags field to enter the start date or add the start date in the Description and then using string parsing, pull the date out of the description.

    If I solved your problem, please select "yes" above

  • RiteshGiri
    RiteshGiri Member

    Hey Cole,

    Thanks for your suggestion—it sparked a few ideas around manually updating and maintaining start dates via an ETL for different projects.

    However, I'm facing an issue with tags. They don't seem to be included in the DomoStat Tasks database, so we're unable to use them on our dashboards.

    Do you know if there's another DomoStat database I should check for this information?

  • ColemenWilson
    ColemenWilson Coach
    edited March 19

    Ah you are right. That is odd! I like your ETL route. Lots of options there to add fields. Since you can't surface tags, the other options I recommended may have to do for now. You can also reach out to Domo to request Tags be added to the Domostat. You could also submit an Idea in the ideas exchange: https://community-forums.domo.com/main/categories/ideas

    If I solved your problem, please select "yes" above

Categories