Forum Discussion

charles983's avatar
charles983
Copper Contributor
May 17, 2023
Solved

Office scripts formulas auto updating other formulas

I am currently writing an excel script that populates a table. I am trying to add a hyperlink to one of the columns; however, when I add the hyperlink via a setValue or a setFormula function, the ver...
excel
Office Scripts
  • MichelleRanMSFT's avatar
    MichelleRanMSFT
    May 19, 2023

    charles983 Glad to hear that worked! You can specify the text to display like this:

    table.getRange().getCell(i + 1, 3).setHyperlink({ 
	address: "https://help.examplesite.com/tickets/" + jsonData[0][0][i]['ticket_id'],
	textToDisplay: "text here"
})

    Using multiple lines isn't necessary but it does help make the code more readable.

charles983's avatar
charles983
Copper Contributor
May 19, 2023
That worked! Thank you so much.
charles983's avatar
charles983
Copper Contributor
May 19, 2023
Also, I noticed there is a textToDisplay property that can be changed. What is the syntax for adding multiple properties, similar to how you added the address.
  • charles983's avatar
    charles983
    Copper Contributor
    May 19, 2023
    Thank you, that worked great
  • MichelleRanMSFT's avatar
    MichelleRanMSFT
    Icon for Microsoft rankMicrosoft
    May 19, 2023

    charles983 Glad to hear that worked! You can specify the text to display like this:

    table.getRange().getCell(i + 1, 3).setHyperlink({ 
	address: "https://help.examplesite.com/tickets/" + jsonData[0][0][i]['ticket_id'],
	textToDisplay: "text here"
})

    Using multiple lines isn't necessary but it does help make the code more readable.

Resources