Skip to main content
Participating Frequently
December 25, 2020
Answered

Yathzee script

  • December 25, 2020
  • 1 reply
  • 1158 views

Hi All Hope you are well

I have created a fillable Yahtzee scorecard PDF. It functions well and does what i want it to except to automatically add the bonus score of 35 when the upper section scores 63 or more points.

 

Is there a script that can be used to make that calculation and added to the properties of the cell?

 

Thanks in advance.

This topic has been closed for replies.
Correct answer Nesa Nurani

How do you calculate score?

If you are using script to calculate score you can add this to the script:

if(event.value >= 63){
event.value = +event.value+35;}

1 reply

Nesa Nurani
Community Expert
Nesa NuraniCommunity ExpertCorrect answer
Community Expert
December 25, 2020

How do you calculate score?

If you are using script to calculate score you can add this to the script:

if(event.value >= 63){
event.value = +event.value+35;}
Participating Frequently
December 25, 2020

Hi 

I calculate the score simply by using the sum function in calculate and pick the cells I want to add up

Is there a better solution?

 

Nesa Nurani
Community Expert
Community Expert
December 25, 2020

Then use code in "Run custom validation script" in validate tab.