Do Automatic Columns Run on Hidden Rows with Filters Applied?

👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!

Hello Joessa, good question! If you have a filter set, enrichment will not run for rows that are not in the view (do not match the filters). However, if you have your table on auto-update columns and clear the filter, all the rows that did not run previously will be triggered. Because of this, we recommend using your filter as conditional formula in enrichments. https://downloads.intercomcdn.com/i/o/w28k1kwz/1225312687/907f64e5445c142191528f42f934/CleanShot+2024-10-22+at+17_31_58.gif?expires=1729634400&signature=37a83dcd16b5c3a72bfd6d53c2aabf7736740b47fc7bcaa2a115a65f9cbb0ee2&req=dSIlE8p%2Fn4dXXvMW1HO4zXyHc7rfoPEvd1b%2F6X6LvzSedthFf2VJ%2FAabXxK9%0AYjiW%0A

Got it Tomi thanks! We can't use conditional formula since we're doing a Clay table people search according to another person in your team. We're using filters as a workaround

Hey, thanks for reaching out - Yep you're right, sorry for that :)

Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.

Hi there. I'm reopening this thread. Can you pls confirm that Auto-update columns won't run on hidden rows?

For context I have a filter set on a live table and we're running an AI column. Only YES results should be carried over to the next table.

However, I'm getting values in the next table that are not in this view

Hey there Joessa thanks for reaching out, jumping in here, to clarify here Auto-update columns will still run even if there hidden. The only way to prevent columns from running would be to have the "auto-update" option toggled off either in the table or for the column. https://downloads.intercomcdn.com/i/o/w28k1kwz/1245116757/f05451fb53238f4a885948a78acc/image.png?expires=1731097800&signature=a2ede8300a124a8473bcf1f397098b8ff245614b705fcc8a3600c9694a7ff2f3&req=dSIjE8h%2Fm4ZaXvMW1HO4zetTKLT7BkoMIJqVpK5h3%2FYivDzt0Mwlo%2FP1Z9Bd%0A5nA%2F%0A The only time a column will not run, is if a row is filtered out of the current view, however hidden columns will continue to run

Hi Luis! Thanks for responding. I recorded a quick video for more context. https://www.loom.com/share/7f888046c39d42f98ec155c5e39ba1c5?sid=8332ad1c-e01c-4e09-a896-0cf40fc20cd0

Thank you for sharing this, Joessa, in this scenario as previously mentioned if a row is not visible in the view i.e. the row is hidden, then columns will not run for these rows. So, for those 7,282 rows in your view, columns will only run for these rows, the 14,000~ rows will not run, as the way that columns in Clay are setup is that they will only run for the rows that are visible in the view. As for the reason Huntington National Bank is appearing, this is due to the fact that the lead in row 692 has Huntington listed as a job experience in the formatted resume column. https://downloads.intercomcdn.com/i/o/w28k1kwz/1245247155/ddf7c8da4422b1324415f943fef3/image.png?expires=1731108600&signature=648f342b5d5b188daba37083b4533201b7d3c27b64459ffa40f16636a21a3923&req=dSIjE8t6moBaXPMW1HO4zR%2FoeuDQbTgfcsglH6muiyXTVorAEGGp3%2BZoT3Tr%0A0QNU%0A

Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.