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
Further Topics
Other Field PropertiesOutputting Repeatable DataLaunching your App from a URLNesting Repeatable Data
Form Tips and Tricks
Creating a FormulaCascading Choices (Parent-Child)
Tasks
Task TemplatesAdding a New TaskTask & Dispatch OverviewImporting a Task from ExcelRecurring Tasks Creation Behaviour
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 OutputTick Boxes and Other Special Characters
Advanced Subjects
Workflow A Form Entry Between Users (Process Steps)
External System Integrations
External System IntegrationsIntegration API
App & Platform Functionality
Force Sync vs. Refresh vs. Reload on ReturnWhen does the app synchronise/check for updates?Creating and Updating Rows in a Data Source Viewing Form Entries as a Feed
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 & DocsScreensTemplates
Screens
Details ScreenBoard of IconsList of Data
Field Types
Gallery Field TypeOCR Field TypeAction Field TypeNFC Field TypeTable Field TypeBarcode Field TypeQR Code Field TypeREST Field TypeProcess Field Type (2-Step Workflow)
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 addressTwo-Factor Authentication (2FA)IP WhitelistingAdding an SPF Record
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

STEP-LAST

Returns the last name of the user that decided the result (if any) of the named Process Step field

Syntax

STEP-LAST('dataname')

Related

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

Powered by Product Fruits