Support Home
FormsFly Website
Support Home
FormsFly Website
What's New
What's NewAutumn '23 Spring '23
About FormsFly
Unleash the PotentialCountless UsesFeature ShowcaseSubscription Types
Getting Started
Where to StartCreating your First FormSaving and Publishing Your FormUsing Your Form on Mobile DevicesViewing the Completed Form DataReceive your Form Data by Email
Next Steps
Modifying an Existing Form DesignMore Data TypesUsing Data Sources to Lookup DataThe Basics - Covered
Further Topics
Other Field PropertiesOutputting Repeatable DataHiding Sections / Rows in Custom Templates
Form Tips and Tricks
Creating a FormulaCascading Choices (Parent-Child)
Reference
Frequently Asked QuestionsMinimum RequirementsFormsFly Best PracticesPlatform Sync ConnectorCapturing Repeatable DataHow to Control Size or Resolution of Images in FormsEdge UsersWeb Forms (Add-On)Testing Your Screen Designs (TEST Mode)Quick Sync - Testing Screen DesignsSaving Entry Values For Reuse / Defaulting (Global Values)
Definitions
ConnectionsConnectorData SourceFiles & DocsScreensGallery Field Type
Screens
Details ScreenBoard of IconsList of Data
Troubleshooting
Generating an Android Bug ReportHow to Synchronise the FormsFly appForms, Docs aren't on my device anymore?The App is CrashingFinding the App Version Number
Security
Folders OverviewFilter what users see on the app and platformCloud platform's IP addressAdding an SPF Record
Functions
Choices
SELECTEDCOUNT-SELECTED
Contextual
USEREMAILUSERFIRSTNAMEUSERLASTNAMEORGMETAUSERMETAGLOBALVALDEVICENAMEDEVICEOSDEVICEOSVERSIONORGNAMEUSERINGROUPUSEREXTERNALIDAPPVERSIONSCREENVERSIONSCREENDATEVALCOUNTERUSERLANGTASK
Data Conversion
NUMBERSTRINGDATEFORMAT-DATEBOOLEAN-FROM-STRINGFORMAT-NUMFORMAT-GEOINTBOOLEANFILEURLCBOXCBOXB
Logic
IFEQUAL TOANDNOTORTRUEFALSEREGEXCOALESCEISBLANKNOTBLANKREPLACEGREATER THANGREATER THAN OR EQUALLESS THANLESS THAN OR EQUAL
Maths
MAXMINTRUNCFLOORCEILINGABSPOWMODRANDOMADDSUBTRACTMULTIPLYDIVROUND
Repeatable Groups/Tables
POSITIONPRIORAVERAGE (REPEAT)MEDIAN (REPEAT)FIRST (REPEAT)LAST (REPEAT)SUM (REPEAT)COUNT (REPEAT)MAX (REPEAT)MIN (REPEAT)JOIN (REPEAT)
Text/String
CONCATJOIN (STRING)STRING-LENGTHSUBSTRSUBSTITUTELOWERUPPERSTARTSWITHCONTAINSINDEXOFSPLITRANDOMSTRGUID"\n"
System Values
NOWTODAYUTCTODAYUTCNOWTASK-FIRSTAVAILABLETASK-FIRSTTOCLAIM
Date/Time
DATEADDDATEDIFFDATETOLOCALDAYYEARDATETOUTCYEARMONTHDAYHOURMINUTESECONDDAYWEEKWEEKYEARIMGDATE
Lists/Set of Values
LISTTOLISTTOLIST (MULTI-FIELD)INNOTINCOUNTSUMAVERAGEMEDIANMINMAXFIRSTLAST
Data Sources
DSCOUNTDSSUMDSAVGDSMAXDSMINDSFIRSTDSLAST
Location
LATLONHEADINGALTITUDEACCURACYSTREETNUMSTREETCITYCOUNTYCOUNTRYPOSTCODEMIBETWEENKMBETWEENINPOLYGON
Data Interchange
HTTPSTATUSJSONVALJSONLIST XMLVALXMLLIST

LESS THAN

Less than

Syntax

<

Example

    

{{price}} < 10.51

Notes

Less than 10.51

Related

GREATER THAN 
LESS THAN OR EQUAL 
GREATER THAN OR EQUAL

Powered by Product Fruits