FormsFly Website

FormsFly Website

What's New

What's New Spring '25 Year End Dash '24

About FormsFly

Unleash the Potential Countless Uses Feature Showcase

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

Form Connectors

SQL Server - Form Connector Custom SQL Email - Form Connector

Data Source Connectors

SQL Server - Data Source Connector Platform Sync Connector

Outputting Data with Templates

Send Form Data to Word/PDF/Excel Word Templates Excel Templates Built-In Templates Hiding Sections / Rows in Custom Templates Built-in Data Dynamic Output using Form Formulae Sizing Images in Word/Excel Output Outputting Repeatable Data Tick Boxes and Other Special Characters Text Templates (Text, CSV, JSON, XML)

Tasks

Task Templates Adding a New Task Task & Dispatch Overview Importing a Task from Excel Recurring Tasks Creation Behaviour

Further Topics

Other Field Properties Launching your App from a URL Nesting Repeatable Data

Form Tips and Tricks

Creating a Formula Cascading Choices (Parent-Child)

App & Platform

Force Sync vs. Refresh vs. Reload on Return When does the app synchronise/check for updates?Creating and Updating Rows in a Data Source Viewing Form Entries as a Feed Adding a SQL Server Connection Forms vs Screens Editing Form Entries Form Settings Managing Users Adding a New User Manually Downloading Data Viewing Form Entries in a Table Viewing Form Entries on a Map

Advanced Subjects

Workflow A Form Entry Between Users (Process Steps)

External System Integrations

External System Integrations Integration API

Reference

Frequently Asked Questions Minimum Requirements FormsFly Best Practices Capturing Repeatable Data 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 Saving Entry Values For Reuse / Defaulting (Global Values)

Definitions

Connections Connector Data Source Files & Docs Screens Templates

Screens

Details Screen Board of Icons List of Data

Field Types

Gallery Field Type OCR Field Type Action Field Type NFC Field Type Table Field Type Barcode Field Type QR Code Field Type REST Field Type Process Field Type (2-Step Workflow)

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 Cloud platform's IP address Two-Factor Authentication (2FA)IP Whitelisting Adding an SPF Record

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

POSITION PRIOR AVERAGE (REPEAT)MEDIAN (REPEAT)FIRST (REPEAT)LAST (REPEAT)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

Data Interchange

HTTPSTATUS JSONVAL JSONLIST XMLVAL XMLLIST

Process Steps

STEP-CURRENT STEP-ISCURRENT STEP-COMPLETED STEP-RESULT STEP-EMAIL STEP-FIRST STEP-LAST

INT

Converts the given value to an integer value.

Syntax

INT(val)

Example

INT(6.345)

returns

6

Powered by Product Fruits