Introduction: Why Make.com Functions Matter 🤔
Ever feel like you’re drowning in repetitive tasks? Make.com functions are here to rescue you! They’re like secret shortcuts, letting you manipulate data within your automations without breaking a sweat. Think of them as mini-programs inside Make.com, ready to tackle anything from simple calculations to complex data transformations.
🧮 Math Functions: Crunching Numbers with Ease
1. Rounding Up and Down: Ceil & Floor
- Ceil: Always rounds a number up to the nearest whole number. Think of it like reaching for the ceiling!
- Example:
ceil(1.2)= 2
- Example:
- Floor: Does the opposite, rounding down to the nearest whole number. Like dropping to the floor!
- Example:
floor(2.9)= 2
- Example:
2. Finding the Extremes: Max Value & Min Value
- Max Value: Picks the largest number from a list.
- Example:
max(1, 5, 2, 8)= 8
- Example:
- Min Value: Finds the smallest number in a list.
- Example:
min(1, 5, 2, 8)= 1
- Example:
3. Rounding to Perfection: Round
- Round: Rounds a number to a specific number of decimal places.
- Example:
round(3.14159, 2)= 3.14
- Example:
💡 Pro Tip: Combine round with multiplication and division to control the number of decimal places.
🔠 Text Functions: Mastering the Art of Words
1. Transforming Text: Lowercase, Capitalize, Start Case, Uppercase
- Lowercase: Makes all letters lowercase.
- Example:
lowercase("HELLO")= “hello”
- Example:
- Capitalize: Capitalizes the first letter of a string.
- Example:
capitalize("hello world")= “Hello world”
- Example:
- Start Case: Capitalizes the first letter of each word.
- Example:
startCase("hello world")= “Hello World”
- Example:
- Uppercase: Makes all letters uppercase.
- Example:
uppercase("hello")= “HELLO”
- Example:
2. Finding and Replacing: Contains, Replace
- Contains: Checks if a piece of text contains a specific word or phrase. Returns
trueorfalse.- Example:
contains("Hello world", "world")=true
- Example:
- Replace: Swaps out one piece of text for another.
- Example:
replace("Hello world", "world", "Make.com")= “Hello Make.com”
- Example:
💡 Pro Tip: Use contains with if/else statements to create conditional workflows based on text content.
📅 Date and Time Functions: Your Time-Bending Toolkit
1. Getting the Current Moment: Now
- Now: Gives you the current date and time. Super handy for timestamps!
2. Adding and Subtracting Time: Add Time
- Add Time: Lets you add or subtract specific units of time (seconds, minutes, hours, etc.) from a date.
- Example:
addTime(now, 1, "day")adds one day to the current date.
- Example:
3. Comparing Dates: Compare Dates
- Compare Dates: Calculates the difference between two dates in your chosen unit (seconds, minutes, etc.).
- Example: Find the difference in days between two dates.
💡 Pro Tip: Use now with addTime to schedule tasks or create deadlines within your automations.
🗄️ Array Functions: Taming Lists Like a Pro
1. Combining Elements: Join
- Join: Merges all elements of an array into a single string, separated by your chosen character.
- Example:
join(["apple", "banana", "cherry"], ", ")= “apple, banana, cherry”
- Example:
2. Slicing and Dicing: Slice
- Slice: Extracts a portion of an array, letting you choose the starting and ending points.
- Example:
slice([1, 2, 3, 4, 5], 1, 3)= [2, 3]
- Example:
3. Removing Duplicates: Distinct, DeDuplicate
- Distinct: Removes duplicate objects from an array based on a specific key.
- Example: Remove duplicate customers based on their email address.
- DeDuplicate: Removes duplicate values from a simple array (numbers, text).
- Example:
deduplicate([1, 2, 2, 3, 4, 4, 5])= [1, 2, 3, 4, 5]
- Example:
💡 Pro Tip: Use slice to work with specific parts of a list, like extracting the first three items.
🧰 Resource Toolbox
Here are some resources to dive deeper into Make.com functions:
- Make.com Functions Documentation: https://www.make.com/en/help/functions – Your comprehensive guide to all available functions.
- Make.com Community Forum: https://www.make.com/en/community – Get help from the Make.com community and share your automation expertise.
Conclusion: Level Up Your Automation Game 💪
Make.com functions are your secret weapons for building powerful and efficient automations. By mastering these tools, you’ll unlock a world of possibilities, freeing up your time and boosting your productivity. So go forth and automate like a pro!
