Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Formula to fetch information from a URL

2429 0
cancel
Showing results for 
Search instead for 
Did you mean: 
automadien
6 - Interface Innovator
6 - Interface Innovator

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.