Store string field data in table and perform calculations

[shane_davis]

I am using a data lookup with the 3 fields below on my Change Task table. My goal is that to make calculations on each Change Task's score for the task's assigned to user.   Each user's score for each task needs to be stored in a table and be reportable.   I also need to change the field color for the assigned to field on the Change Request table based on what their current score is.    

The part I really need help on is taking the score from each Change Task and permanently storing it in a table to where I can make calculations off that data.

Failure type - choice such as Unauthorized

Failure cause - choice such as Planning

Failure score - string value which would populate to 10 based on two cause and type choices above.

Any help is appreciated!!

[shane_davis]

Unfortunately, the code didn't work.   Let me step through it.

1. I open a Change Task which is assigned to me.

2. I choose the Failure Type and Failure Cause choices which puts an integer in the Failure Score (u_failure_score) field.

•         All 3 fields are on the change_task table

3. The script should take the Failure Score and add it to the Failed Change Score field (u_failed_change_score) on the User table for the user assigned to the Change Task

I see now that part of step 3 is missing code.   In addition, I need to have a script on the sys_user table that deletes the value of u_failed_change_score every 91 days.

Thank you very much for your help.   I really appreciate it!