• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Can anyone help me in calculations?

Community Beginner ,
May 29, 2024 May 29, 2024

Copy link to clipboard

Copied

I want to calculate this form. Can anyone please help me?

 

Sama5C32_0-1717049696406.png

 

TOPICS
PDF , PDF forms

Views

112

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 30, 2024 May 30, 2024

Copy link to clipboard

Copied

How is tax calculated, do you just enter amount manually?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
May 31, 2024 May 31, 2024

Copy link to clipboard

Copied

Yes, I'll add tax manually.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 31, 2024 May 31, 2024

Copy link to clipboard

Copied

LATEST

Try this as custom calculation script of "TOTALTOTAL" field:

var total = 0;
var tax = Number(this.getField("TOTALTAX").valueAsString);
var ship = Number(this.getField("TOTALSHIPPING").valueAsString);

for(var i=1; i<=7; i++){
var qty = Number(this.getField("QTY"+i).valueAsString);
var price = Number(this.getField("PRICE"+i).valueAsString);
var dsc = Number(this.getField("DISCOUNT"+i).valueAsString);
if (qty !== 0 && price !== 0) {
var itemTotal = qty * price * (1 - dsc);
this.getField("TOTAL" + i).value = itemTotal;
total += itemTotal;} 
else {
this.getField("TOTAL" + i).value = "";}}
event.value = (total*(1+tax))+ship;

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 30, 2024 May 30, 2024

Copy link to clipboard

Copied

We need to know the amount of the tax and the cost of the shipping…

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
May 31, 2024 May 31, 2024

Copy link to clipboard

Copied

This is an empty form. I am doing practice. There is no data for tax and shipping cost. 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines