We would like the automatic sum (add up) of the Scrum Task Planned Hours

[Honey Shaik]

We would like the automatic sum (add up) of the Scrum Task Planned Hours. put that value into User Story Points(u_story_points). 

[Ankur Bawiskar]

@Honey Shaik 

we don't how both the tables are related.

You didn't share the script you created and what's not working

please share that so that we can help

[Honey Shaik]

for the table (rm_story), we have created a custom table (u_story_points). so we have scrum tasks for every story, so for that we do have planned hours that needs to be added automatically and the final count must reflect in the story points field.

[Ankur Bawiskar]

@Honey Shaik 

so 1 story (rm_story) can have multiple scrum tasks

story points field is field on rm_story.

what's the use of u_story_points table here and how it relates to rm_story or rm_scrum_task

[Honey Shaik]

sorry i'm mistaken, for the table (rm_story), we have created a custom field (u_story_points). so we have scrum tasks for every story, so for that we do have planned hours(planned_hours) that needs to be added automatically and the final count must reflect in the story points field(u_story_points).