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
Advanced Topics
Form Tips and Tricks
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
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
Data Conversion
NUMBER
STRING
DATE
FORMAT-DATE
BOOLEAN-FROM-STRING
FORMAT-NUM
Logic
IF
EQUAL TO
AND
NOT
OR
TRUE
FALSE
REGEX
COALESCE
CHECKLIST
Maths
ADD
SUBTRACT
MULTIPLY
DIV
ROUND
GREATER THAN
GREATER THAN OR EQUAL
LESS THAN
LESS THAN OR EQUAL
Repeatable Groups
SUM
COUNT
MAX
MIN
JOIN (REPEAT)
Text/String
CONCAT
JOIN (STRING)
STRING-LENGTH
SUBSTR
System Values
NOW
TODAY
SCREENDATE
The date & time on which the current screen on the device was last updated for GMT (UTC) time zone
Syntax
SCREENDATE()
Example
SCREENDATE()
returns a date/time (UTC format) e.g. '2023-10-18T15:20:26Z'
Related
SCREENVERSION