FormsFly Website

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

Form Tips and Tricks

Other Field Properties 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

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

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 CHECKLIST 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

SUM COUNT 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

CEILING

Ceiling

CEILING(val)

Example

ceiling({{price1}})

Notes

Returns the smallest integer value that is greater than or equal to the specified number.

Related

Powered by Product Fruits