Forum Discussion

RyanKjesbo-Joh1's avatar
RyanKjesbo-Joh1
Qrew Trainee
7 years ago

Formula Field Unable to Process Past \

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")

2 Replies

  • 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")