Skip to main content

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!


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}&""

)

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}&""

)

You’re the best, thanks so much

Reply


Terms & Conditions