Template has Image with Hyperlink that needs to be updated with user input

I have a Template that has in input field (myURL) which the user will provide when creating a new document from this template. I have an image on this Template that has a default URL in the Hyperlink and I want to update that hyperlink with the one provided (myURL)

Am I trying to accomplish the impossible? It seems simple enough BUT I haven’t been able to figure out what I need to do. Hope someone can offer a how-to.

System Info:
Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-CA (en_US); UI: en-US
Calc: CL