Best answer

Filter a field

  • 20 February 2021
  • 2 replies
  • 63 views

Userlevel 1

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?

icon

Best answer by Troy Tessalone 20 February 2021, 17:27

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.

2 replies

Userlevel 7
Badge +14

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

Userlevel 1

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

I’ve used that and it now works perfectly.