Skip to main content
Question

Combining two fields into hyperlinked text using a formula

  • May 22, 2026
  • 5 replies
  • 67 views

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!​​​​

5 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
  • Inspiring
  • May 25, 2026

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


Forum|alt.badge.img

Yes—this should work in Airtable:

 
HYPERLINK({Form URL}, {Form Title})

If it’s not working, it’s usually just a field name mismatch or the URL not being a proper URL/text field. Test with a hardcoded link to confirm.


Forum|alt.badge.img

nice


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

@william111ttt23 

there is no HYPERLINK formula