Skip navigation
mstout@edwardrose
mstout@edwardrose Calculating status...
Currently Being Moderated

"If" forumla help please!

Aug 7, 2012 9:51 AM

Categories: Windows

I am trying to create a conditional or "if" formula in Acrobat.  I have successfully done the same thing in Word, but the same formula will not work in “Simplified Field Notation” and I am not too familiar with JavaScript.

 

My fields are "install", "monthly", "day", "dayrate" and "prorate".  ("monthly" and "install" are the only fields that require input from the user.

 

dayrate = monthly / 30    day = 31 - install

 

I am trying to determine "prorate" based on what is input in "monthly" and "install."  The formula I used in Word to calculate the value for the field “prorate” is “IF(day=30, monthly, day*dayrate).

 

Is there a way to do this in Acrobat? I have tried mimicking several other “IF” scripts without success and I’m in a time crunch.  Thank you much!

465 Views   4 Replies   Latest reply: mstout@edwardrose, Aug 8, 2012 9:36 AM
 
Replies
  • GKaiseril
    Currently Being Moderated
    1. GKaiseril,
    Aug 8, 2012 9:04 AM   in reply to mstout@edwardrose
    Report

    The simplified field notation is not JavaScript but uses JavaScript behind the scenes to take the field names and constant numeric values to perform the four basic calculation methods of addition, subtraction, multiplication and divsion. No conditional controls statements, field properties, field methods, or functions are allowed. Field names must start with an alphabetic character and should not include any white space. White spaces are used to determine the break of field name, operations, and constants.  String operations are also not permitted.

     

    You do not specify the target of the calculation, as it is assumed the target for the result of the calculation is the field for which the calculation is being written.

     
    |
    Mark as:
  • mstout@edwardrose
    Currently Being Moderated
    2. mstout@edwardrose,
    Aug 8, 2012 9:16 AM   in reply to GKaiseril
    Report

    Yes, sorry I did not specify.  I know that Simplified Field Notation is not JavaScript.  I was trying to ask if there is a way to do it in Simplified Field Notation (which you answered) and, if not, if someone could provide me with a JavaScript code that would work.  I have found some code for conditional statements, but can't seem to get it to work in my form.

     

    The target of the calculation is to determine "prorate."

     

    "prorate" will always equal "day" x "dayrate" unless "day" = 30, in which case "prorate" would equal "monthly" which is an amount entered by the user.

     

    Let me know if I did not answer your question. Thank you!

     
    |
    Mark as:
  • GKaiseril
    Currently Being Moderated
    3. GKaiseril,
    Aug 8, 2012 9:33 AM   in reply to mstout@edwardrose
    Report

    You have a conditional situation and Simplified Field notation can not perform that type of statement, You will need to write a custom JavaScript callculation.

     
    |
    Mark as:
  • mstout@edwardrose
    Currently Being Moderated
    4. mstout@edwardrose,
    Aug 8, 2012 9:36 AM   in reply to GKaiseril
    Report

    Yes, I understand that.  I do not know how to write the custom JavaScript and was wondering if someone could help me with that or lead me in the right direction.  As I stated, I have researched conditional JavaScript codes and tried tweaking them to work in my form without succes.  Thanks again.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points