Skip to main content
Best answer

Filter a field

  • February 20, 2021
  • 2 replies
  • 64 views

I have created a zap between Google calendar and Gmail, to email upcoming guests for my podcast 48 hours before the recording, providing them with some information.

The calendar entry is populated from Calendly.

 

The issue I have is that I have the the fields/info I need but have one problem with the name of the guest. The only place their name is added to the calendar entry is in the Title, but Calendly also adds in the title is the guests name plus my name, so it reads for example:
“John Smith and Tony Winyard”

 

When I setup the email on gmail to be sent to them, and start it with “Hi”, it then adds:

“Hi John Smith and Tony Winyard”

which is weird from the guests' perspective, as they’ll be wondering why I’m emailing myself!

 

is there any way of filtering out my name from that result, so that it only adds their name, and ideally just their first name?

Best answer by Troy Tessalone

Hi @TonyW 

You can use the Formatter > Text > Split step to do this: https://zapier.com/help/doc/how-use-formatter-functions#using-split-text

OR

You can use the Formatter > Text > Replace step to do this: https://zapier.com/help/doc/how-use-formatter-functions#using-replace

View original
Did this topic help you find an answer to your question?
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
Forum|alt.badge.img+14
  • Zapier Expert
  • 31398 replies
  • Answer
  • February 20, 2021

Hi @TonyW 

You can use the Formatter > Text > Split step to do this: https://zapier.com/help/doc/how-use-formatter-functions#using-split-text

OR

You can use the Formatter > Text > Replace step to do this: https://zapier.com/help/doc/how-use-formatter-functions#using-replace


  • Author
  • Beginner
  • 4 replies
  • February 20, 2021

Thank you, Troy, that was exactly what I was looking for.

I’ve used that and it now works perfectly.