Jump to Content
FulcrumSupportFeedbackChangelog
Developer GuidesAPI ReferenceAnnouncements
SupportFeedbackChangelogLog InFulcrum
Log In
Developer GuidesAPI ReferenceAnnouncements

DOCUMENTATION

  • Developer Information
    • Webhooks
    • Data Shares
    • 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
    • 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

DATA EVENTS

  • Data Events Reference
    • ALERT
    • CLEARINTERVAL
    • CLEARTIMEOUT
    • CONFIRM
    • CURRENTLOCATION
    • INVALID
    • ISLANDSCAPE
    • ISPORTRAIT
    • MESSAGEBOX
    • OFF
    • ON
    • OPENEXTENSION
    • OPENURL
    • PREVENTDEFAULT
    • PROGRESS
    • PROMPT
    • REQUEST
    • SAVE
    • SETCHOICEFILTER
    • SETCHOICES
    • SETDESCRIPTION
    • SETFORMATTRIBUTES
    • 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
    • Boilerplate Options to Text Field
    • Capturing vector coordinates
    • 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
    • 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
    • Make a phone call
    • Make all fields within a section read-only
    • Make fields read-only based on user role
    • 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 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
    • Update CARTO table from Fulcrum
    • 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
    • Limit the amount of characters in a caption

REPORT BUILDER

  • Report Builder Introduction
    • Variables
    • Functions
    • EJS Tags
  • Report Builder Examples
    • Attachment File
    • Choice Field
    • Cover Page
    • Font
    • Footer
    • Format Date
    • Hide fields
    • Highlight fields
    • Hyperlink Field
    • Label
    • Logos
    • Photos
    • Repeatable Field (Child Records)
    • Resize
    • Signature
    • Section
    • Tables

PROJECTNAME

Suggest Edits

Returns the project name of the record

Parameters

No parameters

Returns

String

Examples

PROJECTNAME()

// returns "Project X"

Updated over 2 years ago


  • Table of Contents
    • Parameters
    • Returns
    • Examples