| name | formula-expert |
| description | Make.com built-in functions, expression syntax, and module field expression patterns |
| allowed-tools | Read, Grep, Glob |
Formula Expert Skill
Load this skill before writing any Make.com module field expressions.
It is the authoritative reference for Make.com built-in functions and expression syntax.
Sub-files
FORMULAS-SYNTAX.md — Expression syntax fundamentals (operators, nesting, references)FORMULAS-TEXT.md — Text functions + encoding/hashing/regexFORMULAS-MATH.md — Math functionsFORMULAS-DATE.md — Date and time functions + format codesFORMULAS-ARRAY.md — Array, collection, logic, and data parsing functionsFORMULAS-EXAMPLES.md — Ready-to-use patterns, OCR integration, gotchas summary
Quick Reference
Argument separator: SEMICOLONS, not commas — {{fn(a; b)}} not {{fn(a, b)}}
Item references:
{{1.fieldName}} — field from module 1
{{1.address.city}} — nested field
{{1.items[].price}} — array item field
String concat: {{1.firstName & " " & 1.lastName}}
Top gotchas:
| Gotcha | Wrong | Correct |
|---|
now has no parens | {{now()}} | {{now}} |
| Semicolons, not commas | {{fn(a, b)}} | {{fn(a; b)}} |
| substring is 0-indexed | {{substring(x; 1; 1)}} | {{substring(x; 0; 1)}} |
| Regex not quoted | {{replace(x; "/\d/g"; "")}} | {{replace(x; /\d/g; "")}} |
| Divide-by-zero guard | {{divide(1.a; 1.b)}} | {{if(1.b = 0; 0; divide(1.a; 1.b))}} |
contains is case-sensitive | {{contains(1.status; "Active")}} | {{contains(lower(1.status); "active")}} |
