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
Other Field Properties
Form Tips and Tricks
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
Outputting Repeatable Data
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
Functions and Formulae
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
ISBLANK
NOTBLANK
REPLACE
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/Tables
SUM (REPEAT)
COUNT (REPEAT)
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
Date/Time
DATEADD
DATEDIFF
DATETOLOCAL
DAYYEAR
DATETOUTC
YEAR
MONTH
DAY
HOUR
MINUTE
SECOND
DAYWEEK
WEEKYEAR
IMGDATE
Lists/Set of Values
LIST
TOLIST
TOLIST (MULTI-FIELD)
IN
NOTIN
COUNT
SUM
AVERAGE
MEDIAN
MIN
MAX
FIRST
LAST
Data Sources
DSCOUNT
DSSUM
DSAVG
DSMAX
DSMIN
DSFIRST
DSLAST
Location
LAT
LON
HEADING
ALTITUDE
ACCURACY
STREETNUM
STREET
CITY
COUNTY
COUNTRY
POSTCODE
MIBETWEEN
KMBETWEEN
INPOLYGON
ADD
Add
Syntax
+
Example
{{price1}} + {{price2}}
Related
SUBTRACT