IF Function in Function Builder

Comments

7 comments

  • Avatar
    Thomas Narita

    The IF function I was referring to is in the eForm Formula Builder. I viewed the video, but it doesn't cover the IF function. Also, what are the !=, && and || operators? Are there any examples on using these functions and operators? I can't find any documentation or videos on the Agilepoint site. Googling doesn't help either. Any help would be much appreciated. My company is converting to Agilepoint and I need to convert our current QuickBase apps to Agilepoint.

    0
    Comment actions Permalink
  • Avatar
    AgilePoint NX Support

    Thomas,

     

    Those operators are based on the standards of JavaScript. They do not have a custom meaning in AgilePoint. The video gives a generic way on using the operators.

    This link on JavaScript Operators should be helpful: https://www.w3schools.com/js/js_operators.asp

     

    Thank You

    AgilePoint NX Support

    0
    Comment actions Permalink
  • Avatar
    Gwen Wilson

    Thomas wasn't answered on how to use the if function within the formula builder. I need to also use an if and am having issues getting the syntax correct. Can you assist?

    Thanks, Gwen

    0
    Comment actions Permalink
  • Avatar
    Aravind Rajanna

    Hi Thomas,

    Here is an example for formula builder which use multiple operator and combined expression.
    Note: Nested if function is not supported in Formula Builder.
    Please see the below screen capture for reference.

    Img1) Formula Builder Expression for string comparison.

    While comparing a string, custom attribute should place inside the double quote then it will treat as string.

    Img2) Formula Builder Result

    Img3)  Formula Builder Expression for number comparison.

    While comparing a number, no need of double quote for the custom attribute.

     

    Regards

    Aravind

    2
    Comment actions Permalink
  • Avatar
    Brad Harr

    Is it possible to use a "Contains" operator in the IF statement?  If so, can you provide an example?

    0
    Comment actions Permalink
  • Avatar
    Sanjay G

    Hi Brad,

     

    It looks like “Contains” operator is not supported in the IF function. However, you can write a JS function to do the validation and store the result in control and use that control in the IF function.

     

    Thanks

    1
    Comment actions Permalink

Please sign in to leave a comment.