Logo Knowledge Base
Submit a request
Sign in
  1. Knowledge Base
  2. Templafy Hive Admin Center
  3. Dynamics & the Template Designer
  4. Functions, conditions, and operators

Functions, conditions, and operators

Follow New articles New articles and comments
  • What are functions, conditions, and operators?
  • How to provide an output based on a condition using IfElse()?
  • How to get the value from a specific column and row within a data source using DataSources[]?
  • How to get the value from a specific column and row within an external data source using ExternalDataSources[]?
  • How to compare one value to multiple values and return results accordingly using Switch()?
  • How to translate terms or sentences using Translate()?
  • How to format date and time using FormatDateTime()?
  • How to display the current date using Now()?
  • How to add days, weeks, months, quarters, or years to a selected date using DateAdd()?
  • How to subtract days, weeks, months, quarters, or years from a selected date using DateSubtract()?
  • How to transform a date and time in text format into a date object using DateValue()?
  • How join multiple pieces of text with a separator using StringJoin()?
  • How to join two pieces of text together using Concat()?
  • How to convert text to upper case using Upper()?
  • How to convert text to lower case using Lower ()?
  • How to convert text to proper case using Proper()?
  • How to convert text to sentence case using SentenceCase()?
  • How to generate a random number using Ticks()?
  • How to format a number input using FormatNumber()?
  • How to reverse the value of a True/False using Not()?
  • How to use functions And() and Or() with multiple True/False arguments?
  • How to determine if two values are equal using Equals()?
  • How to determine if the source text contains a specific search value using Contains()?

 

Contact us

info@templafy.com
Templafy_linkedin Templafy_facebook Templafy_twitter Templafy_youtube

Copenhagen

Wilders Plads 15A

1403 Copenhagen K

Denmark

 

New York

One World Trade Center

48th Floor

10007 New York NY

United States

 

Berlin

Lützowstr. 100

10785 Berlin

Germany

 

Eindhoven

Fellenoord 170

5611ZB Eindhoven

Netherlands

 

London

Aylesbury House

17-18 Aylesbury Street

EC1R 0DB London

United Kingdom

 

Sydney

MLC Centre

Level 45

19 Martin Pl

Sydney NSW 2000

 

Features

Template and Content Accessibility

Dynamic Personalization

Document Automation

Brand and Content Validation

Email Signature Manager

Industries

Banking and Finance

Educational Institutions

Global Consumer Brands

Government Agencies

Insurance

Legal/Law

Professional Services

Knowledge

Blog

Help Center

Digital Asset Management

Corporate Identity Management

Enterprise Document Management

Template Office 365 Cloud Migration

Corporate Template Distribution

Corporate Rebranding

Email Signature Management

Template Management

Document Assembly for Law Firms

Company

About Us

Pricing

Customers

Career

Partners

Cookie settings

Features

Template and Content Accessibility

Dynamic Personalization

Document Automation

Brand and Content Validation

Email Signature Manager

Industries

Banking and Finance

Educational Institutions

Global Consumer Brands

Government Agencies

Insurance

Legal/Law

Professional Services

Knowledge

Blog

Help Center

Digital Asset Management

Corporate Identity Management

Enterprise Document Management

Template Office 365 Cloud Migration

Corporate Template Distribution

Corporate Rebranding

Email Signature Management

Template Management

Document Assembly for Law Firms

Company

About Us

Pricing

Customers

Career

Partners

Cookie settings

Templafy brings custom company templates, brand assets and best practice content together directly inside any office application, streamlining how users create on-brand and compliant documents, presentations and emails. With Templafy, global businesses from all industries safeguard their brand integrity and increase productivity through a centrally governed, secure and easy to use platform.

Copyright © 2021 Templafy