Revisiting Hyperlinked Text

[Thomas_Voller-B]

I think we need to revisit this: https://community.airtable.com/t/combining-text-column-url-column-to-create-text-with-hyperlink-inli...

I’m looking to automatically combine two columns (URL + Text) to get hyperlinked text. This appears to have been the answer until part of the script was deprecated. I’m finding discussion elsewhere about replacement for that command, but am not able (no expertise) to figure out how to combine everything into a script that works.

[Hannah_Wiginton]

Hey @Thomas_Voller-Berdan,

Have you tried this example from Openside and On2Air Apps Founder, Dan Fellars?

Airtable

Better (Dynamic) Links - Airtable Universe

Finally! The ability to create links the way you've always wanted to. Formatted as a normal link should be. ​ This script will generate links inside of...

[Thomas_Voller-B]

Oh … drats. I think that script has the deprecated content: table.selectRecordsAsync();

[Thomas_Voller-B]

Mimicking the deprecated selectRecordsAsync() behavior Scripting app

You’ve probably all seen the following warning by now: [image] I’m guessing the deprecated behavior might still work well into 2022, but if you want to future-proof your scripts right now and/or depend on the old behavior, here’s the cleanest, functional way of mimicking it I’ve found so far: const table = base.getTable(yourTableName), fields = table.fields.map( f => f.name), query = await table.selectRecordsAsync({fields}) This particular destructuring syntax obviously depends …

[Hannah_Wiginton]

well bummer! didn’t realize that.

[Thomas_Voller-B]

There’s another discussion where the experts are showing how to work around that deprecated command, but I can’t figure out how to merge.

[ScottWorld]

Do you need it to be a script? If not, you can just creare an automation to combine the 2 fields together into an RTF field to create the hyperlinked text.

[Thomas_Voller-B]

You know something I don’t know! I’ve only seen comments saying it isn’t possible. Any info? Thanks!

[ScottWorld]

You would need to figure out how to trigger your automation — usually via a checkbox or a single select field. Although if this information is coming in from a form, you could trigger it via form submission.

And then you would setup your automation to combine the fields together into the RTF field for you, using simple Markdown formatting:

[Text Field](URL Field)