Best answer

How can I convert a phone number from number format to a text format?

  • 1 February 2023
  • 5 replies
  • 126 views

Userlevel 2

Hello,

 

i use Google contacts with sendinblue.

 

Now i have the problem, that the phonenumer is in sendinblue a TEXT-Field. In my Zap the phonenumber is a number field. So my question is. How can i change the format from number to TEXT-Field in Zapier?

Thank you.

icon

Best answer by nicksimard 1 February 2023, 17:26

View original

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

5 replies

Userlevel 7
Badge +14

Hi @vantage 

Good question.

Are you encountering an error when trying to map variable across your Zap steps?

Have you tried testing the Zap step after mapping the variables?

Please provide detailed screenshots in order for us to have context, thanks.

Userlevel 2

Hello Troy,

 

i have the Error 400 and yes, and i have tested the step before.

Screenshots i will send you later.

Peter

Userlevel 7
Badge +11

 Hi@vantage!

If you take a look at the API documentation for Sendinblue, you can see that these are the accepted formats for numbers:

 

Taking a look at our Formatter (find this under Formatter — Numbers — Format Phone Number), I’d say one of the following should work for you, but be sure to do some testing, to confirm. So the first option or the second last, as shown below:

251c3e837a4ddfe9755c24bec1f0570e.gif

Userlevel 2

Hi @nicksimard !

 

Thanks a lot. With the formatter it was possible to do the zap! 😀

 

Userlevel 7
Badge +9

Ayy! 🎉 Stoked to hear Nick’s recommendation’s did the trick for ya! 

Happy Zapping! 🧡