Jump to Content
Documentation
API Reference
Extension API
Custom Shapes
Formulas
Community
Documentation
Community
Moon (Dark Mode)
Sun (Light Mode)
Documentation
API Reference
Extension API
Custom Shapes
Formulas
Search
Guides
Introduction
Unlocking developer tools
Application collaborator roles
Admin controls
OAuth 2.0 client creation
API Keys
Publishing
Custom shape libraries
Link unfurling
Data import and sync
Using web frameworks
External embeds
Lucid Cards Overview
Lucid Card Integrations
Data Visualization
Enterprise Shield API
Extension API
Lucid Extension API
Getting started
Core concepts
Extension packages
Editor extensions
Document content
Pages
Items
Blocks
Images
Lines
Groups
Managing text
Menus
Modals
Users
File upload
Links
iFrames
Drag and drop blocks from a panel
Using OAuth APIs
Data
Lucid cards
i18n
Package settings
Quick actions
Shape libraries
Data connectors
Building a data connector
Data actions
Data connector security
lucid-package CLI
Release notes
lucid-package
lucid-extension-sdk
Custom Shapes
Custom Shapes
Getting started
HJSON
Getting started with the Extension API
Custom shape library
Geometry
Geometry schema
Rectangle
Ellipse
Polygon
Path
Boolean operation
Render style
Sub-shapes
Bounds
Formulas
Interpolated strings
Shape data properties
Definitions
Textareas
Clipping
Shape constraints
Extension click handler
Example Shapes
Rounded Progress Bar
Signal Strength
Star Rating
Multiplexer Shape
Center-Growing Progress Bar
Greeting Shape
Shape with controls
Definitions
Formulas
Formulas
Syntax
Types
Attributes
Operators
References
Functions
Advanced Syntax
Shape References
ANCESTORS
CHILDREN
CONNECTED
CONNECTEDDEEP
CONTAINED
CONTAINEDBY
DESCENDANTS
DOWNSTREAM
DOWNSTREAMDEEP
PAGE
PARENT
SIBLINGS
THIS
UPSTREAM
UPSTREAMDEEP
Data References
FIELDLOOKUP
FINDSHAPEBYLABEL
INDEX
LABEL
LOOKUP / COLLECTION
Shape Properties
ATTRIBUTES
ISVISIBLE
ITEMTYPE
SHAPEACTIONS
SHAPETYPE
SHAPELIBRARY
Document Properties
CREATEDTIME
CREATORNAME
DOCUMENTNAME
DOCUMENTPAGES
DOCUMENTSTATUS
LASTMODIFIEDBY
LASTMODIFIEDTIME
Page Properties
PAGENAME
PAGENUMBER
Logical Statements
AND
COALESCE
IF
IFERROR
IFS
ISEMPTY
ISNOTEMPTY
NOT
OR
RAND
RANDBETWEEN
SRAND
SRANDBETWEEN
SWITCH
XOR
Analytical
COUNT
COUNTDEEP
COUNTIF
COUNTIFDEEP
FILTER
FILTERDEEP
MAX
MEAN
MEDIAN
MIN
SORT
SUM
Type Checks
ISARRAY
ISBOOLEAN
ISCOLOR
ISDATE
ISERROR
ISNOTERROR
ISNUMBER
ISTEXT / ISSTRING
ISOBJECT
String/Number Checks
BETWEEN
CONTAINS
DOESNOTCONTAIN
ENDSWITH
ISEVEN
ISODD
NOTBETWEEN
STARTSWITH
String Manipulation
&
ASSTRING
CHAR / UNICHAR
CODE / UNICODE
CONCATENATE
FIND
FROMJSON
LEFT
LEN
LOWER
REGEX_MATCHALL
REGEX_REPLACE
REGEX_TEST
REPLACE
REPT
RIGHT
SEARCH
SPLIT
SUBSTITUTE
SUBSTRING / MID
TRIM
TRUNCATE
UPPER
Number Manipulation
ABS
ASNUMBER
ASPERCENT
CEIL
CLAMP
EXP
FLOOR
FORMAT_NUMBER
LERP / INTERPOLATE
LN
LOG / LOG10
MOD / MODULUS
NUMBER_PARSE
POW / POWER
PRODUCT
ROUND
ROUNDDOWN
ROUNDUP
SIGN
SQRT / SQUAREROOT
TRUNC
Arrays
ASARRAY
ARRAY
DIFFERENCE
FLATARRAY / FLATTEN
IN
INTERSECT
JOIN
MAP
RANGE
REDUCE
REVERSE
SCAN
SHUFFLE
SKIP
SKIPWHILE
TAKE
TAKEWHILE
UNION
UNIQUE
ZIP
ZIPALL
Dates
CURRENTSECOND
DATE
DATEADD
DATEDIFF
DAY
DAYOFWEEK
DAYSAGO
EXCELDATE
FORMAT_DATE
HOUR
HOURSAGO
ISODATE
MINUTE
MINUTESAGO
MONTH
MONTHSAGO
NETWORKDAYS
NOW
QUARTER
SECOND
SECONDSAGO
UNIXDATE
UTCDATE
WEEK
WEEKSAGO
WEEKYEAR
WORKDAY
YEAR
YEARSAGO
Currency
CURRENCY
CURRENCYADD
CURRENCYDIFF
CURRENCYMULT
Objects
GET
GROUPBY
HAS
KEYS
OBJECT
VALUES
Smart Containers
CONTAINER
CONTENTS
Trigonometric
ACOS
ACOSH
ACOT
ACOTH
ASIN
ASINH
ATAN
ATAN2
ATANH
COS / COSINE
COSH
COT
DEGREES
RADIANS
SIN / SINE
SINH
TAN / TANGENT
TANH
Color Creation
HEXCOLOR
HSL / HSLA
HSV / HSVA
RGB / RGBA
Color Values
ALPHA
BACKGROUNDCOLOR / FILLCOLOR
BLUE
GREEN
HSVHUE
HSVSATURATION
HSVVALUE
HUE
LIGHTNESS
LUMINANCE
RED
SATURATION
Color Operations
CONTRAST
DARKEN
DESATURATE
FADE
FADEIN
FADEOUT
GRAYSCALE / GREYSCALE
LIGHTEN
MIX
SATURATE
SHADE
SPIN
TINT
Color Blending
BLENDMULTIPLY
BLENDSCREEN
BLENDOVERLAY
BLENDSOFTLIGHT
BLENDHARDLIGHT
BLENDDIFFERENCE
BLENDEXCLUSION
BLENDAVERAGE
BLENDNEGATION
Standard Import
Overview
Reference
Pages
Shapes
Standard Library
Shape Library
Container Library
Flowchart Library
Lucidspark Library
BPMN 2.0 Library
BPMN Shapes Reference
Table Library
Data Backed Shapes
Lines
Groups
Layers
Images
Data
Troubleshooting
Partner Resources
Co-Marketing
Suggest
Returns true if the provided expression does not result in an error.