Skip to main content
Question

Combining two fields into hyperlinked text using a formula


swilder
Forum|alt.badge.img+5

Hi - I have two fields, both text:

  1. Form Title (same for every record)
  2. Form URL (long-#$@$, customized URLs for prefilled forms; different for every record)

Is there a way to make the title of the form clickable with the URL - possibly by creating a third formula field? Chat GPT tells me to do: HYPERLINK({Form URL}, {Form Title}). Alas, HYPERLINK doesn’t seem to be an actual function. Does anyone know? Thank  you!​​​​

This topic has been closed for replies.

3 replies

TheTimeSavingCo
Forum|alt.badge.img+32

Hm, depends on how we’re planning on using it I think?  If this is within Airtable, we could use a button field for this, which would let us click and open the prefilled link:

If this is for an email automation or something, then we could add the prefilled form link into the email via the <a> tags:

 


anmolgupta
Forum|alt.badge.img+7

As ​@TheTimeSavingCo recommended, the button approach seems the right approach for this case.


BillH
Forum|alt.badge.img+24
  • Brainy
  • June 17, 2026

​@william111ttt23 

there is no HYPERLINK formula