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

Please sign in to leave a comment.