IF Function in Function Builder

Follow

Thomas Narita

• September 20, 2020 02:03

How to I use the If function in the function builder? Is there documentation or videos available.

Is there an example, so I can see how to construct a formula using the If statement?

I would like to construct something like: If([YesNo] = "Yes", 10, 0). Also, how do I construct nested If statements?

0

• Official comment

  

  AgilePoint NX Support

  • September 20, 2020 16:48
  • Edited

  Thomas,

   

  Are you asking about Inline functions or Formula Builder?

  Inline Function:

  https://documentation.agilepoint.com/00/appbuilder/cloudenvShapeInlineFunctions.html?hl=function%2Cbuilder

  https://documentation.agilepoint.com/00/appbuilder/cloudappExampleConfigureInlineFunctionsActivity.html?hl=function%2Cbuilder

  eForm Formula Builder:

  https://documentation.agilepoint.com/00/appbuilder/cloudformFormulaBuilder.html

   

  Thank you

  AgilePoint NX Support

  Comment actions Permalink
• 

  Thomas Narita

  • September 20, 2020 19:56

  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
• 

  AgilePoint NX Support

  • September 21, 2020 10:01
  • Edited

  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
• 

  Gwen Wilson

  • February 02, 2021 02:30

  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
• 

  Aravind Rajanna

  • February 05, 2021 13:51

  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
• 

  Brad Harr

  • May 10, 2022 20:11

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

  0

  Comment actions Permalink
• 

  Sanjay G

  • May 13, 2022 12:07

  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.