This article covers the demonstration of execution of other formulas when a text or URL is passed in the formula mode.
What you'll need:
Skill level: Intermediate
Time required: 5 minutes
- Skills for understanding bas64 content
Let's take an example text Hello world and tweak it using the following formulas:
This formula encodes the provided string input in the URL format:
This function helps decode the provided string from URL format to plain text format:
Encodes the given plain text string text using the base64 algorithm:
Decodes the given base64 text string to its original plain text format using the base64 algorithm. Let's decode the above base64 result:
This function helps in extracting a list of specific properties from each item/element present in an array. It comes with a syntax
.pluck(""). Within the double quotes, specify the key element present in an array of which details you want to retrieve:
This function finds an existing string and replaces it with a newly specified string. It comes with a syntax
.findAndReplace("",""). Specify the existing string data within the first double quotes, which should be searched and the new string data in the second double quotes which should replace the old string data:
Note: The data you want to replace must exist in the input specified.
This function helps to join different string elements and convert them to a single string. The elements that need to be joined need to be mentioned in an array are separated by a specified separator. The default separator is comma (,). The syntax is
.join(""). Within the double quotes, you need to specify the separator using which the elements of the array will be joined. Here we have used space as a separator:
Note: If a separator is not defined within the double quotes, all the elements in an array will merge together.
As the name suggests, this function returns the last element of an array: