Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Using automation to update a field with bad data

Topic Labels: Automations
272 0
Showing results for 
Search instead for 
Did you mean: 

I have a table in which users paste in the URL into a URL field, but they often paste in the wrong URL ( is the right URL, and they paste in

I currently have a formula that replaces the cruft and puts it in a new field (SUBSTITUTE({Link},"#finished","")), but I’d rather use automation to update the field in place. Can someone help me with the script I need to run?


0 Replies 0