Connect Formatting to SmartSuite

Convert an object to a JSON format string

Parse a JSON string

Add or subtract time from a given input

Get the duration between two dates in days, hours, minutes, and seconds along with checking if they are the same.

Format a date string to another date string. For more examples on formatting, see the Sugar Date Format documentation.

Format a number as a currency

Format a number to a new style. Does not perform any rounding or padding of the number.

Convert valid HTML to Markdown text

Convert valid HTML to text

Convert Markdown text to HTML

Decode a URL string

Encode a string as a URL

Find a match for a regular expression pattern. Returns all matched groups with start and end position.

Find an email address out of a text field. Finds the first email address only.

Find a number out of a text field. Finds the first number only.

Find a complete phone number out of a text field. Finds the first number only.

Find a web URL out of a text field. Finds the first URL only.

Replace all instances of any character, word or phrase in the text with another character, word or phrase.

Return a default value if the text is empty

Split the text on a character or word and return one or all segments

Transform case for a text input

Removes leading and trailing whitespace

Creates a new record. See the documentation

Search for records based on matching field(s). See the documentation

Retrieves available options for the Solution ID field.

Retrieves available options for the Table ID field.