Formula to fetch information from a URL

Ask the community Formulas
#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?

#2

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.

#3

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.