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.
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: