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

Adobe Acrobat Forms : Add a specific number at specific interval

Engaged ,
Sep 16, 2020 Sep 16, 2020

Copy link to clipboard

Copied

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

Views

752

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

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 > 
...

Votes

Translate

Translate
Community Expert ,
Sep 16, 2020 Sep 16, 2020

Copy link to clipboard

Copied

Remove the double-quotes around all the numbers.

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

Copy link to clipboard

Copied

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

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

Copy link to clipboard

Copied

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

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

Copy link to clipboard

Copied

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
Community Expert ,
Sep 17, 2020 Sep 17, 2020

Copy link to clipboard

Copied

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

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

Copy link to clipboard

Copied

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

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

Copy link to clipboard

Copied

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};

 

 

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