Discussions

Expand all | Collapse all

Formula Field Unable to Process Past \

  • 1.  Formula Field Unable to Process Past \

    Posted 09-20-2017 16:38
    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.  RE: Formula Field Unable to Process Past \

    Posted 09-20-2017 16:44
    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")


  • 3.  RE: Formula Field Unable to Process Past \

    Posted 09-20-2017 16:49
    Yes, that worked perfect.  Thank you!