Skip to content

Latest commit

 

History

History
100 lines (89 loc) · 1.34 KB

README.md

File metadata and controls

100 lines (89 loc) · 1.34 KB

FM

A library of FileMaker functions for use with Xojo.

All functions are accessed by using the FM prefix, so to get the length of some text:

FM.Length("Hello, world.")

Aggregate Functions

  • Average
  • Max
  • Min
  • Sum

Container Functions

  • Base64Decode
  • Base64Encode

Date Functions

  • Date
  • Day
  • DayName
  • DayOfWeek
  • DayOfYear
  • Month
  • MonthName
  • WeekOfYear
  • Year

Get Functions

  • Get.ApplicationVersion
  • Get.CurrentDate
  • Get.CurrentTime
  • Get.CurrentTimestamp
  • Get.DesktopPath
  • Get.Device
  • Get.DocumentsPath
  • Get.DocumentsPathListing
  • Get.PreferencesPath
  • Get.ScreenHeight
  • Get.ScreenScaleFactor
  • Get.ScreenWidth
  • Get.SystemDrive
  • Get.SystemPlatform
  • Get.SystemVersion
  • Get.TemporaryPath
  • Get.WindowContentHeight
  • Get.WindowContentWidth
  • Get.WindowHeight
  • Get.WindowLeft
  • Get.WindowTop
  • Get.WindowWidth

Logical Functions

  • Evaluate

Number Functions

  • Ceiling
  • Int
  • Ln
  • Random
  • Truncate

Text Functions

  • Char
  • Code
  • Exact
  • GetAsDate
  • GetAsNumber
  • GetAsText
  • GetAsURLEncoded
  • Left
  • LeftValues
  • LeftWords
  • Length
  • Lower
  • Middle
  • MiddleValues
  • MiddleWords
  • PatternCount
  • Position
  • Proper
  • Quote
  • Replace
  • Right
  • RightValues
  • RightWords
  • Substitute
  • Trim
  • TrimAll
  • Upper
  • ValueCount
  • WordCount

Text Formatting Functions

  • TextColor

Trigonometric Functions

  • Degrees
  • Pi
  • Radians