Form error on questions

User Support Form Building
, , ,
1

@hakan_cetinkaya I hear you
the xls form is attached below:

aBQEt5Kv5SXpz3zcHwbQMJ (13).xlsx (12.4 KB)

I need help with these issues: This form is due by end of day today :cry:

  1. I am not able to get total scores.the message appearing on excel output is ‘NaN’ sometimes its blank.Kindly note the scoring is on selective questions.

The main idea is to have total scores for each form once submitted. So the formulas for total scores are challenging especially that I have a lot of skip logic applied.

3.Once a form is submitted using online submission through a link, how can it completely exit after submission? say when I submit form through the link, it still keeps me on the form page.Possible a user may re-enter thinking it has not been submitted

Thanks in advance for your help

2

@Faith, maybe you could have a look at this post discussed previously that should help you add variables (not showing NAN):

You could also have a look at our support article Adding Skip Logic to lean how to manage skip logics within a survey project.

3

@Kal_Lam .Thanks for your response.
Could this expression be valid to calculate my total scores below:

coalesce(${calculation})+coalesce(${calculation_001})+coalesce(${calculation_002})+coalesce(${calculation_003})+coalesce(${calculation_004})+coalesce(${calculation_005})+coalesce(${calculation_029})+coalesce(${calculation_006})+coalesce(${calculation_007})+coalesce(${calculation_028})+coalesce(${calculation_008})+coalesce(${calculation_009})+coalesce(${calculation_030}

My xls is below
aBQEt5Kv5SXpz3zcHwbQMJ (20).xlsx (13.9 KB)

thanks in advance for your assistance

4

@Faith, the coalesce should be used as follows:

coalesce(${calculation},0)+coalesce(${calculation_001},0) instead of coalesce(${calculation})+coalesce(${calculation_001})

You could still check out the workaround shared previously.