Make.com LabBeginner
Set a Default Value with ifempty() in Make.com
Some leads don't provide a phone number, and your Google Sheet shows blank cells. Show 'N/A' instead.
Live Execution Simulator
Idle
π₯
Incoming Data
βοΈ
Make.com Node
π―
Next Step
> Ready. Type your expression below and click "Check Answer" to run the node.
Incoming Payload / Data:
{
"phone": ""
}
Press Enter or click Check Answer. +10 XP
β Solution & explanation
ifempty(phone; N/A)
Output: N/A
ifempty(value1; value2) returns value1 if it has content, otherwise value2. It's shorter than writing a full if() for missing data.π‘ Pro tip: Chain fallbacks: ifempty(mobile; ifempty(phone; N/A)).
Also accepted: ifempty(phone; "N/A")