Troubleshoot: AI Not Running Despite Meeting Conditions | Clay

https://app.clay.com/workspaces/95823/tables/t_d7Rs3MGEHvEy/views/gv_hTl6viBRMrnk In the table above the AI is not running and I cant figure out why. The running conditions are met (it also does not give me an error message at all).

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Clay Team
APP
·
·
Thanks for the message, Lanny! Taking a look
Clay Team
APP
·
·
Lanny H., it appears it's because the Scrape Website columns haven't run and it's trying to determine if the input exists or not. It appears those scrapes haven't run because there's no rating available from the google search and it returned and it shows an error in some of the rows. The following formula format should fix the error in the rating columns: {{find indeed rating}}?.search_results?.[0]?.rich_snippet?.top?.extensions ? {{find indeed rating}}?.search_results?.[0]?.rich_snippet?.top?.extensions?.[0]?.replace(/[^0-9.,]/g, '') : ""
Clay Team
APP
·
·
Let me know if you need help updating them or if you run into other issues!