Converts an integer into its most compact representation.
Modifies a color by brightening, darkening, saturating, and adjusting transparency.
Add one array to the end of another
True if array contains the element. False otherwise.
Get the length of an array.
Generate barcodes.
Converts the first character of string to upper case and the remaining to lower case.
Check that text matches a regular expression.
Clamps a number within inclusive lower and upper bounds.
Create a palette of colors from a start and end color.
Convert a quantity from one unit to another.
Get the number of days, weeks, months, or years between dates. Accuracy is casual by default, but you can use 'longterm' accuracy for a pedantic 400-year calendar.
Decode text in a variety of formats.
Find items duplicated in an array
Uses gravatar.com to find a person's photo given their email address.
Encode text in a variety of formats.
Run Excel formulas
Extract text matching a regular expression.
Extract text matching a regular expression, returning an array of matches.
Fetch and optionally transform JSON
Formats the value like a 'human-readable' file size (i.e. '13 KB', '4.1 MB', '102 bytes', etc).
Finds the first index of an element in an array
Powerful date & time formatting with luxon.
Format a duration in seconds into text like '1:30'.
Extract pieces of a URL.
Beautiful hand-crafted SVG icons, by the makers of Tailwind CSS.
Get an image based on a CSS color.
Get initials for text.
True if value is false or false-like, otherwise false.
True if value is true or true-like, otherwise false.
Runs JavaScript
"hello world" → "hello-world"
Produces a 'lorem ipsum' style string
Converts string to lower case.
Returns a JSON Object String
Convert markdown to HTML.
True becomes false. False (and blank) become true.
Converts an integer to its ordinal as a string. e.g. 22nd
Pads string on the left and right sides if it's shorter than length. Padding characters are truncated if they can't be evenly divided by length.
Pads string on the right side if it's shorter than length. Padding characters are truncated if they exceed length.
Pads string on the left side if it's shorter than length. Padding characters are truncated if they exceed length.
Parts of Speech extractor
Returns the plural version of a given word if the value is not 1. The default suffix is 's'.
Generate QR codes from any value.
Turn any value into a stable random number.
Given a date, returns a string with the relative time (e.g. '1 day ago').
Remove all instances of an item from an array
Remove all elements in an array from another array
Deburrs string by converting Latin-1 Supplement and Latin Extended-A letters to basic Latin letters and removing combining diacritical marks.
Repeats the given string n times.
Replace every occurrence of some text with some other text.
Reverses the order of items in an array
Roll dice of various sizes.
The SHA256 column takes a string value and returns the 256 length string hash.
Convert a solitary value to an array
Produces a subsection of an array by specifying the start and end indices
Sort the items in an array
"hello world" → "Hello World"
Indicates whether text is an email.
Indicates whether text is a URL.
Gets the length of a text snippet
Gets the zero-based offset of the zero-based N-th occurence of needle in haystack
Gets a substring out of text, from zero-indexed "start" with an optional length
Convert text to a date.
Get an emoji from a piece of text
Transform JSON with JQ
Remove whitespace around text.
Truncates a string if it is longer than the specified number of characters. Truncated strings will end with a translatable ellipsis sequence ("…").
Remove duplicate entries from an array
Converts string to upper case.
Count words in text.
Display video thumbnail images
Start creating the apps you need in minutes. No coding needed.
Glide turns spreadsheets into beautiful, intelligent apps.