Skip to main content
Participant
June 5, 2020
질문

Time Sheet Calculation using JavaScript

  • June 5, 2020
  • 3 답변들
  • 1740 조회

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.

 

이 주제는 답변이 닫혔습니다.

3 답변

rabbani she작성자
Participant
June 6, 2020

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.

try67
Community Expert
Community Expert
June 5, 2020

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.

Bernd Alheit
Community Expert
Community Expert
June 5, 2020

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

rabbani she작성자
Participant
June 6, 2020

Hi..

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

Thanks,

Bernd Alheit
Community Expert
Community Expert
June 6, 2020

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