Please Add Hyperlink Formula

[George_Conlow]

Google Sheets has a formula called Hyperlink.
HYPERLINK(url, [link_label])
Example
HYPERLINK(“http://www.google.com/”, “Google”)
Where url is The full URL of the link location enclosed in quotation marks, or a reference to a cell containing such a URL.

and link_label - [optional] is the text to display in the cell as the link, enclosed in quotation marks, or a reference to a cell containing such a label.

It would be helpful if airtable could do this too.
My use case: Zapier finds new google docs in a special folder and adds records to an airtable which includes TITLE and URL. I have a view of that table that is embedded on my internal google site so that all new content in that folder (medical protocols) are available to my staff. It would be quite nice to have one field (a clickable link) rather than two - the title and an ugly url.

Please like this post to help it raise to the top!

[Kamille_Parks]

Fields in Airtable operate very, very differently than cells in Sheets do. Adding hyperlink support beyond Formula fields and Short/Long Text fields would be nice, but I don’t think literally every field should have a hyperlink function; that would literally break the functionality of Link to Another Record, Lookups, Checkboxes, etc.

[Neil_Webb]

I have a lot of spreadsheets that I’d love to import into Airtable, but they contain hyperlinks.

When I convert these spreadsheets to .csv (so that I can import them into Airtable), the hyperlinks get flattened - the text is retained but I lose all the URL data.

It would be great if Airtable could handle this in some way so that the hyperlink data is retained, even if it split it out nto two cells (note: I could possibly copy and paste this data straight into Google Sheets, and go from there, retaining the hyperlinks … just need Airtable to be able to handle them!)

[Kamille_Parks]

@Neil_Webb Airtable would need to add support for Excel files for that to work. When Excel exports a file as .CSV, it loses all formatting info including the original link for any program trying to open it. CSV files are a “what you see is what you get” file type, so to speak, in that regard.

I am in favor of adding support for importing from Excel files (.xls) directly, which may solve maintaining hyperlink data.

[Joanne_O_Donnel]

I’ve only been using airtable for a few hours and already found 2 thinks I think are essential that can’t be done… this and wrapping column headers… I may not go further with the product…

[Cole_Ryan]

I’d love to see this one get implemented—many of my grids need to be exported and reformatted for this reason.

[Masha_Bykin]

I am shocked there isn’t basic hyperlink functionality. It shouldn’t have to be a formula/function. This is basic stuff for text editing. Should also be able to use a shortcut to hyperlink Airtable content with square brackets or some other symbols.

[Tim_Cai]

I saw this in the Airtable Updates. Looks like the feature has already been built?

[Kamille_Parks]

As mentioned above, it has been done using the Rich Text field type. The thread is still open for requests relating to adding an actual HYPERLINK() formula and/or adjusting the functionality of the existing URL field type.

[Stephen_Suen]

Update (June 25, 2020): The button field is now available for all users — read more in our launch blog post: https://blog.airtable.com/now-available-button-field

---

:wave: Hey all! I’m thrilled to announce that we’re launching the beta for button field, a new field type that allows you to create buttons that trigger customizable actions. Our first action is open URL, which lets you open links based on a URL formula. You can use this to do things like:

• Send emails
• Open Airtable forms with prefilled records
• Create Google Calendar invites
• Open JIRA tickets
• Post tweets
• And much more!

In addition, you can customize the label and style of the buttons.

[JonathanBowen]

Great news! Simple, but powerful.