How to use functions And() and Or() with multiple True/False arguments?

About this article

This article will explain what the And() or Or() functions are and provide examples of how they can be utilized with the binding syntax in smart templates.  

• What is the And() function? 
• And() function examples
• What is the Or() function? 
• Or() function examples

These functions support True/False statements as arguments and cannot utilize string values as arguments.

 

Prerequisites

Library and at least one Dynamics modules enabled Templafy Desktop and Office VSTO add-in installed on the PC Tenant admin/owner access or Space owner access

 

What is the And() function? 

And() is a function that takes many True/False statements as arguments and returns True when all the arguments are True, and returns False if at least one of the arguments is False.

 

And() logic

Syntax	{{And(True/False, True/False, True/False, ...)}}
Output	True/False

 

 

And() function examples

 

Example 1

Using the And() function together with IfElse() to set the visibility of a smart field based on the value of three checkbox questions originating from the response form.

Binding	{{IfElse(And(Form.Checkbox1, Form.Checkbox2, Form.Checkbox3), VisibilityType.Visible, VisibilityType.Hidden)}}
Input	Form.Checkbox1 = "☑" Form.Checkbox2 = "☑" Form.Checkbox3 = "☑"	Form.Checkbox1 = "☐" Form.Checkbox2 = "☑" Form.Checkbox3 = "☑"
Condition	True	False
Output	Visible text	Hidden text

 

Example 2

Using the And() function together with IfElse()and Equals() to set the visibility of a smart field based on the value of three text questions originating from the response form.

Binding	{{IfElse(And(Equals(Form.Question1, ""), Equals(Form.Question2, ""), Equals(Form.Question3, "")), VisibilityType.Hidden, VisibilityType.Visible)}}
Input	Form.Question1 = "" Form.Question2 = "" Form.Question3 = ""	Form.Question1 = "" Form.Question2 = "Hello world" Form.Question3 = ""
Condition	True	False
Output	Hidden text	Visible text

 

 

What is the Or() function? 

Or() is a function that takes many True/False statements as arguments and returns True when at least one of the arguments is True, and returns False if all the arguments are False.

 

Or() logic

Syntax	{{Or(True/False, True/False, True/False, ...)}}
Output	True/False

 

 

Or() function examples

 

Example 1

Using the Or() function together with IfElse() to set the visibility of a smart field based on the value of three checkbox questions originating from the response form.

Binding	{{IfElse(Or(Form.Checkbox1, Form.Checkbox2, Form.Checkbox3), VisibilityType.Visible, VisibilityType.Hidden)}}
Input	Form.Checkbox1 = "☑" Form.Checkbox2 = "☑" Form.Checkbox3 = "☑"	Form.Checkbox1 = "☐" Form.Checkbox2 = "☑" Form.Checkbox3 = "☑"	Form.Checkbox1 = "☐" Form.Checkbox2 = "☐" Form.Checkbox3 = "☐"
Condition	True	True	False
Output	Visible text	Visible text	Hidden text

 

Example 2

Using the Or() function together with IfElse() and Equals() to set the visibility of a smart field based on the value of three text questions originating from the response form.

Binding	{{IfElse(Or(Equals(Form.Question1, ""), Equals(Form.Question2, ""), Equals(Form.Question3, "")), VisibilityType.Hidden, VisibilityType.Visible)}}
Input	Form.Question1 = "" Form.Question2 = "" Form.Question3 = ""	Form.Question1 = "" Form.Question2 = "B" Form.Question3 = ""	Form.Question1 = "A" Form.Question2 = "B" Form.Question3 = "C"
Condition	True	True	False
Output	Hidden text	Hidden text	Visible text

 

 

Related articles

How to provide an output based on a condition using IfElse()? How to determine if the source text contains a specific search value using Contains()? How to determine if two values are equal using Equals()? What is the binding syntax used in smart templates? What are functions, conditions, and operators? What are smart fields? What are template settings and properties? How to adjust the visibility of smart fields?