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

Andreas W.

6 comments

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.
Sources: HTTP API with JWT authentication | Documentation | Clay University Formulas HTTP API integration overview | Documentation | Clay University
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
🙌1
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
Joe R.
·
·
Oh haha I see - I missed the part where you prompted the formula editor, oops
😃1
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
Channeled
APP
·
·