Formula Field Unable to Process Past \

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I am trying to create a formula text field and keeping getting an error saying that there are characters outside of the formula.  I am trying to create a file path to pass through Zapier to our cloud server.  Here is the formula:

List("", 
[Term Slot - Term Awards: Grant - Program Year - Fiscal Year],
"\Year Long\", 
[Common Person ID# - Current Member Term: Term Award - Grant Name], 
"\", 
[Term Slot - Person - Contact: Legal Last Name], 
", ", 
[Term Slot - Person - Contact: Legal First Name],
 "\", 
[Term Slot - Person - Contact: Legal Last Name], 
", ", 
[Term Slot - Person - Contact: Legal First Name], 
" PRU ", 
Case([Email Subject],"January", "January","February", "February","March", "March","April", "April","May", "May","June", "June","July", "July","August", "August","September", "September", "October", "October","November", "November","December", "December"),
".pdf")
Photo of Ryan Kjesbo-Johnson

Ryan Kjesbo-Johnson

  • 110 Points 100 badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
The \ character has a special meaning in a formula, used when you really do want, say to include a quote inside quotes.

Can you try this.While you see \\ the result should just be \



List("", 
[Term Slot - Term Awards: Grant - Program Year - Fiscal Year],
"\\Year Long\\", 
[Common Person ID# - Current Member Term: Term Award - Grant Name], 
"\\", 
[Term Slot - Person - Contact: Legal Last Name], 
", ", 
[Term Slot - Person - Contact: Legal First Name],
 "\\", 
[Term Slot - Person - Contact: Legal Last Name], 
", ", 
[Term Slot - Person - Contact: Legal First Name], 
" PRU ", 
Case([Email Subject],"January", "January","February", "February","March", "March","April", "April","May", "May","June", "June","July", "July","August", "August","September", "September", "October", "October","November", "November","December", "December"),
".pdf")
Photo of Ryan Kjesbo-Johnson

Ryan Kjesbo-Johnson

  • 110 Points 100 badge 2x thumb
Yes, that worked perfect.  Thank you!