survey designer field values data stores in which table?

[Parth3110]

As per our survey designer form, user has to fill almost 28 fields and on the basis of those filled values we have to calculate the passing percentage and populate in one of the report.

Now in order to calculate the percentage we need to write the script but we don't know in which table these field values are getting stored, please suggest.

[SN_Learn]

Hi @Parth3110 ,

It will be stored in the [asmt_metric_result] table.

Mark this as Helpful / Accept the Solution if this helps

[Parth3110]

I am not fining data in this.

Can you help me where else I can find data?

[SN_Learn]

Hi @Parth3110 ,

The table [asmt_assessment_instance] contains all the Survey Instances assigned to the user who will take the survey. Here, there is a field called 'metric type' which is the 'survey definition' which you created from survey designer.

Now the results(responses) of the above assessment is stored in the table [asmt_metric_result].

Please trigger a survey then take that up, then you will be able to find the records here in this table.

Please share some screenshots if the issue still persists.

Mark this as Helpful / Accept the Solution if this helps