Clay Icon
Join the Community
02 Support

Error: Failed to Parse Formula at Offset 23

Avatar of Andi D.Andi D.
·
·

"Failed to parse formula with error: {"offset":23,"token":{"value":"A"}}"

15 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Try these steps to resolve the formula parsing error: 1. First, refresh your browser using Cmd/Ctrl + Shift + R. 2. If the error persists, check your formula logic. The error might be occurring because the formula is trying to process data that doesn't exist. Try adding conditional logic to your formula that checks if the data exists before processing it (e.g., "if {{response}} exists...").

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Did that answer your question?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Looks like you're still looking for help.

    If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!

  • Avatar of Andi D.
    Andi D.
    ·
    ·

    https://app.clay.com/workspaces/449716/workbooks/wb_wHanNePHeGxt/tables/t_kWWDTrDtrGzZ/views/gv_HEEQCaYQdcbs Hey team, table above^ the data exists, just can't pull it out into a independent column for some reason

  • Avatar of LuisArturo
    LuisArturo
    ·
    ·

    - Do you mind sending the link (url) to the table so we can take a look?

    (52 kB)
    Image
  • Avatar of LuisArturo
    LuisArturo
    ·
    ·

    Hey there sorry for the delay, here was taking a look at this and did see this error anywhere in the table. Did you remove the column here?

  • Avatar of Andi D.
    Andi D.
    ·
    ·

    Hi Luis, had to hide the columns to move forward with some work lol

  • Avatar of Andi D.
    Andi D.
    ·
    ·
  • Avatar of Andi D.
    Andi D.
    ·
    ·

    this is the column if you wanna take a look

  • Avatar of Andi D.
    Andi D.
    ·
    ·

    tried to refresh, deleate and create new a couple of times and no success

  • Avatar of LuisArturo
    LuisArturo
    ·
    ·

    Thank you Andi, question what are you hoping for this formula to do, the issue here is the java is not properly formatted.

    (8 kB)
    Image
  • Avatar of Andi D.
    Andi D.
    ·
    ·

    humm, this is a data point I've put together in previous tables. I'm just looking to pull it out from the parent column and so it has its own column in the new table

  • Avatar of Andi D.
    Andi D.
    ·
    ·

    Thx for the help Luis! Im not very technical what exactly do I need to do here?

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hi - Sorry for this.

    You'd need to repeat the formula that was previously added in the previous table so it's finding it correctly. See example here:

    Let me know if you need more help with that!

    (1935 kB)
    Image
    🙏1