IF Function in Function Builder
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?
-
Official comment
Thomas,
Are you asking about Inline functions or Formula Builder?
Inline Function:
eForm Formula Builder:
https://documentation.agilepoint.com/00/appbuilder/cloudformFormulaBuilder.html
Thank you
AgilePoint NX Support
Comment actions -
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.
-
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
-
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
Please sign in to leave a comment.
Comments
7 comments