Jan 24, 2022 09:47 AM
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.
Jan 24, 2022 09:59 AM
Have you tried this example from Openside and On2Air Apps Founder, Dan Fellars?
Jan 24, 2022 10:20 AM
Oh … drats. I think that script has the deprecated content: table.selectRecordsAsync();
Jan 24, 2022 10:22 AM
Jan 24, 2022 10:24 AM
well bummer! didn’t realize that.
Jan 24, 2022 10:27 AM
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.
Jan 25, 2022 05:21 AM
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.
Jan 25, 2022 06:30 AM
You know something I don’t know! I’ve only seen comments saying it isn’t possible. Any info? Thanks!
Jan 25, 2022 06:33 AM
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)