Nico M.

Make sure you have all tables that aren’t on a dedicated schedule turned off. If you have scheduled tables in play make sure they are properly conditioned to only update new data

Clay cafe is THE community

Joe H. I’ve done this with multiple formulas pretty accurately. extract street address formula: {{address}}?.split(",")?.[0] extract city: {{address}}?.split(",")?.[1]?.trim() extract state: {{address}}?.match(/,\s*([a-z]{2})\s*\d{5}/i)?.[1]?.toUpperCase() extract zipcode: {{address}}?.match(/\b\d{5}\b/)?.[0] ai prompt is: remove everything but the zip from /address column example: 42 janis st, new orleans, la 70118 = 70118

Dan V. i would add a column using claygent connected to your OpenAI api key. Build a prompt to qualify if a person fits your ICP or not and have an output field with a binary yes/no response. DM if you want some help with this

No, you can either choose to add fields (additional output columns) or not and then after completing you’ll be prompted to save

at the bottom on the table name down arrow you can find the setting to toggle on

Re run the main columnand they should update

Yeah, the checkbox is an output from the main column.

Adam G.