Help with script to combine URL and text

Hi,

Using the following script from this post, I created a field that combines a URL and text:

let tb = base.getTable(“URL Test”);
let query = await tb.selectRecordsAsync();
for (let record of query.records) {
let url = record.getCellValue(“URL”);
let name = record.name;
let text = record.getCellValue(“Text”);
if(url) {
tb.updateRecordAsync(record, {“Rich”: [${text}](${url}) - ${name}})
}
}

I have two questions:
1: Can I make this script complete this task in multiple columns? (for example - perform the script for column “Rich” and then have “Rich2” to repeat the script, but using a different URL column.)
2: This doesn’t work if my URL is coming from a lookup - even if the lookup is a URL. Is there a way to get this to work from a lookup field?

Thanks!
Jeffrey