Name with "" cant be put to formula- text field.

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

My syntax is having error because the name has " " on it. I tried TO TEXT() but it didnt worked out.

If([Employee Name]="Kristine "Ann" Yates",ToUser("kristineyates@xyz.com")

Photo of Ann

Ann

  • 22 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
no problem.

When you have a string which has quote in it, you will need to escape the quote, which means to tell QuickBase to treat the next character as a regular character and not take action it it normally does for a quote.  The escape characater is a backslash \.



So try this

If([Employee Name]="Kristine \"Ann\" Yates",ToUser("kristineyates@xyz.com")
Photo of Ann

Ann

  • 22 Points
It worked! Thank you!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
Yay.  Hopefully you don't have any employees with backslashes in their name. :)