Help

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

Formula to fetch information from a URL

Topic Labels: Formulas
284 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Reply 1

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.