Skip to main content
Inspiring
June 30, 2023
Question

Fillable form calculations stopped working

  • June 30, 2023
  • 2 replies
  • 2029 views

I am working on a fillable order sheet with active fields of amt-1, case-price-1, with ascending numbers for each succeding amt and case-price fields, and total with total being the product of the amount x price fields. I had to use a script provided by a commenter in a couple of places where the default calculaitons would not work and it works well. I managed to get 14 lines where the total worked well with the default calculation or the script. I would update the script with the approiate fields when applying it.

Now I have hit a spot past those 14 lines in which neither the default or script calculations will work in the total field.

The script is:

var v1 = Number(this.getField("amt15").valueAsString);
var v2 = Number(this.getField("caseprice15").valueAsString);
event.value = v1 * v2;

I am facing a deadline and am now apparently dead in the water since nothing I enter seems to be working. Does anyone have any ideas?

Thsnks to those who know more than me,

Joe

This topic has been closed for replies.

2 replies

Nesa Nurani
Community Expert
Community Expert
June 30, 2023

There is no reason built in calculation wouldn't work for this, can you share your file?

Also check console for any errors.

Inspiring
June 30, 2023

Yes, I will cover proprietry information and leave the neccessary info which are the amount, case price and total are visible. Thanks for your interest.

Joe

Inspiring
June 30, 2023

I have done fillable forms before, but as cnoy as omplex as this. My knowledge of scripting is pitiful; The only thing I know is to copy and paste where the experts say --- and figure out where the varibles are to adapt them to differnt input.

Thanks again forf your interest,

Jjw

Inspiring
June 30, 2023

There are four lines (records?) where the total is not working. So I skipped lines and started a new total further down the sheet that works fine with the default calculations. Not sure what that means, if anything, but one never knows.

Thanks,

Joe