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

[AnubhavRitolia]

Hi @Hari1 

As you have to do calculation based on Value provided by Survey taker for particular question, You should create field on Metric Result 'asmt_metric_result' table only where values are store.

But if you have to perform calculation for whole Survey which will involve all the Questions for that Survey, you should create field on Assessment Instance 'asmt_assessment_instance' table.

[Hari1]

Hi @AnubhavRitolia 
Thank you for sharing your response may i know what is the reason for creating custom fields on these tables? Is it more feasible? Or these tables compatible for adding custom fields? Can you please provide your feedback. Thanks in advance.

[AnubhavRitolia · Accepted solution]

Hi @Hari1 

As these are Global OOTB tables, anyways creating fields may not be recommended. but if your requirement allows, you can create with permission from your client and manager.

[Hari1]

Hi @AnubhavRitolia 
Sorry to bug you. I do have a question that can we make use of the Assessment Instance Question (asmt_assessment_instance_question) instead of the Metric Result table to create the custom fields? As the Metric Result records are created only after the Assessment is submitted. Where as the Assessment Instance Question table the records will be created and I just have to perform the calculation once on the values that is update on the field "value" from the assessment instance question table once the assessment is submitted (i.e Assessment Instance state Closed).