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

Time Sheet Calculation using JavaScript

Community Beginner ,
Jun 04, 2020 Jun 04, 2020

Copy link to clipboard

Copied

Dear Adobe support Team..

I have been trying to create Javascript TimeSheet calculation and I know this must have been possibly asked but I am having two issues

1. Every time I click on the cell it pops up saying : "The value enetred does not match the format of the field[Wk1_Thurs_HoursWorked]" .

2. I can not able to perfreom the subtraction of HRS Worked - Breaks (they are in decimal format).

I really appreciate this help as this is urgently needed for an hospital system.

 

TOPICS
Acrobat SDK and JavaScript

Views

364

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 Expert ,
Jun 05, 2020 Jun 05, 2020

Copy link to clipboard

Copied

 What format does you use in the field "Wk1_Thurs_HoursWorked" ?

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 ,
Jun 05, 2020 Jun 05, 2020

Copy link to clipboard

Copied

Hi..

I was using Number with 2 decimal places and 1234.56 as seperator style.

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
Community Expert ,
Jun 06, 2020 Jun 06, 2020

Copy link to clipboard

Copied

LATEST

What does you get when you change the format to "None"?

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 Expert ,
Jun 05, 2020 Jun 05, 2020

Copy link to clipboard

Copied

Remove lines 18 and 36 from your code, first of all, and then start debugging it. Check the values of ouput1 and output2. Are they what you expect them to be? If not, check why, etc.

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 ,
Jun 05, 2020 Jun 05, 2020

Copy link to clipboard

Copied

I have resolved the issue no 2 now but I stil get the issue no 1. It almost pops up like 14 times each time you clikc on a cell as its a two week calender.

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