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

Adobe Acrobat Forms : Add a specific number at specific interval

Engaged ,
Sep 16, 2020 Sep 16, 2020

I am trying to add a particular number at regular intervals

I have difference between 2 dates  in hours   

 

so  for first 24 hours  result 1  ,

even more than a minute to 24 hours >> result 1+.5 = 1.5 ,

then again even more than a minute  to next 8 hours  >> result 1.5 + .5 = 2

then again even more than a minute to next 16 hours  >> result 2 + .5 = 2.5

then again even more than a minute to next 8 hours >> result 2.5 + .5 = 3

then again even more than a minute to next 16 hours >. result  3 + .5 = 3.5   and so on.

 

In short .5 to be added after 24 hours for at every more than 8 hours & 16 hours 

 

I am using the below script  but not able to achieve the above :

 

var miles = this.getField("minutes").value; //difference between days in minutes

var hrs = Math.floor(miles/(60*24));  //capturing the hours part
var min = miles%60 //capturing the remainder minutes

 

if(hrs == "0" && min > 0){event.value =1}
else if (hrs >0 && min >0) {event.value = hrs + ".5"}
else if (hrs > 0 && min == "0"){event.value = hrs}

 

 

TOPICS
Acrobat SDK and JavaScript
1.4K
Translate
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

correct answers 1 Correct answer

Engaged , Sep 18, 2020 Sep 18, 2020

Found the correct script after doing lot of permutation and combination.

Below is the script:

 

var miles = this.getField("Diff_Minutes").value; //Difference between 2 dates in Minutes
var nDays = Math.floor(miles/(60*24));  //Capturing the full Days
var rHours = Math.floor(miles/60) - (nDays*24); //Capturing the full hours remaining after full Days
var rMinutes = miles%60; //Capturing remaining minutes after capturing full days & hours

event.value = 0;

if(nDays <= 0 && (rMinutes > 0 || rHours > 
...
Translate
Community Expert ,
Sep 16, 2020 Sep 16, 2020

Remove the double-quotes around all the numbers.

Translate
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
Engaged ,
Sep 16, 2020 Sep 16, 2020

same thing.. not working as per requirement even after removing the ""

Translate
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 ,
Sep 16, 2020 Sep 16, 2020

Either share the file or be more specific about what "not working" means, exactly...

Translate
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
Engaged ,
Sep 17, 2020 Sep 17, 2020
Translate
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 ,
Sep 17, 2020 Sep 17, 2020

I can't see any calculation at the field "Result".

Translate
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
Engaged ,
Sep 17, 2020 Sep 17, 2020

script is already provided in my original post...you can copy it and change the field name

 

i removed the script from result as to avoid any confusion......you can write script from scratch or edit my script to meet the condition mentioned in the pdf file

Translate
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
Engaged ,
Sep 18, 2020 Sep 18, 2020
LATEST

Found the correct script after doing lot of permutation and combination.

Below is the script:

 

var miles = this.getField("Diff_Minutes").value; //Difference between 2 dates in Minutes
var nDays = Math.floor(miles/(60*24));  //Capturing the full Days
var rHours = Math.floor(miles/60) - (nDays*24); //Capturing the full hours remaining after full Days
var rMinutes = miles%60; //Capturing remaining minutes after capturing full days & hours

event.value = 0;

if(nDays <= 0 && (rMinutes > 0 || rHours > 0) ){event.value = 1};
if(nDays == "1" && rMinutes == "0" && rHours == "0"){event.value = 1}
if(nDays >=1 && rMinutes == "0" && rHours == "8"){event.value = nDays + .5}
if(nDays >= 1 && rMinutes > 0 && rHours >= 8 ){event.value = nDays + 1};

 

 

Translate
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