Explore every Make.com function, variable, operator, and keyword through practical examples in this comprehensive 92-minute tutorial. Master mathematical functions including ceil, floor, max, min, round, sum, and average operations, along with number parsing and formatting techniques. Learn conditional logic with if statements, switch statements, and empty value handling, plus data manipulation using omit, picker, and get functions. Discover string manipulation capabilities through case conversion, replace, trim, substring, and index functions, as well as URL encoding and text searching methods. Understand date and time operations for adding time, comparing dates, setting date values, formatting, and parsing date strings. Dive deep into array manipulation with 20+ array functions covering joining, length calculation, key extraction, slicing, merging, searching, adding, removing, mapping, shuffling, sorting, reversing, and accessing first/last elements. Gain proficiency in advanced array operations like flattening, deduplication, distinct value extraction, and array creation. Conclude with custom and system variables to enhance your automation workflows. Each function is demonstrated with real-world examples to help you implement these tools effectively in your Make.com scenarios.

Syllabus

0:00 Intro
3:16 Ceil Function
3:47 Floor Function
4:15 Max Value Function
6:13 Min Value Function
6:58 Round Function
8:53 Sum Function
9:26 Average Function
9:59 Parse Number Function
11:44 Formatting Number Function
13:06 Math Operators
14:25 Greater/Less Than Operators
14:34 Modulo Operator
15:23 PI/Random Number Variables
16:00 If Statement Functions
18:34 If/Empty Function
19:58 Switch Statement Function
22:35 Omit/Picker Functions
26:45 Get Function
29:45 General Operators
35:37 Length Function
36:10 Case Functions
39:25 Replace Function
40:02 Trim Function
40:35 Substring Function
41:32 Index Function
44:20 Encoding URL Functions
48:25 Contain Function
49:45 Split Function
54:15 Add Time Function
56:11 Compare Dates Function
57:42 Set Dates Functions
1:00:24 Format Date Functions
1:01:19 Parsing Date Function
1:03:57 Array Functions
1:04:45 Array Join Function
1:07:30 Array Length Function
1:08:44 Array Key Function
1:10:50 Array Slice Function
1:12:45 Array Merge Function
1:14:23 Array Contains Function
1:15:45 Array Remove Function
1:17:08 Array Add Function
1:17:42 Array Map Function
1:20:00 Array Shuffle Function
1:20:50 Array Sort Function
1:22:20 Array Reverse Function
1:23:20 Array First Function
1:23:56 Array Last Function
1:24:30 Flatten Function
1:25:46 Array Distinct Function
1:26:47 Array DeDuplicate Function
1:28:15 Array ToArray Function
1:29:14 Create Empty Array
1:30:19 Custom & System Variables