Sep 23, 2022 08:42 AM
Hi there!
I’m looking to replace text a field with a figure from another field.
I can get this to work if I reference the code via another field but I can’t figure out how to insert it via a formula (so that I don’t have to fill a field with this dummy data every time).
Not too familiar with markdown/the symbology etc sorry!
Solved! Go to Solution.
Sep 23, 2022 08:48 AM
Your text includes double quotes, so your formula breaks when it gets to plotWidget
because its’ wrapped in double quotes and is interpreting the first quote as the end of the first argument in your Substitute function.
Try using single quotes to enclose your HTML.
SUBSTITUTE(
'<span id="plopWidget"></span>...',
"XXX",
{product_id}&""
)
Sep 23, 2022 08:48 AM
Your text includes double quotes, so your formula breaks when it gets to plotWidget
because its’ wrapped in double quotes and is interpreting the first quote as the end of the first argument in your Substitute function.
Try using single quotes to enclose your HTML.
SUBSTITUTE(
'<span id="plopWidget"></span>...',
"XXX",
{product_id}&""
)
Sep 23, 2022 08:51 AM
You’re the best, thanks so much