Formula for Open URL button the executes google news search

[Madeline_O_Conn]

Hi all,

Looking for a way to have a URL button open a Google News search with the terms in the first column. I tried this: (https://www.google.com/search?q={Tax Change}) (tax change is the name of the first column), but it’s telling me I still have an error.

Help Airtable friends!

[Kamille_Parks]

Your formula would have to be something closer to this:

"https://www.google.com/search?q=" & {Tax Change}

or

"https://www.google.com/search?q=" & ENCODE_URL_COMPONENT({Tax Change})

[Madeline_O_Conn]

Kamille_Parks:

"https://www.google.com/search?q=" & {Tax Change}

Thanks so much this was super helpful! This works to open a main google search, but I’m aiming specifically at google news… any thoughts on how to do that?

[Kamille_Parks]

If you actually search something in google news and look at the address bar you’ll see the prefix you need to use:

"https://news.google.com/search?q="