Issue with Formula Backdating in Table Auto Update Function

Question: Can you help me check this table, when i turn off auto update and updated my formula, then turn it back on, I noticed the formula will also be backdated to the latest formula, is this a current behavior? Or how can i prevent it. (the formula is the column "Valid Lead?"

3 comments

Channeled
APP
·
·
When you turn off auto-update, make changes to your formula, and then turn auto-update back on, Clay will run the latest version of your formula on all relevant rows, updating them to match the new logic. This is the intended behavior to ensure consistency across your table. To prevent this, consider using conditional run criteria so the formula only updates under specific conditions, or keep auto-update off if you want to avoid retroactive changes. Are you looking to update only new rows with the latest formula while keeping existing rows unchanged?
Sources: Guide: Ways to save Clay credits | Documentation | Clay University Auto-update and Auto-dedupe Table Table management settings | Documentation | Clay University
Loh Y.
·
·
Yes, but i thought turning off the auto-update features will not allow any new rows to run?
Channeled
APP
·
·
When auto-update is turned off, new rows added to your table will not automatically run formulas. This is exactly what you want to prevent backdating. To update only new rows with your latest formula while keeping existing rows unchanged: 1. Turn off auto-update for the specific column (via Run Settings) or the entire table (click the three dots next to your table name) 2. Make your formula changes 3. Manually run the formula only on new rows when needed For more selective control, use conditional run criteria in your formula's Run Settings to specify exactly which rows should update.
Sources: Apify integration | Documentation | Clay University Mistral integration overview | Documentation | Clay University Guide: Ways to save Clay credits | Documentation | Clay University Auto-update and Auto-dedupe Table Table management settings | Documentation | Clay University

Issue with Formula Backdating in Table Auto Update Function | Clay