Skip to main content
Question

How do I map mobile phone to office phone if office phone is null in mySQL to Zoho CRM?

  • October 25, 2024
  • 2 replies
  • 8 views

This seems simple, but I cant find a solution so far.

 

Input (mySQL):

Office Phone (optional)

Mobile Phone (mandatory)

 

Output (Zoho CRM):

Office Phone (mandatory)

Mobile Phone (mandatory)

 

If input office phone is null, map mobile phone to office phone.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 25, 2024

Hi @ImpulseTakeoffs 

Zap action: Formatter > Text > Default Value

https://zapier.com/apps/formatter/help


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • October 28, 2024

Hi @ImpulseTakeoffs,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.