Welcome Dialog

Welcome to the Community!

We have a brand new look! Take a tour with us and explore the latest updates on Adobe Support Community.


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

164

Likes

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

Copy link to clipboard

Copied

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

 

Capture_348.png

Likes

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

Likes

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
Adobe Community Professional ,
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

Likes

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

Likes

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