Clay Icon

Hey hey, running into syntax errors in the formula editor.

·
·

Hey hey, running into syntax errors in the formula editor.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Syntax errors in the formula editor can occur due to various reasons. Here are some common issues and solutions: 1. Ensure your keys are surrounded by double quotes, especially when using dynamic columns. 2. Check for proper punctuation and syntax, including commas between keys and correct use of colons and brackets. 3. Look for hidden characters by copying your formula into a text editor. 4. Use the AI Formula Generator for assistance: • Add a new column and select "Formula" • Type your desired action in the AI Formula Generator box • Use "/" to reference columns • Click "Generate Formula" and review the sample output • Click "Save Formula" if it looks correct If you're still experiencing issues, consider requesting human assistance by clicking on "Talk to a person" for more detailed troubleshooting.

  • Avatar of Joe R.
    Joe R.
    ·
    ·

    Hey Andreas - based on what I can see in the screenshot, it looks like you’re missing the double curly braces around the second Funding, Stage (AI) value (screenshot). There might be other bugs but just wanted to point this one out in case it solves your issue

  • Avatar of Andreas W.
    Andreas W.
    ·
    ·

    Hey Hey friend 🙂 That’s my point - the editor should translate my promote into code. Otherwise I have to build the Java script dirctly and that defeats the purpose

  • Avatar of Joe R.
    Joe R.
    ·
    ·

    Oh haha I see - I missed the part where you prompted the formula editor, oops

  • Avatar of Daniel K.
    Daniel K.
    ·
    ·

    Hey Andreas, thanks fore reaching out. Could you try changing the type of column from Text to Numbers? If this didn't do the trick, can you share the table? Cheers

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·