# Lucid Developer Documentation Documentation > Lucid provides powerful APIs that enable developers to add visual collaboration to their product or workflow. This file lists one part of the documentation. The full index is at https://lucid.readme.io/llms.txt. ## Documentation: Guides - [Introduction](https://lucid.readme.io/docs/welcome.md): Introduction to Lucid's Developer Platform - [Unlocking developer tools](https://lucid.readme.io/docs/guides-unlocking-developer-tools.md): Unlocking developer tools - [Application collaborator roles](https://lucid.readme.io/docs/application-collaborator-roles.md): This page goes over Application Collaborator roles - what they are and how to use them - [Admin controls](https://lucid.readme.io/docs/admin-controls.md): Admin controls - [OAuth 2.0 client creation](https://lucid.readme.io/docs/oauth-20-client-creation.md): This page discusses how to create an OAuth client to be used with Lucid's REST APIs - [API Keys](https://lucid.readme.io/docs/api-keys.md): This page describes what API keys are used for and how to create them. - [Publishing](https://lucid.readme.io/docs/publishing.md): This page goes over the process of publishing an extension to Lucid's Marketplace - [Custom shape libraries](https://lucid.readme.io/docs/custom-shape-libraries.md): An overview of Lucid's custom shape libraries - [Link unfurling](https://lucid.readme.io/docs/link-unfurling.md): Unfurl link - [Data import and sync](https://lucid.readme.io/docs/data-import-and-sync.md): A summary on importing data and keeping it up to date - [Using web frameworks](https://lucid.readme.io/docs/guides-using-web-frameworks.md): Using web frameworks - [External embeds](https://lucid.readme.io/docs/external-embeds.md): Learn to embed a Lucid diagram on another website - [Embed API FAQs](https://lucid.readme.io/docs/embed-api-faqs.md): Frequently asked questions about Lucid's Embed API - [Tutorial: Cookie-based embeds](https://lucid.readme.io/docs/tutorial-cookie-embeds.md): Learn how to build a basic Lucid embed integration - [Tutorial: Token-based embeds](https://lucid.readme.io/docs/tutorial-token-embeds.md): Learn how to build an advanced Lucid embed integration - [Lucid Cards Overview](https://lucid.readme.io/docs/lucid-cards-overview.md): An overview - [Lucid Card Integrations](https://lucid.readme.io/docs/lucid-card-integrations.md): A complete walk through on how to make a Lucid card integration via Todoist - [Data Visualization](https://lucid.readme.io/docs/data-visualization.md): How to build customized data visualizations using Lucid's advanced diagramming features - [Enterprise Shield API](https://lucid.readme.io/docs/enterprise-shield-api.md): Enterprise Shield encompasses powerful APIs tailored to enhance security and compliance within your organization. - [AI Tools](https://lucid.readme.io/docs/ai-tools.md): Use AI tools with Lucid docs by connecting MCP, indexing with llms.txt, and choosing the right Lucid extension skills - [MCP](https://lucid.readme.io/docs/mcp.md) - [Skill: Create Extensions](https://lucid.readme.io/docs/skill-create-extensions.md): Use this skill when you want your AI tool to scaffold and run a new Lucid editor extension. - [Skill: Edit Extensions](https://lucid.readme.io/docs/skill-edit-extensions.md): Use this skill when you want your AI tool to modify an existing Lucid editor extension or answer questions about the `lucid-extension-sdk`. ## Documentation: Extension API - [Lucid Extension API](https://lucid.readme.io/docs/lucid-extension-api.md) - [Getting started](https://lucid.readme.io/docs/extension-api-getting-started.md) - [Core concepts](https://lucid.readme.io/docs/coreconcepts.md) - [Extension packages](https://lucid.readme.io/docs/extension-packages.md) - [Editor extensions](https://lucid.readme.io/docs/editor-extensions.md) - [Document content](https://lucid.readme.io/docs/editor-extension-document-content.md) - [Pages](https://lucid.readme.io/docs/editor-extension-pages.md) - [Items](https://lucid.readme.io/docs/editor-extension-items.md) - [Blocks](https://lucid.readme.io/docs/editor-extension-blocks.md) - [Images](https://lucid.readme.io/docs/editor-extension-images.md) - [Lines](https://lucid.readme.io/docs/editor-extension-lines.md): A _line_ is a connector with two endpoints. Each endpoint may or may not be connected to a block, or to another line. - [Groups](https://lucid.readme.io/docs/editor-extension-groups.md): A _group_ is a set of other items, which acts in many ways like a single block. - [Managing text](https://lucid.readme.io/docs/editor-extension-managing-text.md) - [Menus](https://lucid.readme.io/docs/editor-extension-menus.md) - [Modals](https://lucid.readme.io/docs/editor-extension-modals.md) - [Users](https://lucid.readme.io/docs/editor-extension-users.md) - [File upload](https://lucid.readme.io/docs/editor-extension-file-upload.md) - [Links](https://lucid.readme.io/docs/editor-extension-links.md) - [iFrames](https://lucid.readme.io/docs/editor-extension-iframes.md) - [Drag and drop blocks from a panel](https://lucid.readme.io/docs/drag-and-drop-blocks-from-a-panel.md) - [Using OAuth APIs](https://lucid.readme.io/docs/editor-extension-using-oauth-apis.md) - [Data](https://lucid.readme.io/docs/editor-extension-data.md) - [Lucid cards](https://lucid.readme.io/docs/editor-extension-lucid-cards.md) - [i18n](https://lucid.readme.io/docs/editor-extension-i18n.md) - [Package settings](https://lucid.readme.io/docs/editor-extension-package-settings.md) - [Quick actions](https://lucid.readme.io/docs/quick-actions.md) - [Block Class Names](https://lucid.readme.io/docs/block-class-names.md) - [Shape libraries](https://lucid.readme.io/docs/shape-libraries.md) - [Data connectors](https://lucid.readme.io/docs/data-connectors.md) - [Building a data connector](https://lucid.readme.io/docs/building-a-data-connector.md) - [Data actions](https://lucid.readme.io/docs/data-actions.md) - [Data connector security](https://lucid.readme.io/docs/data-connector-security.md) - [lucid-package CLI](https://lucid.readme.io/docs/lucid-package-cli.md) - Release notes - [lucid-package](https://lucid.readme.io/docs/lucid-package.md): [npm package](https://npmjs.com/package/lucid-package) - [lucid-extension-sdk](https://lucid.readme.io/docs/lucid-extension-sdk.md): [npm package](https://npmjs.com/package/lucid-extension-sdk) ## Documentation: Custom Shapes - [Custom Shapes](https://lucid.readme.io/docs/custom-shapes-introduction.md): Introduction to Lucid's custom shapes - [Getting started](https://lucid.readme.io/docs/custom-shapes-getting-started.md) - [HJSON](https://lucid.readme.io/docs/hjson.md) - [Getting started with the Extension API](https://lucid.readme.io/docs/getting-started-with-the-extension-api.md) - [Custom shape library](https://lucid.readme.io/docs/custom-shape-library.md) - [Geometry](https://lucid.readme.io/docs/geometry.md) - [Geometry schema](https://lucid.readme.io/docs/geometry-schema.md) - [Rectangle](https://lucid.readme.io/docs/custom-shapes-rectangle.md) - [Ellipse](https://lucid.readme.io/docs/custom-shapes-ellipse.md) - [Polygon](https://lucid.readme.io/docs/custom-shapes-polygon.md) - [Path](https://lucid.readme.io/docs/custom-shapes-path.md) - [Boolean operation](https://lucid.readme.io/docs/custom-shapes-boolean-operation.md) - [Render style](https://lucid.readme.io/docs/render-style.md) - [Sub-shapes](https://lucid.readme.io/docs/sub-shapes.md) - [Bounds](https://lucid.readme.io/docs/bounds.md) - [Formulas](https://lucid.readme.io/docs/formulas.md) - [Interpolated strings](https://lucid.readme.io/docs/interpolated-strings.md) - [Shape data properties](https://lucid.readme.io/docs/shape-data-properties.md) - [Definitions](https://lucid.readme.io/docs/custom-shapes-definitions.md) - [Textareas](https://lucid.readme.io/docs/textareas.md) - [Clipping](https://lucid.readme.io/docs/clipping.md) - [Shape constraints](https://lucid.readme.io/docs/shape-constraints.md) - [Extension click handler](https://lucid.readme.io/docs/extension-click-handler.md) - Example Shapes - [Rounded Progress Bar](https://lucid.readme.io/docs/rounded-progress-bar.md) - [Signal Strength](https://lucid.readme.io/docs/signal-strength.md) - [Star Rating](https://lucid.readme.io/docs/star-rating.md) - [Multiplexer Shape](https://lucid.readme.io/docs/multiplexer-shape.md) - [Center-Growing Progress Bar](https://lucid.readme.io/docs/center-growing-progress-bar.md) - [Greeting Shape](https://lucid.readme.io/docs/greeting-shape.md) - [Shape with controls](https://lucid.readme.io/docs/shape-with-controls.md) - [Definitions](https://lucid.readme.io/docs/custom-shapes-appendices-definitions.md) ## Documentation: Formulas - [Formulas](https://lucid.readme.io/docs/formulas-getting-started.md): Getting started with Lucid's Formulas - Syntax - [Types](https://lucid.readme.io/docs/types-formulas.md) - [Attributes](https://lucid.readme.io/docs/attributes-syntax.md) - [Operators](https://lucid.readme.io/docs/operators.md) - [References](https://lucid.readme.io/docs/references.md) - [Functions](https://lucid.readme.io/docs/functions.md) - [Advanced Syntax](https://lucid.readme.io/docs/advanced-syntax.md) - Shape References - [ANCESTORS](https://lucid.readme.io/docs/ancestors.md): Returns a deep list of the shape's parents, starting with the shape's parent (then the parent's parent, etc.), up to the containing page. - [CHILDREN](https://lucid.readme.io/docs/children.md) - [CONNECTED](https://lucid.readme.io/docs/connected.md) - [CONNECTEDDEEP](https://lucid.readme.io/docs/connecteddeep.md) - [CONTAINED](https://lucid.readme.io/docs/contained.md) - [CONTAINEDBY](https://lucid.readme.io/docs/containedby.md) - [DESCENDANTS](https://lucid.readme.io/docs/descendants.md) - [DOWNSTREAM](https://lucid.readme.io/docs/downstream.md) - [DOWNSTREAMDEEP](https://lucid.readme.io/docs/downstreamdeep.md) - [PAGE](https://lucid.readme.io/docs/page.md) - [PARENT](https://lucid.readme.io/docs/parent.md) - [SIBLINGS](https://lucid.readme.io/docs/siblings.md) - [THIS](https://lucid.readme.io/docs/this.md) - [UPSTREAM](https://lucid.readme.io/docs/upstream.md) - [UPSTREAMDEEP](https://lucid.readme.io/docs/upstreamdeep.md) - Data References - [FIELDLOOKUP](https://lucid.readme.io/docs/fieldlookup.md): Uses a reference key and the collection name to find a data property. - [FINDSHAPEBYLABEL](https://lucid.readme.io/docs/findshapebylabel.md): Finds a shape using its unique shape identifier. Shape can exist anywhere in the document. To get a shape's identifier use [LABEL](doc:label). - [INDEX](https://lucid.readme.io/docs/index-page.md): Returns the value at a given position from an array, starting from 1. - [LABEL](https://lucid.readme.io/docs/label.md): Gets the unique shape identifier for the current shape. - [LOOKUP / COLLECTION](https://lucid.readme.io/docs/lookup.md): Finds data from a collection using a reference key and returns an array of all the data associated with that reference key. - Shape Properties - [ATTRIBUTES](https://lucid.readme.io/docs/attributes.md): Returns an array of all valid [formula attributes](doc:attributes) on the object. If no argument is provided, defaults to `ATTRIBUTES(THIS)`. - [ISVISIBLE](https://lucid.readme.io/docs/isvisible.md): Returns true if the shape is visible. The visibilty of shapes is controlled by the visibility of its containing layer. - [ITEMTYPE](https://lucid.readme.io/docs/itemtype.md): Gets the type of the current item or the specified item(s). Item type is one of: Line, Block, Group, Page. - [SHAPEACTIONS](https://lucid.readme.io/docs/shapeactions.md): Gets all actions added to the current shape or specified shape(s). Shape actions are objects with an action type value and additional values specific to the type of action. - [SHAPETYPE](https://lucid.readme.io/docs/shapetype.md): Gets the specific type of shape for the current shape or the specified shape(s). - [SHAPELIBRARY](https://lucid.readme.io/docs/shapelibrary.md): Gets the specific shape library for the current shape or the specified shape(s). - Document Properties - [CREATEDTIME](https://lucid.readme.io/docs/createdtime.md): Gets the creation date and time of the document. - [CREATORNAME](https://lucid.readme.io/docs/creatorname.md): Gets the name of the creator of the document. - [DOCUMENTNAME](https://lucid.readme.io/docs/documentname.md): Gets the current name of the document. - [DOCUMENTPAGES](https://lucid.readme.io/docs/documentpages.md): Gets the current pages of the document. - [DOCUMENTSTATUS](https://lucid.readme.io/docs/documentstatus.md): Gets the current approval status of the document. - [LASTMODIFIEDBY](https://lucid.readme.io/docs/lastmodifiedby.md): Gets the name of the user who last modified the document. - [LASTMODIFIEDTIME](https://lucid.readme.io/docs/lastmodifiedtime.md): Gets the last modified date and time of the document. - Page Properties - [PAGENAME](https://lucid.readme.io/docs/pagename.md): Gets the name of the current page. - [PAGENUMBER](https://lucid.readme.io/docs/pagenumber.md): Gets the page number of the current page. - Logical Statements - [AND](https://lucid.readme.io/docs/and.md): Returns true if all of the given expressions/values are true, and false otherwise - [COALESCE](https://lucid.readme.io/docs/coalesce.md): Returns the first non-empty value, or NONE if all values are empty. A value is non-empty if `ISNOTEMPTY()` returns true. If there are no values passed in, it returns `NONE`. - [IF](https://lucid.readme.io/docs/if.md): Checks the value of an expression and returns a specified value if the expression is true, and returns a different value if not. - [IFERROR](https://lucid.readme.io/docs/iferror.md): Checks if the expression has an error and, returns a replacement value, if so, or the original value otherwise. - [IFS](https://lucid.readme.io/docs/ifs.md): Returns the first matching condition from a list of conditions and corresponding results. - [ISEMPTY](https://lucid.readme.io/docs/isempty.md) - [ISNOTEMPTY](https://lucid.readme.io/docs/isnotempty.md) - [NOT](https://lucid.readme.io/docs/not.md): Returns true if the given expression/values is false, and false if the given expression is true. - [OR](https://lucid.readme.io/docs/or.md): Returns true if any of the given expressions/values are true, and false otherwise - [RAND](https://lucid.readme.io/docs/rand.md): Returns a random value between 0 and 1 (inclusive of 0, exclusive of 1). - [RANDBETWEEN](https://lucid.readme.io/docs/randbetween.md): Returns a random integer between min and max (inclusive). - [SRAND](https://lucid.readme.io/docs/srand.md): Returns a seeded random value between 0 (inclusive) and 1 (exclusive). - [SRANDBETWEEN](https://lucid.readme.io/docs/srandbetween.md): Returns a seeded random integer between min and max (inclusive). - [SWITCH](https://lucid.readme.io/docs/switch.md): Returns the first matching value from a list of values and corresponding results with a specified value. - [XOR](https://lucid.readme.io/docs/xor.md): Returns true if an odd number of the given expressions/values are true, and false otherwise - Analytical - [COUNT](https://lucid.readme.io/docs/count.md): Counts the number of elements in the specified array. - [COUNTDEEP](https://lucid.readme.io/docs/countdeep.md): Recursively counts the numbers of elements in the specified array. - [COUNTIF](https://lucid.readme.io/docs/countif.md): Counts the number of elements in an array that meet the specified condition - [COUNTIFDEEP](https://lucid.readme.io/docs/countifdeep.md): Recursively counts the number of elements in the specified array which satisfy the given condition. - [FILTER](https://lucid.readme.io/docs/filter.md): Returns a filtered list of items from a specified array that match a specified condition. - [FILTERDEEP](https://lucid.readme.io/docs/filterdeep.md): Returns a recursively filtered list of items from a specified array that match a specified condition. - [MAX](https://lucid.readme.io/docs/max.md): Calculates the maximum value of specified numbers. - [MEAN](https://lucid.readme.io/docs/mean.md): Calculates the mean (average) of specified numbers. - [MEDIAN](https://lucid.readme.io/docs/median.md): Calculates the median of a list of numbers or lists of numbers. - [MIN](https://lucid.readme.io/docs/min.md): Calculates the minimum value of specified numbers. - [SORT](https://lucid.readme.io/docs/sort.md): Sorts the specified list using an optional sort order and expression to control the ordering. - [SUM](https://lucid.readme.io/docs/sum.md): Calculates the arithmetic sum (total) of all specified numbers. - Type Checks - [ISARRAY](https://lucid.readme.io/docs/isarray.md): Returns true if the specified value is an array. - [ISBOOLEAN](https://lucid.readme.io/docs/isboolean.md): Returns true if the value is a boolean value (true or false). - [ISCOLOR](https://lucid.readme.io/docs/iscolor.md): Returns true if the specified value is a color value. - [ISDATE](https://lucid.readme.io/docs/isdate.md): Returns true if the specified value is a date value. - [ISERROR](https://lucid.readme.io/docs/iserror.md): Returns true if the provided expression results in an error. - [ISNOTERROR](https://lucid.readme.io/docs/isnoterror.md): Returns true if the provided expression does not result in an error. - [ISNUMBER](https://lucid.readme.io/docs/isnumber.md): Returns true if the specified value is a number value. - [ISTEXT / ISSTRING](https://lucid.readme.io/docs/istext.md): Returns true if the specified value is a text value. - [ISOBJECT](https://lucid.readme.io/docs/isobject.md): Returns true if the specified value is an object value. - String/Number Checks - [BETWEEN](https://lucid.readme.io/docs/between.md): Checks if a value is between two other values, inclusive. Returns true if the value is between the specified values, and false if it is not between those values. - [CONTAINS](https://lucid.readme.io/docs/contains.md): Returns true if a property or string contains a value, and returns false otherwise. - [DOESNOTCONTAIN](https://lucid.readme.io/docs/doesnotcontain.md): Returns true if a property or string does not contain a value, and returns false otherwise. - [ENDSWITH](https://lucid.readme.io/docs/endswith.md): Returns true if a property or string ends with a value, and returns false otherwise. - [ISEVEN](https://lucid.readme.io/docs/iseven.md): Returns true if the specified number is even and false if the number is odd. - [ISODD](https://lucid.readme.io/docs/isodd.md): Returns true if the specified number is odd and false if the number is even. - [NOTBETWEEN](https://lucid.readme.io/docs/notbetween.md): Checks if a value is not between two other values, inclusive. Returns true if the value is not between the specified values, and false if it is between those values. - [STARTSWITH](https://lucid.readme.io/docs/startswith.md): Returns true if a property or string starts with a value, and returns false otherwise. - String Manipulation - [&](https://lucid.readme.io/docs/-amp-.md): Text concatenation. Combines two strings together into a single string. For example "Lucid" & "chart" produces the string "Lucidchart". - [ASSTRING](https://lucid.readme.io/docs/asstring.md): For simple arguments, this function converts the argument into a string representation. For references to Lucid shapes, extracts the string contents of the shape and returns it. - [CHAR / UNICHAR](https://lucid.readme.io/docs/char.md): Get a string from the given character code or codes. - [CODE / UNICODE](https://lucid.readme.io/docs/code.md): Convert a unicode string into their corresponding code point or points. - [CONCATENATE](https://lucid.readme.io/docs/concatenate.md): Creates a new string by combining all specified strings into a single string - [FIND](https://lucid.readme.io/docs/find.md): Returns the position in the specified string of a substring, starting at the specified start position. - [FROMJSON](https://lucid.readme.io/docs/fromjson.md): Parses the supplied JSON string and converts it into formula values, if valid. - [LEFT](https://lucid.readme.io/docs/left.md): Returns the specified number of characters from the start of the string. - [LEN](https://lucid.readme.io/docs/len.md): Returns the length of the string. - [LOWER](https://lucid.readme.io/docs/lower.md): Returns the specified string converted to lower-case. ##### - [REGEX_MATCHALL](https://lucid.readme.io/docs/regex_matchall.md): Returns all matches in the specified string found by the supplied regex. - [REGEX_REPLACE](https://lucid.readme.io/docs/regex_replace.md): Returns a new string created by replacing all matches in the specified string using the regex and a replacement string. - [REGEX_TEST](https://lucid.readme.io/docs/regex_test.md): Returns true if the specified string is matched by the supplied regex. - [REPLACE](https://lucid.readme.io/docs/replace.md): Splices a string into the specified string, replacing the characters in the original string from a range of characters. - [REPT](https://lucid.readme.io/docs/rept.md): Repeats a string a number of times. - [RIGHT](https://lucid.readme.io/docs/right.md): Returns the specified number of characters from the end of the string. - [SEARCH](https://lucid.readme.io/docs/search.md): Returns the position of the specified search string, starting at an optional start position. Start index can be negative. Allows the wildcard characters ? (to match any single character) and \* (to… - [SPLIT](https://lucid.readme.io/docs/split.md): Splits the specified string into an array at the specified separator. - [SUBSTITUTE](https://lucid.readme.io/docs/substitute.md): Replaces a string with another string in a specified string. If an instance number is specified, only substitutes the instance-th match. - [SUBSTRING / MID](https://lucid.readme.io/docs/mid.md): Returns the specified number of characters from a string, starting at the specified start position. - [TRIM](https://lucid.readme.io/docs/trim.md): Returns a string where all whitespace characters (spaces, tabs, newlines, etc.) have been removed from both the start and end of the specified string. - [TRUNCATE](https://lucid.readme.io/docs/truncate.md): Returns the string truncated to the specified number of characters, with an ellipsis added at the end if truncation occurred. - [UPPER](https://lucid.readme.io/docs/upper.md): Returns the specified string converted to upper-case. - Number Manipulation - [ABS](https://lucid.readme.io/docs/abs.md): Calculates the absolute value of the specified number. - [ASNUMBER](https://lucid.readme.io/docs/asnumber.md): Converts a value into a number. - [ASPERCENT](https://lucid.readme.io/docs/aspercent.md): Formats a number as a percentage. The percentage is calculated as 100 times the number; for example, 0.25 will be formatted as 25%. - [CEIL](https://lucid.readme.io/docs/ceil.md): Rounds up (to a lesser absolute value) to the nearest multiple of the specified factor. Defaults to a factor of 1. - [CLAMP](https://lucid.readme.io/docs/clamp.md): Limits a value to a specified minimum and maximum value range. If the specified value is below the minimum value or above the maximum value, the minimum value or maximum value, respectively, is… - [EXP](https://lucid.readme.io/docs/exp.md): Calculates the value of Euler's constant (e) raised to the specified value. Equivalent to evalue. - [FLOOR](https://lucid.readme.io/docs/floor.md): Rounds down (to a lesser absolute value) to the nearest multiple of the specified factor. Defaults to a factor of 1. - [FORMAT_NUMBER](https://lucid.readme.io/docs/format_number.md): Returns a string representing the number, formatted according to the given pattern. - [LERP / INTERPOLATE](https://lucid.readme.io/docs/lerp.md): Calculates the linearly interpolated value between two numbers, with a specified proportion. - [LN](https://lucid.readme.io/docs/ln.md): Calculates the natural log of the specified number - [LOG / LOG10](https://lucid.readme.io/docs/log.md): Calculates the base 10 logarithm of the specified number - [MOD / MODULUS](https://lucid.readme.io/docs/mod.md): Calculates the modulus of a specified number with a specified divisor. The resulting value is the remainder after division of the value by the divisor. - [NUMBER_PARSE](https://lucid.readme.io/docs/number_parse.md): Liberally parses the first number in an input string. - [POW / POWER](https://lucid.readme.io/docs/pow.md): Calculates the value of the specified number raised to a given exponent - [PRODUCT](https://lucid.readme.io/docs/product.md): Calculates the product of a list of numbers or arrays of numbers. - [ROUND](https://lucid.readme.io/docs/round.md): Rounds a number to specified number of digits. - [ROUNDDOWN](https://lucid.readme.io/docs/rounddown.md): Rounds a number down (to a lesser value) to the specified number of digits. - [ROUNDUP](https://lucid.readme.io/docs/roundup.md): Rounds a number up (to a greater value) to the specified number of digits. - [SIGN](https://lucid.readme.io/docs/sign.md): Calculates the sign of the specified number as -1, 0, or 1, depending on whether the specified number is negative, zero, or positive, respectively - [SQRT / SQUAREROOT](https://lucid.readme.io/docs/sqrt.md): Returns the square root of a number. - [TRUNC](https://lucid.readme.io/docs/trunc.md): Calculates the value of the specified number with its fractional component removed. The TRUNC function does not perform any rounding. - [Arrays](https://lucid.readme.io/docs/arrays.md): Elements of arrays can be accessed directly using bracket notation. The value to use as an index starts at the number 1. - [ASARRAY](https://lucid.readme.io/docs/asarray.md): If the argument is not an array, returns an array containing the argument. Otherwise, returns the argument array. - [ARRAY](https://lucid.readme.io/docs/array.md): Creates an array of all supplied values - [DIFFERENCE](https://lucid.readme.io/docs/difference.md): Takes two arrays, treated as sets (i.e. ignoring duplicate values), and returns a new array that contains all items from the first array that are not in the second array. - [FLATARRAY / FLATTEN](https://lucid.readme.io/docs/flatarray.md): Creates an array of all supplied values, flattening any arrays so that the array is a single array of values. - [IN](https://lucid.readme.io/docs/in.md): Returns a boolean indicating if a specified item (needle) is inside of a given set (haystack). Note that the haystack must be an array. - [INTERSECT](https://lucid.readme.io/docs/intersect.md): Takes two arrays, treated as sets (i.e. ignoring duplicate values), and returns a new array that contains only items that are contained in both. If the input arrays have no items in common, returns… - [JOIN](https://lucid.readme.io/docs/join.md): Creates a string from array elements connected by a specified separator. - [MAP](https://lucid.readme.io/docs/map.md): Transforms each value of the specified array into a new value using a formula. - [RANGE](https://lucid.readme.io/docs/range.md): Creates an array of numbers with values ranging from the start number to the end number, by repetitively adding the step value to calculate values. - [REDUCE](https://lucid.readme.io/docs/reduce.md): Returns a value resulting from applying a formula to each element of the array and the previous result. - [REVERSE](https://lucid.readme.io/docs/reverse.md): Reverses the order of an array. - [SCAN](https://lucid.readme.io/docs/scan.md): Returns an array constructed from each of the results of applying a formula to each element of the array and the previous result. - [SHUFFLE](https://lucid.readme.io/docs/shuffle.md): Randomly shuffles the values in the given array. - [SKIP](https://lucid.readme.io/docs/skip.md): Returns an array consisting of remaining items from an array after skipping the specified number of items at the beginning. - [SKIPWHILE](https://lucid.readme.io/docs/skipwhile.md): Returns an array consisting of remaining items from an array after skipping all items at the beginning which satisfy the specified condition. - [TAKE](https://lucid.readme.io/docs/take.md): Returns an array consisting of the specified number of items from the beginning of an array. - [TAKEWHILE](https://lucid.readme.io/docs/takewhile.md): Returns an array consisting of all items from the beginning of an array which satisfy the specified condition. - [UNION](https://lucid.readme.io/docs/union.md): Takes two arrays, treated as sets (i.e. ignoring duplicate values), and returns a new array that contains all distinct items from both inputs. - [UNIQUE](https://lucid.readme.io/docs/unique.md): Takes either a single array or a list of values and returns an array which contains each distinct value only once. In other words it turns either an array or a list of values into a set. - [ZIP](https://lucid.readme.io/docs/zip.md): Combines the items in several input arrays by putting the first item from each array into the first output array, the second item from each array into the second output array, and so on.… - [ZIPALL](https://lucid.readme.io/docs/zipall.md): Combines the items in several input arrays by putting the first item from each array into the first output array, the second item from each array into the second output array, and so on, using the… - Dates - [CURRENTSECOND](https://lucid.readme.io/docs/currentsecond.md): The current time's seconds field. - [DATE](https://lucid.readme.io/docs/date.md): Creates a date from the specified values. - [DATEADD](https://lucid.readme.io/docs/dateadd.md): Creates a new date by adding an offset to a specified date. - [DATEDIFF](https://lucid.readme.io/docs/datediff.md): Calculates the difference between two specified dates in the given interval. If date2 is before date1, then the result will be negative. - [DAY](https://lucid.readme.io/docs/day.md): Gets the day component of the specified date. - [DAYOFWEEK](https://lucid.readme.io/docs/dayofweek.md): Calculates the day of the week (1-7) for a specified date where the week starts on Monday. - [DAYSAGO](https://lucid.readme.io/docs/daysago.md): Gets the number of days between the specified date and now. - [EXCELDATE](https://lucid.readme.io/docs/exceldate.md): This function is intended to create a date from a numeric Excel date value, assuming the value is stored as the number of days since Dec 30, 1899 (where 1 is 12/31/1899). Sometimes our system has… - [FORMAT_DATE](https://lucid.readme.io/docs/format_date.md): Returns a string representing the date, formatted according to the given pattern. Pattern formatting is generally the same as supported by Excel. - [HOUR](https://lucid.readme.io/docs/hour.md): Gets the hour component of the specified date. - [HOURSAGO](https://lucid.readme.io/docs/hoursago.md): Gets the number of hours between the specified date and now. - [ISODATE](https://lucid.readme.io/docs/isodate.md): Creates a date from an ISO8601-formatted string. See [ISO8601](https://en.wikipedia.org/wiki/ISO_8601) formatting for more details. - [MINUTE](https://lucid.readme.io/docs/minute.md): Gets the minute component of the specified date. - [MINUTESAGO](https://lucid.readme.io/docs/minutesago.md): Gets the number of minutes between the specified date and now. - [MONTH](https://lucid.readme.io/docs/month.md): Gets the month component of the specified date. - [MONTHSAGO](https://lucid.readme.io/docs/monthsago.md): Gets the number of months between the specified date and now. - [NETWORKDAYS](https://lucid.readme.io/docs/networkdays.md): Gets the number of working days between a specified beginning and ending date, inclusive. Working days exclude weekends and any dates optionally provided as holidays. - [NOW](https://lucid.readme.io/docs/now.md): Returns the current date and time. Automatically updates every second. - [QUARTER](https://lucid.readme.io/docs/quarter.md): Gets the calendar quarter for the specified date. For more details see [Quarters](https://en.wikipedia.org/wiki/Calendar_year#Quarters). - [SECOND](https://lucid.readme.io/docs/second.md): Gets the second component of the specified date. - [SECONDSAGO](https://lucid.readme.io/docs/secondsago.md): Gets the number of seconds between the specified date and now. - [UNIXDATE](https://lucid.readme.io/docs/unixdate.md): Creates a date from the number of seconds since the Unix epoch (January 1, 1970, 00:00:00 UTC). - [UTCDATE](https://lucid.readme.io/docs/utcdate.md): Creates a date from the specified values. - [WEEK](https://lucid.readme.io/docs/week.md): Gets the week component of the specified date. For more information see [ISO Week Date](https://en.wikipedia.org/wiki/ISO_week_date). - [WEEKSAGO](https://lucid.readme.io/docs/weeksago.md): Gets the number of weeks between the specified date and now. - [WEEKYEAR](https://lucid.readme.io/docs/weekyear.md): Gets the year for the associated ISO week of the specified date. For more information see [ISO Week Date](https://en.wikipedia.org/wiki/ISO_week_date) Week Date. - [WORKDAY](https://lucid.readme.io/docs/workday.md): Given a start date, finds the date a specified number of working days later. A list of holidays can optionally be provided, indicating the given dates are not working days. - [YEAR](https://lucid.readme.io/docs/year.md): Gets the year component of the specified date. - [YEARSAGO](https://lucid.readme.io/docs/yearsago.md): Gets the number of years between the specified date and now. - Currency - [CURRENCY](https://lucid.readme.io/docs/currency.md): Creates a currency from the specified amount and type, defaulting to USD if the type isn't specified. - [CURRENCYADD](https://lucid.readme.io/docs/currencyadd.md): Creates a new currency by adding two currencies of the same type together. - [CURRENCYDIFF](https://lucid.readme.io/docs/currencydiff.md): Calculates the difference between two specified currencies of the same type. - [CURRENCYMULT](https://lucid.readme.io/docs/currencymult.md): Creates a new currency by multiplying a currency by a number. - Objects - [GET](https://lucid.readme.io/docs/get.md): Gets the associated value from an object for the specified key. - [GROUPBY](https://lucid.readme.io/docs/groupby.md): Creates an object from an array and a key expression which determines the key for each item, and a value expression which determines the value. - [HAS](https://lucid.readme.io/docs/has.md): Returns true if the object or reference has a value with the specified key. - [KEYS](https://lucid.readme.io/docs/keys.md): Return the array of strings which will can be referenced using [GET()](doc:get) on the parameter. Defaults to `THIS` if no argument provided. - [OBJECT](https://lucid.readme.io/docs/object.md): Creates an object that can be queried by key. Arguments are passed in as either an array of key-value pairs or as paired key and value parameters. - [VALUES](https://lucid.readme.io/docs/values.md): Returns the dereferenced values of all keys available on the specified parameter. Defaults to `THIS` if no argument provided. (When on a shape data property, `VALUES(THIS)` always returns at least… - Smart Containers - [CONTAINER](https://lucid.readme.io/docs/container.md): Gets the container that contains the selected item in a Smart Container. - [CONTENTS](https://lucid.readme.io/docs/contents.md): Gets the contents of the selected Smart Container. - Trigonometric - [ACOS](https://lucid.readme.io/docs/acos.md): Calculates the inverse cosine of the specified number (arccosine), in radians. - [ACOSH](https://lucid.readme.io/docs/acosh.md): Calculates the inverse hyperbolic cosine of the specified number. - [ACOT](https://lucid.readme.io/docs/acot.md): Calculates the inverse cotangent of the specified number (arccotangent), in radians. - [ACOTH](https://lucid.readme.io/docs/acoth.md) - [ASIN](https://lucid.readme.io/docs/asin.md): Calculates the inverse sine of the specified number (arcsine), in radians. - [ASINH](https://lucid.readme.io/docs/asinh.md): Calculates the inverse hyperbolic sine of the specified number. - [ATAN](https://lucid.readme.io/docs/atan.md): Calculates the inverse tangent of the specified number (arctangent), in radians. - [ATAN2](https://lucid.readme.io/docs/atan2.md): Calculates the inverse tangent of the specified x- and y-coordinates (arctangent). - [ATANH](https://lucid.readme.io/docs/atanh.md): Calculates the inverse hyperbolic tangent of the specified number. - [COS / COSINE](https://lucid.readme.io/docs/cos.md): Calculates the cosine, using the specified angle in radians. - [COSH](https://lucid.readme.io/docs/cosh.md): Calculates the hyperbolic cosine of the specified angle, in radians. - [COT](https://lucid.readme.io/docs/cot.md): Calculates the cotangent, using the specified angle in radians. - [DEGREES](https://lucid.readme.io/docs/degrees.md): Converts the specified angle from radians to degrees. - [RADIANS](https://lucid.readme.io/docs/radians.md): Converts the specified angle from degrees to radians. - [SIN / SINE](https://lucid.readme.io/docs/sin.md): Calculates the sine, using the specified angle in radians. - [SINH](https://lucid.readme.io/docs/sinh.md): Calculates the hyperbolic sine of the specified angle, in radians. - [TAN / TANGENT](https://lucid.readme.io/docs/tan.md): Calculates the tangent, using the specified angle in radians. - [TANH](https://lucid.readme.io/docs/tanh.md): Calculates the hyperbolic tangent of the specified angle, in radians. - Color Creation - [HEXCOLOR](https://lucid.readme.io/docs/hexcolor.md): Creates a new color from the specified hexadecimal color string. - [HSL / HSLA](https://lucid.readme.io/docs/hsl.md): Creates a new color from the specified hue, saturation, lightness and alpha values. - [HSV / HSVA](https://lucid.readme.io/docs/hsv.md): Creates a new color from the specified hue, saturation, value and alpha values. - [RGB / RGBA](https://lucid.readme.io/docs/rgb.md): Creates a new color from the specified red, green, blue and alpha values. - Color Values - [ALPHA](https://lucid.readme.io/docs/alpha.md): Gets the alpha channel of the specified color. Returns a decimal from 0 to 1. - [BACKGROUNDCOLOR / FILLCOLOR](https://lucid.readme.io/docs/backgroundcolor.md): Returns the fill color of the referenced object. - [BLUE](https://lucid.readme.io/docs/blue.md): Gets the blue channel of the specified color in the RGB colorspace. Returns an integer from 0 to 255. For more information about the RGB colorspace, see: - [GREEN](https://lucid.readme.io/docs/green.md): Gets the green channel of the specified color in the RGB colorspace. Returns an integer from 0 to 255. For more information about the RGB colorspace, see: - [HSVHUE](https://lucid.readme.io/docs/hsvhue.md): Gets the hue channel of the specified color in the HSV colorspace. Returns an integer from 0 to 360. For more information about hue, see: - [HSVSATURATION](https://lucid.readme.io/docs/hsvsaturation.md): Gets the saturation channel of the specified color in the HSV colorspace. Returns a decimal number from 0 to 1. For more information about hue, see:… - [HSVVALUE](https://lucid.readme.io/docs/hsvvalue.md): Gets the value channel of the specified color in the HSV colorspace. Returns a decimal from 0 to 1. For more information about value, see: - [HUE](https://lucid.readme.io/docs/hue.md): Gets the hue channel of the specified color in the HSL colorspace. Returns an integer from 0 to 360. For more information about hue, see: - [LIGHTNESS](https://lucid.readme.io/docs/lightness.md): Gets the lightness channel of the specified color in the HSL colorspace. Returns a decimal number from 0 to 1. For more information about hue, see:… - [LUMINANCE](https://lucid.readme.io/docs/luminance.md): Calculates the luma (perceptual brightness) of the specified color. Uses SMPTE C / Rec. 709 coefficients, as recommended in WCAG 2.0. For more information, see:… - [RED](https://lucid.readme.io/docs/red.md): Gets the red channel of the specified color in the RGB colorspace. Returns an integer from 0 to 255. For more information about the RGB colorspace, see: - [SATURATION](https://lucid.readme.io/docs/saturation.md): Gets the saturation channel of the specified color in the HSL colorspace. Returns a decimal number from 0 to 1. For more information about hue, see:… - Color Operations - [CONTRAST](https://lucid.readme.io/docs/contrast.md): Determines which of the two specified colors has a higher contrast against the given color. - [DARKEN](https://lucid.readme.io/docs/darken.md): Creates a new color from the specified color by decreasing the lightness in the HSL color space. - [DESATURATE](https://lucid.readme.io/docs/desaturate.md): Creates a new color from the specified color by decreasing the saturation in the HSL color space. - [FADE](https://lucid.readme.io/docs/fade.md): Creates a new color from the specified color by setting the opacity to a specific value. - [FADEIN](https://lucid.readme.io/docs/fadein.md): Creates a new color from the specified color by increasing the opacity. - [FADEOUT](https://lucid.readme.io/docs/fadeout.md): Creates a new color from the specified color by decreasing the opacity. - [GRAYSCALE / GREYSCALE](https://lucid.readme.io/docs/grayscale.md): Creates a new color from the specified color by removing all saturation in the HSL color space. - [LIGHTEN](https://lucid.readme.io/docs/lighten.md): Creates a new color from the specified color by increasing the lightness in the HSL color space. - [MIX](https://lucid.readme.io/docs/mix.md): Creates a new color by combining two specified colors in a given proportion. - [SATURATE](https://lucid.readme.io/docs/saturate.md): Creates a new color from the specified color by increasing the saturation in the HSL color space. - [SHADE](https://lucid.readme.io/docs/shade.md): Creates a new color by mixing the specified color with black in a given proportion. - [SPIN](https://lucid.readme.io/docs/spin.md): Creates a new color from the specified color by rotating the hue in the HSL color space. - [TINT](https://lucid.readme.io/docs/tint.md): Creates a new color by mixing the specified color with white in a given proportion. - Color Blending - [BLENDMULTIPLY](https://lucid.readme.io/docs/blendmultiply.md): Creates a new color by multiplying the corresponding RGB channels of the specified colors, resulting in a darker color. - [BLENDSCREEN](https://lucid.readme.io/docs/blendscreen.md): Creates a new color by inverting and then multiplying the corresponding RGB channels of the specified colors, resulting in a lighter color. - [BLENDOVERLAY](https://lucid.readme.io/docs/blendoverlay.md): Creates a new color from the two provided by performing an overlay blend, making light colors lighter and dark colors darker. - [BLENDSOFTLIGHT](https://lucid.readme.io/docs/blendsoftlight.md): Creates a new color by performing a soft light blend. - [BLENDHARDLIGHT](https://lucid.readme.io/docs/blendhardlight.md): Creates a new color by performing a hard light blend. - [BLENDDIFFERENCE](https://lucid.readme.io/docs/blenddifference.md): Creates a new color by subtracting one provided color from the other. - [BLENDEXCLUSION](https://lucid.readme.io/docs/blendexclusion.md): Creates a new color by performing an exclusion blend. - [BLENDAVERAGE](https://lucid.readme.io/docs/blendaverage.md): Blends the two provided colors by averaging the respective values in each channel. - [BLENDNEGATION](https://lucid.readme.io/docs/blendnegation.md): Creates a new color from the two provided using a negation function. ## Documentation: Standard Import - [Overview](https://lucid.readme.io/docs/overview-si.md) - [Reference](https://lucid.readme.io/docs/reference-si.md) - [Pages](https://lucid.readme.io/docs/pages-si.md) - [Shapes](https://lucid.readme.io/docs/shapes-si.md) - [Standard Library](https://lucid.readme.io/docs/standard-library-si.md) - [Shape Library](https://lucid.readme.io/docs/shape-library-si.md) - [Container Library](https://lucid.readme.io/docs/container-library-si.md) - [Flowchart Library](https://lucid.readme.io/docs/flowchart-library-si.md) - [Lucidspark Library](https://lucid.readme.io/docs/lucidspark-library-si.md) - [BPMN 2.0 Library](https://lucid.readme.io/docs/bpmn-20-library-si.md) - [BPMN Shapes Reference](https://lucid.readme.io/docs/bpmn-shapes-reference-si.md) - [Table Library](https://lucid.readme.io/docs/table-library-si.md) - [AWS 2024 Library](https://lucid.readme.io/docs/aws-2024-library.md) - [Azure 2021 Library](https://lucid.readme.io/docs/azure-2021-library.md) - [Azure 2024 Library](https://lucid.readme.io/docs/azure-2024-library.md) - [GCP 2021 Library](https://lucid.readme.io/docs/gcp-2021-library.md) - [Data Backed Shapes](https://lucid.readme.io/docs/data-backed-shapes-si.md) - [Lines](https://lucid.readme.io/docs/lines-si.md) - [Groups](https://lucid.readme.io/docs/groups-si.md) - [Layers](https://lucid.readme.io/docs/layers-si.md) - [Images](https://lucid.readme.io/docs/images-si.md) - [Data](https://lucid.readme.io/docs/data-si.md) - [Troubleshooting](https://lucid.readme.io/docs/troubleshooting-si.md) ## Documentation: Partner Resources - [Co-Marketing](https://lucid.readme.io/docs/co-marketing-guide.md)