Jump to content
  • Creating Conditions Within Formulas

       (0 reviews)

    Darth Moxy

    You can write conditional, or 'If', statements in your formulas pretty easily in Allmoxy. Here's an example:

    attribute_name == (formula) ? (formula if true) : (formula if false)

    So, this is saying if attribute_name is equal to this (formula) use the (formula if true). If it is not equal, use (formula if false).

    You can use other comparisons like < (less than), > (greater than), <= (less than or equal to), >= (greater than or equal to) or != (not equal to).

    Also, you can chain together multiple conditions using && (and, both statements must be true) and || (or, either condition can be true). Here's an example of that:

    attribute_name == (formula) && attribute_name < (other formula) ? (formula if true) : (formula if false)


    Here's a real life example being used on just one pricing section of an arched valance:

    ((height*width)/144)  > 3.5?
    (((height*width)/144)-3.5)*wood_type.oversize_price_bf
    : 0

    This example is saying "if the square footage is more than 3.5 then give me that square footage amount multiplied by my oversized multiplier, otherwise just give me $0 for this section"

    Also, when using nested IF Statements (aka when you're running multiple conditions into one pricing section) there is a specific way you should structure the formula to get it to work. You will want to open each line with a parenthesis and then close off all of them at the end (make sure you have an equal amount of closing parenthesis as you do opening parenthesis).

    Here's an example of that:

    (drawer_box_height > 3 ? 3 :

    (drawer_box_height > 4 ? 4: 

    (drawer_box_height > 5 ? 5: 

    (drawer_box_height > 6 ? 6: 

    (drawer_box_height > 7 ? 7:

    (drawer_box_height > 8 ? 8:

    (drawer_box_height > 9 ? 9:

    (drawer_box_height > 10.25 ? 10.25))))))))


    User Feedback

    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.
    Note: Your post will require moderator approval before it will be visible.

    Guest

×
×
  • Create New...

Important Information

Terms and conditions of this site