For AI agents: visit https://docs.fulcrumapp.com/llms.txt for an index of all pages formatted in Markdown and endpoints in OpenAPI.
Jump to Content
Support
Feedback
Changelog
Developer Guides
API Reference
Announcements
Support
Feedback
Changelog
Log In
Developer Guides
Log In
Developer Guides
API Reference
Announcements
Introduction
DOCUMENTATION
Developer Information
Webhooks
Sharing Data
URL Actions
CALCULATIONS
Calculations Reference
ABS
ACOS
ACOSH
ALTITUDE
AND
ARRAY
AVERAGE
CEILING
CHAR
CHOICEVALUE
CHOICEVALUES
CLEAN
COALESCE
CODE
COMPACT
CONCAT
CONCATENATE
CONTAINS
COS
COSH
COUNT
COUNTA
COUNTBLANK
DATANAMES
DATE
DATEADD
DATEVALUE
DAY
DEGREES
DESCRIPTION
DEVICEINFO
DEVICEMANUFACTURER
DEVICEMODEL
DOLLAR
EMAIL
EVEN
EXACT
EXISTS
EXP
FACT
FACTDOUBLE
FALSE
FIELD
FIELDNAMES
FIELDS
FIELDTYPE
FIND
FIRST
FIXED
FLATTEN
FLOOR
FORM
FORMAT
FORMATADDRESS
FORMATNUMBER
GCD
GEOMETRY
GEOMETRYALONG
GEOMETRYAREA
GEOMETRYBEARING
GEOMETRYBUFFER
GEOMETRYCENTROID
GEOMETRYCONVEX
GEOMETRYDISTANCE
GEOMETRYFEATURE
GEOMETRYFEATURECOLLECTION
GEOMETRYINTERSECTS
GEOMETRYLENGTH
GEOMETRYLINESTRING
GEOMETRYNEARESTPOINT
GEOMETRYNEARESTPOINTONLINE
GEOMETRYPOINT
GEOMETRYPOLYGON
GEOMETRYTAG
GEOMETRYWITHIN
GETRESULT
GROUP
HASOTHER
IF
INSPECT
INT
ISBLANK
ISEVEN
ISLOGICAL
ISMOBILE
ISNAN
ISNEW
ISNONTEXT
ISNUMBER
ISODD
ISROLE
ISSELECTED
ISTEXT
ISUPDATE
LABEL
LAST
LATITUDE
LCM
LEFT
LEN
LN
LOG
LOG10
LONGITUDE
LOWER
LPAD
MAX
MAXA
MEDIAN
MID
MIN
MINA
MOD
MONTH
NOT
NUM
NUMS
ODD
ONCE
OR
OTHER
PI
PLATFORM
PLUCK
POWER
PRECISION
PRODUCT
PROJECTID
PROJECTNAME
PROPER
QUOTIENT
RADIANS
RAND
RANDBETWEEN
RECORDID
REPEATABLEID
REPEATABLENUMBER
REPEATABLESUM
REPEATABLEVALUES
REPLACE
RIGHT
ROLE
ROUND
ROUNDDOWN
ROUNDUP
RPAD
SEARCH
SETRESULT
SHOWERRORS
SHUFFLE
SIGN
SIN
SINH
SORT
SQRT
SQRTPI
STATUS
STATUSLABEL
STRING
SUBSTITUTE
SUM
SUMSQ
TIMEADD
TIMEDIFF
TIMESTAMP
TIMEZONE
TRIM
TRUE
TYPEOF
UNIQUE
UPPER
USERFULLNAME
VALUE
VERSIONINFO
YEAR
Calculation Examples
Altitude
Calculate Radius for Plot Sampling
Calculate Standard Deviation
Combine Arrays Together
Combine Field Values
Compare Values
Convert decimal feet to x' y"
Count Blank Fields in a Section
Count Multiple Choice Field Selections
Count Number of Child Records
Days/Years Between Two Date Fields
Degrees Decimal Minutes
Distance between repeatable points
Generate a Full Timestamp
Generate the Week Number
Get Address from Address Field (in Australia)
Get Day of the Week From a Date
Get Last Item in a Classification Set
Grab Photo ID
Hours Between Pair of Date and Time Fields
Hours Between Two Time Fields
Obtain Values from Fields Within a Section
Pull Selected Choice Option Label
Reference Record Created At Time
Reference Record Updated At Time
Return Sum of Specific Type
Return the Most Frequent Repeatable Value
Return the Repeatable Latest Date
Scoring System using a Choice List
Split Classifications into Separate Fields
Split Value Captured in a Field
Star Ratings from a Numeric Range
Sum Nullable Fields
Sum of numbers in a repeatable
Track Who Has Updated a Record
Transfer Photos through payloads
Unix Timestamp for Unique Record Value
Values from Choice Field in Repeatable
Vector Geometries from Repeatables
Years & Months Between Two Date Fields
Week Number
DATA EVENTS
Data Events Reference
ALERT
CLEARINTERVAL
CLEARTIMEOUT
CONFIRM
CURRENTLOCATION
INFERENCE
INVALID
ISLANDSCAPE
ISPORTRAIT
LOADFILE
LOADFORM
LOADRECORDS
MESSAGEBOX
OFF
ON
OPENEXTENSION
OPENURL
PREVENTDEFAULT
PROGRESS
PROMPT
RECOGNIZETEXT
REQUEST
SAVE
SETASSIGNMENT
SETCHOICEFILTER
SETCHOICES
SETDESCRIPTION
SETFORMATTRIBUTES
SETGEOMETRY
SETHIDDEN
SETINTERVAL
SETLABEL
SETLOCATION
SETMAXLENGTH
SETMINLENGTH
SETPROJECT
SETPROJECTHIDDEN
SETPROJECTREADONLY
SETREADONLY
SETREQUIRED
SETSTATUS
SETSTATUSFILTER
SETSTATUSHIDDEN
SETSTATUSREADONLY
SETTIMEOUT
SETVALUE
STORAGE
Data Event Examples
Add a tally counter
Add current weather
Alert user if photo is not geotagged
Alert user to take horizontal media
Array of fields with certain settings
Auto-populate Last Value
Auto-increment values
Automatically Select Record Link Based on Location within Polygon
Boilerplate Options to Text Field
Capture Timestamp
Change a record's status
Check fields in sections for values and either add a checkmark or a X to the section label
Check if a photo's altitude is within 5m of CURRENTLOCATION altitude
Compare photo location to record location
Compare photo timestamp with current time
Conditionally persist values across records
Create a summary field of comments entered when record is edited multiple times
Create Buffer from Point
Disable auto-sync for a specific app
Disable requirements by user or role
Display the current GPS info on the form
Dynamically translate form elements
Enforce regex pattern validation by role
Fetch data from a Socrata service
Get elevation information
Google Maps & Street View Open
Hide fields based on user role
How to show hyperlink field's default URL
Integrating Fulcrum with what3words
Intelligently updating record locations
Limit the amount of characters in a caption
Make a phone call
Make all fields within a section read-only
Make fields read-only based on user role
Measure Area and Length of Polygon
Measure Length of Line
Phone number validation
Point-in-polygon with CARTO API
Prevent changes after signing
Prevent editing an old record
Prevent users from uploading photos from the device gallery
Query a GeoServer instance
Query Esri REST services
Repeatable record sorting
Repeatable requirement validation alerts
Require captions for a photo field
Require field based on date comparison
Require project
Send a text message
Send push notifications with Pushbullet
Set the status field options based on role
Show description inline with label
Snap Point to Line
Timer
Update CARTO table from Fulcrum
Validate if Point is within Polygon
Validate record is within geographic area
Validate yes/no in repeatable and set status
Verify special choice option
Working with inline GeoJSON
Set fields to hidden based on user role
Create Repeatables
REPORT BUILDER
Report Builder Introduction
Variables
Functions
EJS Tags
Report Builder Examples
Attachment File
Choice Field
Cover Page
Font
Footer
Format Date
Format Text Fields
Hide fields
Highlight fields
Hyperlink Field
Label
Logos
Photos
Form Schema
Repeatable Field (Child Records)
Resize
Signature
Sketches
Section
Tables
Timezone
Record Links
App Extensions
Introduction
App Extension Examples
Rich Text Editor
High Energy Hazard Selector
Illness Symptoms Selector
Utilities
Introduction
Powered by
Introduction
Updated 8 days ago
Record Links
App Extension Examples
Copy Page
