Help

Define global status of a list of records with automation

Solved
Jump to Solution
586 3
cancel
Showing results for 
Search instead for 
Did you mean: 
zephir
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi

I want to define feature status by automation.

For example, if all the user stories of the feature are done then the feature is considered as completed.

Is it possible without a script ?

Thanks for your help.

1 Solution

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune

Hard to say without knowing what your base structure's like, but...probably?

Assuming your user stories are individual records linked to a single "Feature" record, you could do a lookup of the field that denotes the status of user story record and use a formula field with checking whether all of them are complete

Could you provide some screenshots of your tables and releavant fields?

See Solution in Thread

3 Replies 3
TheTimeSavingCo
17 - Neptune
17 - Neptune

Hard to say without knowing what your base structure's like, but...probably?

Assuming your user stories are individual records linked to a single "Feature" record, you could do a lookup of the field that denotes the status of user story record and use a formula field with checking whether all of them are complete

Could you provide some screenshots of your tables and releavant fields?

zephir
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks Adam for your answer. 

I have a base wich contains 3 tables : 

  1. feature : list of all features & and status (to complete ; completed) 
  2. US : list of all User Storiers & status (todo ; in progress , done) 
  3. link : list of links between feature & US

According to your suggestion, I imagine an automation like this 

when status US record is update in US Table

find linked feature in Link Table

find linked US to the founded feature in Link Table

Maybe, this Kind of automation can define parameters like (number of all US of a feature / number of US done)

Feature status can be automatically updated by using 2 previous parameters 

For example , if number of All US = number of US done, then feature is completed. 

Is that right ? 

 

zephir
5 - Automation Enthusiast
5 - Automation Enthusiast

It works without automation. 

Only by using lookup et formula options. 

Thanks Adam

feature.PNG