Support Home
FormsFly Website
Support Home
FormsFly Website
What's New
What's NewSpring '25Year End Dash '24
About FormsFly
Unleash the PotentialCountless UsesFeature Showcase
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
External System Integrations
External System IntegrationsAdding ConnectionsAdding a Dropbox ConnectionAdding a Power BI ConnectionAdding a SharePoint ConnectionAdding a SQL Server ConnectionAdding OAuth 2.0 Connection
Data Sources
Best Practices – Data SourcesAdding a New Data SourceConfiguring Data Source SettingsEditing Data Source RowsUsing Image Columns
Data Source Connectors
Platform Sync – Data Source ConnectorREST – Data Source ConnectorSQL Server - Data Source ConnectorFTP – Data Source Connector
Form Connectors
Adding Form ConnectorsDropbox – Form ConnectorEmail - Form ConnectorREST - Form ConnectorSharePoint Document – Form ConnectorSQL Server - Form ConnectorCustom SQL
Output Data with Templates
Send Form Data to Word/PDF/ExcelWord TemplatesExcel TemplatesBuilt-In TemplatesHiding Sections / Rows in Custom TemplatesBuilt-in Data Dynamic Output using Form FormulaeSizing Images in Word/Excel OutputOutputting Repeatable DataTick Boxes and Other Special CharactersText Templates (Text, CSV, JSON, XML)
App & Platform
Adding a New UserCreating, Updating and Deleting Rows in a Data SourceEditing Form EntriesForce Sync vs. Refresh vs. Reload on ReturnForms vs ScreensForm SettingsLaunching your App from a URLManaging UsersManually Downloading DataNotification LogsOther Field Properties Viewing Form Entries as a FeedViewing Form Entries in a TableViewing Form Entries on a Map
Folders
Folders OverviewAdding a New FolderAdding Items to a FolderEditing Folder Settings & User Access Permissions
Tasks
Adding a New TaskImporting a Task from ExcelRecurring Tasks Creation BehaviourREST – Task ConnectorSetting up Task ConnectorsTask & Dispatch OverviewTask Templates
Form Tips and Tricks
Creating a FormulaCascading Choices (Parent-Child)Document ConverterDynamically Displaying Images from Data Source Web or Map sourcesNesting Repeatable Data Looking Up A Data Source Row From a Barcode ScanRepeatedly Scanning Barcodes or QR Codes
Advanced Subjects
Integration APIWorkflow A Form Entry Between Users (Process Steps)
Reference
Frequently Asked QuestionsMinimum RequirementsFormsFly Best PracticesCapturing 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 & DocsScreensTemplates
Screens
Details ScreenBoard of IconsList of Data
Field Types
Action Field TypeBarcode Field TypeGallery Field TypeNFC Field TypeOCR Field TypeProcess Field Type (2-Step Workflow)QR Code Field TypeREST Field TypeTable Field TypeSection Field Type
FAQ & Troubleshooting
Can I launch other apps on the user’s device from within a Screen?Does the app work offline (without internet connection)?Finding the App Version NumberForms, Docs aren't on my device anymore?Generating an Android Bug ReportHow do I configure emails from the platform? (From addresses SPF records and mail rules)How do I connect my account to Google Drive/Spreadsheet/Dropbox/FTP/OneDrive etc?How can I control the quality / size / megapixels of images photos in Forms?How can I pull/push data from/to other systems?How to Synchronise the FormsFly appImproved Background UploadingMy connectors/jobs don’t run immediately! Why?Photos/Videos/Audio files aren’t available on the Data page! Why?The App is CrashingWhat's the difference between Form entry Completed time and Received time?What are the limits/maximum fields that I can have in a Screen?When does the app synchronise/check for updates?When to Use Camera in Basic Mode (Android only)Which TLS versions are supported?
Security
Adding an SPF RecordCloud platform's IP addressFilter what users see on the app and platformIP WhitelistingTwo-Factor Authentication (2FA)
Functions
Functions and Formulae
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
Process Steps
STEP-CURRENTSTEP-ISCURRENTSTEP-COMPLETEDSTEP-RESULTSTEP-EMAILSTEP-FIRSTSTEP-LAST

LON

Returns the longitude in decimal degrees of the given location value.

LON(locationval)

Related 

LAT, HEADING, ALTITUDE, ACCURACY, STREETNUM, STREET, CITY, COUNTY, COUNTRY, POSTCODE

Powered by Product Fruits