Skip to main content

Formula to fetch information from a URL

  • March 17, 2022
  • 1 reply
  • 6 views

Forum|alt.badge.img+1

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

kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6006 replies
  • March 17, 2022

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.


Reply