Carl J.

Hey LuisArturo Thanks for getting back to me. This really applies to all kinds of tables and formulas. What I want is for the AI columns to run even if a given field is empty. This is to enable fallback logic if a given input is not available for a contact. E.g. in this table: https://app.clay.com/workspaces/515060/workbooks/wb_huy3XprwEcHB/tables/t_obbQvbtZY6zD/views/gv_Csv2VQDt8ubK I am looking at the AI qualifier column. How can I make the AI formula run, even if one of the input fields is empty?

sorry shared this by accident, please delete

how to copy rows from one table to the other? duplicating the table didn not carry over the rows

Hey! I tried adding this formula but I can't get it work, not sure if it was an AI hallucination. for this prompt, I'd like it to qualify based on the company URL and claygent visiting it. However not all leads have a company URL field, so I need it to fall back to using the company name and summary if the company URL does not run. Currently it refuses to run if "some inputs are missing" - how can I fix this? Thanks!

where do I add the formula? i tried adding it in "only run if" and it's telling me it's invalid

for step 1. what should the formula be? suggest a good formula for this

How can I make this prompt work with conditional logic where it still runs even if the company page is not avaiable? #CONTEXT# Visit the company's LinkedIn page to assess its qualifications based on specified criteria and available information. #OBJECTIVE# Determine if the company is "QUALIFIED" or "unqualified" based on its type and industry using LinkedIn data. #INSTRUCTIONS# 1. Visit the LinkedIn page at regularCompanyUrl or use companyName summary if the URL is unavailable. 2. Analyze the company's information to see if: - They provide marketing, SEO, or digital services. If yes, mark them as unqualified. - They are a government entity. If yes, mark them as unqualified. - They are related to gambling or casinos. If yes, mark them as unqualified. - They are an editorial publication or newspaper like BBC, Forbes, etc. If yes, mark them as unqualified. - They are a university or traditional education institution. If yes, mark them as unqualified. - They are a religious institution. If yes, mark them as unqualified. - They are related to porn, adult industry, or similar. If yes, mark them as unqualified. 3. If none of the above, mark the company as "QUALIFIED". #EXAMPLES# Assuming the company is not classified as any of the unqualifying types, it should be labeled "QUALIFIED".