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

same cell has multiple calculations but only one seems to work

New Here ,
Oct 14, 2024 Oct 14, 2024

Copy link to clipboard

Copied

I have an issue.

kenneth_9844_0-1728943406970.png

I was able to figure out how to subtract one cell from another. that is for EndTime--StartTime=total hrs

var v1 = getField("Endtime-1").value;

var v2 = getField("StartTime-1").value;

event.value=v1-v2;

 

And i was able to get the sum of total hrs for Sub-total Hours at the bottom of total hours 

Total Hrs - 2, Total Hrs - 3, Total Hrs - 4, Total Hrs - 5, TotalHrs-1

 

But when i enter numbers into start and end it seems to get screwed up. The 'total Hours' tends to keep the first numbeer that i enter in. whether that is in the 'Start' or 'End' cell. In this case the 'start or 8' was the firs tnumber.

kenneth_9844_2-1728943756935.png

Any help would be extremely helpful.

BTW if you can dumb down ther terminolgy for me I would appreciate it. When researching this i had to goodle some of the phrase cause i didn't know what they were. I can operate and learn the sogtware but the terminolgy sometimes is a bit much for me.

Anyway TIA

 

 

TOPICS
How to , PDF forms

Views

72

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 ,
Oct 14, 2024 Oct 14, 2024

Copy link to clipboard

Copied

LATEST

Check field calculation order, by selecting 'Prepare form' tool, then click on 'More' then 'Set field calculation order',

make sure 'Sub-total Hours' field is at the bottom because fields that calculate first should be at the top.

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