For AI agents: visit https://docs.fulcrumapp.com/llms.txt for an index of all pages formatted in Markdown and endpoints in OpenAPI. Append .md to any documentation page URL to get its markdown version.
Jump to Content
FulcrumSupportFeedbackChangelog
Developer GuidesAPI ReferenceAnnouncements
SupportFeedbackChangelogLog InFulcrum
Developer Guides
Log In
Developer GuidesAPI ReferenceAnnouncements

DOCUMENTATION

  • Developer Information
    • Webhooks
    • Sharing Data
    • URL Actions
    • Fulcrum MCP & AI Toolkit (Labs)

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
    • Feature Created Duration
    • Feature Created Location Properties
    • Feature Duration Properties
    • Feature Updated Location Properties
    • 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
    • Access Nested Repeatable Values in a Calculation Field
    • 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
    • Classification set replacement with LOADRECORDS
    • 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
    • Cross-app push notifications with LOADRECORDS
    • Detect fake GPS spoofing
    • 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 a daily sync using LOADRECORDS
    • Enforce regex pattern validation by role
    • Fetch data from a Socrata service
    • Geofencing with LOADRECORDS and GEOMETRY
    • Get elevation information
    • Google Maps & Street View Open
    • Hide fields based on user role
    • How to show hyperlink field's default URL
    • Bundle npm packages for use in Data Events and Report Builder
    • 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
    • Pass a Record ID Between Apps Using STORAGE()
    • Phone number validation
    • Point-in-polygon with CARTO API
    • Populate a choice field with org members via the Memberships API
    • Prevent changes after signing
    • Prevent editing an old record
    • Prevent users from uploading photos from the device gallery
    • Proximity check using LOADRECORDS and built-in Turf functions
    • 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
    • Suppress console.log on mobile devices
    • 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
    • Append PDF attachments to a report
    • Cover Page
    • Display field value labels
    • Dynamic reports with EJS $params
    • Filter a Report by Project Name Using a Chained Query
    • Font
    • Footer
    • Format Date
    • Format Text Fields
    • Calendar View Report with FullCalendar.js
    • Hide fields
    • Highlight fields
    • Hyperlink Field
    • Label
    • Logos
    • Merge PDF Report Templates and Attachments with pdf-lib
    • Display photo EXIF metadata in reports
    • Photos
    • Form Schema
    • Stall Puppeteer for async rendering
    • Query repeatables, photos, and Google Street View
    • Repeatable Field (Child Records)
    • Resize
    • Save a Generated PDF on Mobile and Desktop
    • Signature
    • Sketches
    • Section
    • Tables
    • Timezone
    • Record Links

App Extensions

  • Introduction
  • App Extension Examples
    • Date picker with blackout dates
    • High Energy Hazard Selector
    • Illness Symptoms Selector
    • Offline Capabilities
    • Rich Text Editor
    • Share PDF
    • Visualize field data with Chart.js

Utilities

  • Introduction
  • Utilities Examples
    • Export a Field Mapping CSV from the App Designer
    • Download a Choice List as CSV
    • Enable a Feature Flag via the Browser Console

QUERY API

  • Introduction
  • Query API Examples
    • Count Active Users by Changeset Activity
    • Extract All Form Fields Recursively with a CTE
    • List All Forms Each User Can Access
    • Pivot App Columns to Rows (EAV Format)
    • Query Photo EXIF Data

integrations

  • Introduction
  • Integration Examples
    • Import Data from an Esri Feature Service into Fulcrum
Powered by 

Record Links

To display the value of a specific linked record, follow this syntax:

record.formValues.find('data_name').items[0].displayValue

Updated 7 months ago


Timezone
Introduction
Did this page help you?
    • To display the value of a specific linked record, follow this syntax: