I’ve been trying to get this script here to work for a while. Everything has been tested and functions as planned, only if I set the “text” variable to a fixed URL. (There are small kinks, like how it’ll reset the image each time I edit the row, but that isn’t the concern for now. I know how to iron that out later.)
For some reason I just cannot seem to retrieve a URL (no hyperlink formula) or any text for that matter, and have it be inserted with this formula. The text replace functions properly if I use a specific URL, for example, “var text = “put URL here”, but how can I have “var text” become a URL inside a cell and then inserted along with that formula? I have scoured the internet for hours and tried so many different variations on getValue, getLinkUrl, copying text, etc., as well as ways to set the value, but have had no luck.
The concept: Easily adding hyperlinked images simply by pasting a URL into a cell.
My script: : https://i.stack.imgur.com/F1xkG.png