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

Javascript

Community Beginner ,
Apr 19, 2021 Apr 19, 2021

Copy link to clipboard

Copied

Hi, i need with this script please:

Field names: Box1, Box2, Box3, Box4, Box5, Box6, Box7, Box20

       Box4 is total from Box20

       Box3 = Subtract Box2 from Box1

       Box5 = Subtract Box4 from Box3

       Box7 = add Box5 and Box6

Now whats script to add in Box4, Box3, Box5, Box7 and where?   Thanks!!!!

 

 

TOPICS
JavaScript

Views

334

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 ,
Apr 19, 2021 Apr 19, 2021

Copy link to clipboard

Copied

Answer in picture, you don't need any script:

 

Capture_348.png

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 ,
Apr 19, 2021 Apr 19, 2021

Copy link to clipboard

Copied

It works thanks

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 ,
Apr 19, 2021 Apr 19, 2021

Copy link to clipboard

Copied

You don't need any scripts. Use the Simplified Field Notation option in the Calculate tab and simply write out the formulas for each field, like this:

 

For Box4:

Box20

 

For Box3:

Box1 - Box2

 

For Box5:

Box3 - Box4

 

For Box7:

Box5 + Box6

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 ,
Apr 19, 2021 Apr 19, 2021

Copy link to clipboard

Copied

LATEST

Thanks!!! it works

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