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
Mar 17, 2022 06:12 AM
Hello! We use this formula:
=REGEXEXTRACT(IMPORTXML(A1,"/html/head/meta[@property=‘article:modified_time’]/@content"),"^(.+?)T")
on Google Sheets to fetch publish date information from a URL (A1, in the formula). We would like to do something similar on AT but I can’t for the life of me figure out how AT would write this out as a formula.
Any tips?
Mar 17, 2022 02:07 PM
Airtable formulas cannot fetch information from a url. They can only do computations based on values in other fields in the same record (or in a linked record).
You may be able to use scripting to fetch data from a url.