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
Apr 28, 2020 05:00 AM
Hi guys,
Actually I want to use this tool - https://statically.io/favicons/ which automatically grabs and display favicon of a any website if I write the URL in the format -
https://cdn.statically.io/favicons/domain.com
For example -
https://cdn.statically.io/favicons/google.com
Now, I already have a formula column which has multiple domain URL as the row cell value. Now, I want to create a new column with the following cell structure as shown above.
but here the domain .com should be replaced the domain URL written in that column. Now , what formula should I use to create a URL like this for different values of domain .com
Any help will be appreciated.
Thank you.
Apr 28, 2020 06:28 AM
Hey, I think you can do this using SUBSTITUTE()
SUBSTITUTE(string, old_text, new_text, [index])
So
SUBSTITUTE({URL}, "domain", {newdomain})