Skip to main content
Dallen333
Participant
December 28, 2022
Question

Custom Script - Values Divided by 4

  • December 28, 2022
  • 1 reply
  • 1224 views

Hello!

 

I am creating a document where users select a checkbox based on their rankings/ratings within a certain topic.  I have assigned each checkbox a value. 

I am trying to take those values, and divide them by 4.  My script reads:

var v1 = Number(this.getField(“DEI-AN1”).value);

var v2 = Number(this.getField(“DEI-AN2”).value);

var v3 = Number(this.getField(“DEI-AN3”).value);

var v4 = Number(this.getField(“DEI-AN4”).value);

var v5 = Number(this.getField(“DEI-RI1”).value);

var v6 = Number(this.getField(“DEI-RI2”).value);

var v7 = Number(this.getField(“DEI-RI3”).value);

var v8 = Number(this.getField(“DEI-RI4”).value);

var v9 = Number(this.getField(“DEI-S1”).value);

var v10 = Number(this.getField(“DEI-S2”).value);

var v11 = Number(this.getField(“DEI-S3”).value);

var v12 = Number(this.getField(“DEI-S4”).value);

var v13 = Number(this.getField(“DEI-OF1”).value);

var v14 = Number(this.getField(“DEI-OF2”).value);

var v15 = Number(this.getField(“DEI-OF3”).value);

var v16 = Number(this.getField(“DEI-OF4”).value);

var v17 = Number(this.getField(“DEI-AA1”).value);

var v18 = Number(this.getField(“DEI-AA2”).value);

var v19 = Number(this.getField(“DEI-AA3”).value);

var v20 = Number(this.getField(“DEI-AA4”).value);

event.value=(v1+v2+v3+v4+v5+v6+v7+v8+v9+v10+v11v+v12+v13+v14+v15+v16+v17+v18+v19+v20/4;

 

I keep getting error messages. At first it was syntax, now it's illegal character (I've been playing with it for a few days trying to figure it out).  Any help would be greatly appreciated.

This topic has been closed for replies.

1 reply

Nesa Nurani
Community Expert
Community Expert
December 28, 2022

You are using wrong quotes, use this: " not ”.

Also, at last line you are missing bracket after 20.

Dallen333
Dallen333Author
Participant
December 28, 2022

Ooof - rookie mistake.  Thank you!

 

That resolved the error messages, but the average field isn't rendering now. 😞  

 

I've uploaded the file.

Nesa Nurani
Community Expert
Community Expert
December 28, 2022

In last line you have error you wrote v11v instead of v11, but that also won't work, you need to check that checkboxes are checked and then calculate. Also, if you are trying to get average, your calculation is wrong.