Support Home
FormsFly Website
Support Home
FormsFly Website
What's New
What's New
Autumn '23
Spring '23
About FormsFly
Unleash the Potential
Countless Uses
Feature Showcase
Subscription Types
Getting Started
Where to Start
Creating your First Form
Saving and Publishing Your Form
Using Your Form on Mobile Devices
Viewing the Completed Form Data
Receive your Form Data by Email
Next Steps
Modifying an Existing Form Design
More Data Types
Using Data Sources to Lookup Data
The Basics - Covered
Further Topics
Form Tips and Tricks
Other Field Properties
Creating a Formula
Cascading Choices (Parent-Child)
Reference
Frequently Asked Questions
Minimum Requirements
FormsFly Best Practices
Platform Sync Connector
How to Control Size or Resolution of Images in Forms
Edge Users
Web Forms (Add-On)
Testing Your Screen Designs (TEST Mode)
Quick Sync - Testing Screen Designs
Adding an SPF Record
Saving Entry Values For Reuse / Defaulting (Global Values)
Definitions
Connections
Connector
Data Source
Files & Docs
Repeat Group
Screens
Templates
Screens
Details Screen
Board of Icons
List of Data
Troubleshooting
Generating an Android Bug Report
How to Synchronise the FormsFly app
Forms, Docs aren't on my device anymore?
The App is Crashing
Finding the App Version Number
Security
Folders Overview
Filter what users see on the app and platform
Functions
Choices
SELECTED
COUNT-SELECTED
Contextual
USEREMAIL
USERFIRSTNAME
USERLASTNAME
ORGMETA
USERMETA
GLOBALVAL
DEVICENAME
DEVICEOS
DEVICEOSVERSION
ORGNAME
USERINGROUP
USEREXTERNALID
APPVERSION
SCREENVERSION
SCREENDATE
VAL
COUNTER
USERLANG
TASK
Data Conversion
NUMBER
STRING
DATE
FORMAT-DATE
BOOLEAN-FROM-STRING
FORMAT-NUM
FORMAT-GEO
INT
BOOLEAN
FILEURL
CBOX
CBOXB
Logic
IF
EQUAL TO
AND
NOT
OR
TRUE
FALSE
REGEX
COALESCE
CHECKLIST
GREATER THAN
GREATER THAN OR EQUAL
LESS THAN
LESS THAN OR EQUAL
Maths
MAX
MIN
TRUNC
FLOOR
CEILING
ABS
POW
MOD
RANDOM
ADD
SUBTRACT
MULTIPLY
DIV
ROUND
Repeatable Groups
SUM
COUNT
MAX (REPEAT)
MIN (REPEAT)
JOIN (REPEAT)
Text/String
CONCAT
JOIN (STRING)
STRING-LENGTH
SUBSTR
SUBSTITUTE
LOWER
UPPER
STARTSWITH
CONTAINS
INDEXOF
SPLIT
RANDOMSTR
GUID
"\n"
System Values
NOW
TODAY
UTCTODAY
UTCNOW
TASK-FIRSTAVAILABLE
TASK-FIRSTTOCLAIM
INT
Converts the given value to an integer value.
Syntax
INT(
val
)
Example
INT(6.345)
returns
6