Creating Columns to Function with One Variable Input

Use an OR condition in your column's Run Settings. Navigate to Run Settings → "Only run if" and create a formula like {{variable1}} is not empty OR {{variable2}} is not empty. [1]

You can also use the "Use AI" button to input plain language like "Only run if variable1 OR variable2 has data" and Clay will generate the formula automatically. [2] This ensures the column runs when at least one variable contains data. [3]

Was that helpful?

It still says that some inputs are missing.

Check if you have Required to Run toggles enabled in your enrichment settings. In the Prompt Editor, these toggles ensure enrichments only run when specific fields contain data, which can cause "missing inputs" errors. [1]

You can click into the specific cell showing the error to see more details about which inputs are missing. Also check your conditional formula - it might be too restrictive or not properly handling empty fields. [2]

Try clicking the "explain" button next to the error message for AI analysis of why the run condition wasn't met.

Was that helpful?

Can I also switch the toggle somehow off if I run this via a Claygent template?

Yes, you can disable the "Required to Run" toggle in Claygent templates. In the Prompt Editor, locate the field with the "Required to Run" toggle and simply turn it off. [1]

You can also disable auto-update at the column level by clicking the column header, going to column settings, and toggling off "Auto-Update" in run settings. [2]

Was that helpful?

The variable just appears as {{company name}} and there is no toggle.

The #{{company name}} format indicates you're in a Claygent template where variables are referenced differently than in regular enrichments. In Claygent templates, you don't see the "Required to Run" toggle next to variables. [1]

To add the column reference properly, type "/" and select the column from the dropdown menu instead of manually typing the variable name. [2] This ensures the variable is correctly linked to your table data. [3]

If you need to make the field optional, you'll need to handle this through conditional logic in your prompt rather than using the toggle.

Is that what you were looking for?

How can I use the conditional logic in my prompt?

In your Claygent prompt, use IF/ELSE statements to handle missing variables:

For missing fields, add error handling like IF({{company_name}} == "") THEN "No company data available" ELSE "Company: {{company_name}}". [1]

Use logical operators: {{variable1}} OR {{variable2}} to check if at least one variable has data. [2] This prevents the "missing inputs" error by providing fallback logic when variables are empty. [3]

Was that helpful?

No! It is still not working.