Can we create custom fields on the Assessment instance question and Metric Result

[Hari1]

Hi,

As a part of a requirement i wanted to check if we can create custom fields on the Assessment Instance Question (asmt_assessment_instance_question) and Metric Result (asmt_metric_result) tables. Which is the best table that suits for customization. Is it the Assessment Instance Question or Metric Result table. As both the tables has similar list of fields. I need to perform some calculations based the survey input value field on completion of the assessment instance where the state changes to Completed.

Thanks

[Yuvraj Sharma]

I created a Business Rule (condition : when assessment instance state changes to complete) on the Assessment Instance table because this table links to the metric result table as well as the source table for which the attestation is generated.

In advanced script for BR, using GlideRecord and the the right reference fields (using the metric category of assessment instance), I brought the metric results in code, did the calculation and using GlideRecord (source sys_id from the assessment instance), populated the result on the Source Table.

If you find this useful, let me know to share more detailed answer with script.