What syntax does Clay’s formulas use? Is there a guide/resource for writing them manually? No matter how many times I describe what I want with AI, the formula generated is invalid. I can just use an AI column to do the data operation, but would rather do it with a free formula column if I can write my own formula.
Clay uses a combination of AI-generated formulas and custom syntax for manual writing. For AI-generated formulas, you can use the Formula Generator:
1. Add a new "formula" column to your table
2. Enter your instructions, using "/" to reference columns
3. Click "Generate formula"
4. Review the output and click "Save Formula"
For manual writing, Clay supports conditional statements and various operators. Here's a basic example: LBKSIF (person.email contains @gmail.com OR @yahoo.com) return "Invalid email format" ELSE return "Valid email format"LBKSTo learn more about writing formulas manually, check out our blog posts on formulas in Clay, which cover the basics and advanced techniques.
its javascript
Clay's formulas use JavaScript syntax. For writing formulas manually, we have resources available. You can use conditional statements, comparison operators, and various JavaScript functions. Here's a basic example: LBKSIF (person.email contains @gmail.com OR @yahoo.com) return "Invalid email format" ELSE return "Valid email format"LBKSTo learn more about writing formulas, check out our blog posts and documentation on formulas in Clay. These cover both basics and advanced techniques. If you need help with specific formulas, you can use our AI Formula Generator or request human assistance for more complex cases.
But it seems like not all aspects of JavaScript are supported, right? Like you can’t define functions or variables. I asked ChatGPT to write a formula in JS but Clay didn’t accept it
Clay's formula syntax supports a subset of JavaScript functionality. While it allows for basic operations and conditional statements, it has limitations compared to full JavaScript. The formula syntax in Clay is designed to be simple and focused on data manipulation within the context of a spreadsheet-like environment. This means that certain JavaScript features, such as defining functions or variables, may not be supported. To write effective formulas in Clay, it's best to use the AI Formula Generator or refer to Clay's documentation for supported syntax and functions. This ensures that your formulas will be compatible with Clay's system. What specific JavaScript functionality were you trying to implement in your formula? This could help me provide more targeted guidance on how to achieve your goal within Clay's formula limitations.
Source: Formulas
I’ll paste in what I want the formula to do in case the AI here somehow manages to get me what I need: I have an array of objects, each of which has a start_date and end_date. I want the formula to compare the start_date of each object with the end_date of the next object in the array. If the start_date of the current object is earlier than the end_date of the next object, I want the formula to set the value of the first object’s start_date to equal the next object’s end_date. Then I want the formula to return the modified array.
To modify an array of objects in Clay by comparing dates and updating them, you'll need to use a combination of JavaScript operations and Clay's formula syntax. Here's a general approach you can try: 1. Use the "write to table" feature to create a new table with your array of objects. 2. In the new table, add a formula column to perform the date comparison and modification. 3. In the formula column, use JavaScript's array methods and Clay's date comparison operators to iterate through the objects and update the dates as needed. Keep in mind that Clay's formula syntax supports a subset of JavaScript functionality, so complex operations might require breaking down the logic into multiple steps or columns. Can you provide more details about the structure of your objects and how you've imported them into Clay? This will help me give you more specific guidance on writing the formula.
pretty complicated. tell gpt the format clay accepts and then have it write a formula for you. this works for me sometimes
To modify an array of objects in Clay by comparing dates, you can use our "write to table" feature and AI formulas. Here's a general approach: 1. Use the "write to table" feature to create a new table with your array of objects. 2. Add a formula column to perform the date comparison and modification. 3. Use an AI formula to generate the necessary code. You can prompt it with something like: "Compare start_date of each object with end_date of the next object. If start_date is earlier, set it to the next object's end_date. Return the modified array." 4. Use Clay's date comparison operators (e.g., <, > , ==) in your formula. This approach leverages Clay's features while working within its JavaScript syntax limitations.
To compare and modify dates in an array of objects in Clay, you can use a combination of JavaScript operations and Clay's formula syntax. Here's an approach: 1. Use the "write to table" feature to create a table with your array of objects. 2. Add a formula column to perform the date comparison and modification. 3. In the formula column, use an AI formula with a prompt like: "Compare start_date of each object with end_date of the next object in the array. If start_date is earlier, set it to the next object's end_date. Return the modified array. Example input: [{start_date: '2023-01-01', end_date: '2023-02-01'}, {start_date: '2023-01-15', end_date: '2023-03-01'}]" This leverages Clay's AI formula generator while working within its JavaScript syntax limitations.
Thanks so much, Muhammad S.!
.png){kind=logo}
