Help

Re: when copy formula values "HTML code"

1017 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Karek_Rami
5 - Automation Enthusiast
5 - Automation Enthusiast

I've HTML Code to use inside formula to insert virables inside the HTML code then export it as final HTML Code.. the problem is when i tried to copy the field it add some extra character (")...

Here's the formula code:

"<div style='position: fixed; top: 0; left: 0; width: 50%; height: 100%; opacity: 0.6; z-index: -1; background-image: url(\"https://image-cdn-p.azureedge.net/offer-image/ARABGG/202304022245344534.png\"); background-repeat: no-repeat; background-position:left;background-size:100% 100%;'></div>" &
"<div style='position: fixed; top: 0; right: 0; width: 50%; height: 100%; opacity: 0.6; z-index:-1;background-image:url(\"https://image-cdn-p.azureedge.net/offer-image/ARABGG/20230402224407447.png\");background-repeat:no-repeat;background-position:right;background-size:100%100%;'></div>" &
"<div style='padding :5px;background :rgba(255,255,255,0.1);border-radius :5px;\\r\nbackdrop-filter :blur(5px);box-shadow :0 2px3px rgba(0,0,0,0.1);'>" &
"<p><img alt=\"202111061758495849.png\" src=\"https://image-cdn-p.azureedge.net/offer-image/ARABGG/202111061758495849.png\" data-src=\"202111061758495849.png\" /></p>" &
"<p style='text-align:center;'>Hello PlayerAuctions community,</p>" & 
"<table border='1' cellpadding='1' cellspacing='1' style='width:500px;margin-left:auto;margin-right:auto;'> " &
   "<tbody>" &
      "<tr>" &
         "<td style='text-align:center;'>" &
            "<span style='font-family:\"arial black\",sans-serif;'>&nbsp;<strong>️ Dragon Ball Legends Account GEMs (Crystals)</strong></span>" &
         "</td>" &
      "</tr>" &
      "<tr>" &
         "<td style='text-align:center;'>" &
            "<strong><span style='color:#f1c40f;'><span style='background-color:#3598db;color:#ffffff;'>&nbsp;"&{Gem Value}&"&nbsp;</span> <br /><em>(This Gems Without Playing The PVP📊 \"🟢PVP FRESH👈\")</em></span></strong>" &
         "</td>" &
      "</tr>" &
      "<tr>" &
         "<td style='text-align:center;'> " & 
            "&nbsp;<span style='font-family:\"arial black\",sans-serif;'><strong>️ Is there any Unique Items in this DBL account ?<br /></strong></span></td> " & 
      "</tr>" & 
      "<tr> " & 
         "<td style='text-align:center;'> " & 
            "<strong><span style='color:#f1c40f;'><span style='background-color:#3598db;color:#ffffff;'>&nbsp;"&{Items Value}&"&nbsp;</span> <br /><em>(For Now we've stopped spending gems on getting items you can use your "&{Gem Value}&" 💎 to get items you want)</em></span></strong> " & 
         "</td> " & 
      "</tr> " & 
      "<tr> " & 
         "<td style=\"text-align: center;\">&nbsp;<span style=\"font-family: 'arial black', sans-serif;\"><strong>️ Is there any Unique Characters in this DBL account ?</strong></span></td> " & 
      "</tr> " & 
      "<tr> " & 
         "<td style=\"text-align: center;\">&nbsp;&nbsp;<strong><span style=\"color: #f1c40f;\"><span style=\"background-color: #3598db; color: #ffffff;\">🌟 "&{Chars Value}&" 🌟</span></span></strong></td> " & 
      "</tr> " & 
   "</tbody>" & 
"</table>" &
"<p style='text-align:center;'>&nbsp;</p>" &
"<p><img alt=\"202111061756255625.png\" src=\"https://image-cdn-p.azureedge.net/offer-image/ARABGG/202111061756255625.png\" style='display:block;margin-left:auto;margin-right:auto;' data-src='202111061756255625.png' /></p>" &
"<p style='text-align:center;'>"&{SCR}&"</p>" &
"<p><img alt=\"202111061757355735.png\" src=\"https://image-cdn-p.azureedge.net/offer-image/ARABGG/202111061757355735.png\" style='display:block;margin-left:auto;margin-right:auto;' data-src='202111061757355735.png' /></p>" &
"<p style='text-align:center;'><span style='color:#ffffff;'><strong><span style='font-size:14pt;'>THIS ACCOUNT MADE FOR <span style='background-color:#3598db;'>"&{Platform}&"</span> DEVICES<br /><em>To use it in any other platform Devices you should spend the crystals through "&{Platform}&" device then login in other platforms. BE-Aware if you purchased this account and login with other than "&{Platform}&" device you will lost your <span style='background-color:#3598db;'>"&{Gem Value}&"</span> Crystals.</em></span></strong></span></p>" &
"<p><img alt=\"202112301632293229.png\" src=\"https://image-cdn-p.azureedge.net/offer-image/ARABGG/202112301632293229.png\" style='display:block;margin-left:auto;margin-right:auto;' data-src='202112301632293229.png' /></p>" & 
"<p style='text-align:center;'><span style='font-family:\"arial black\",sans-serif;background-color:#ffffff;color:#3598db;'><strong><span style='font-size:24pt;background-color:#ffffff;'>💰 💲"&{P-Price}&"💲 💰</span></strong></span></p>" & 
"<p style='text-align:center;'><span style='font-family:\"comic sans ms\",sans-serif;color:#ffffff;font-size:14pt;'><strong>Click <a href=\"https://www.playerauctions.com/store/arabgg/\" rel=\"noopener\" style=\"color: #3366ff;text-decoration:none;font-weight:bold;font-size:16px;background-color:#f0f0f0;padding:8px 12px;border-radius:4px;\" target=\"_blank\">Here</a> if you're looking for lower price</strong></span></p>" &
"<p style='text-align:center;'><img alt=\"20211231210642642.png\" src=\"https://image-cdn-p.azureedge.net/offer-image/ARABGG/20211231210642642.png\" data-src='20211231210642642.png' /></p>" &
"<p style='text-align:center;font-weight:400;font-style:normal;color:#ffffff;text-decoration:none;'><strong>Q: Why should I buy from you?</strong><br />A: Farming is a challenging and time-consuming process that requires continuous effort, research, and updates. We provide stable accounts so you can enjoy PVP and have fun without wasting time on risky endeavors. We offer a full warranty after the sale and have a solid reputation across multiple marketplaces, including Playerauctions.</p>" &
"<p style='text-align:center;font-weight:400;font-style:normal;color:#ffffff;text-decoration:none;'><strong>Q: Why do you only bind accounts with Bandai Namco?</strong><br />A: Bandai Namco is the only login method that allows you to take full ownership of the account and change the email and password without the possibility of account recovery from our side, unlike the Google/Apple ID linked methods.</p>" &
"<p style='text-align:center;font-weight:400;font-style:normal;color:#ffffff;text-decoration:none;'><strong>Q: Do you offer farming services (Power-Leveling) for my account?</strong><br />A: Yes, at A.GG we provide farming services for your existing account without needing to purchase a new one. Contact us for special pricing lower than premade accounts. (Update: This service is currently suspended due to warranty limitations.)</p>" &
"<p style='text-align:center;font-weight:400;font-style:normal;color:#ffffff;text-decoration:none;'><strong>Q: What does N/A mean?</strong><br />A: N/A stands for \"not available.\" It means that the account doesn't have any special or unique items or characters to mention in the thread.</p>" &
"</div>"

Here's the corrupted results when click CTRL+C to copy the field:

"<div style='position: fixed; top: 0; left: 0; width: 50%; height: 100%; opacity: 0.6; z-index: -1; background-image: url(""https://image-cdn-p.azureedge.net/offer-image/ARABGG/202304022245344534.png""); background-repeat: no-repeat; background-position:left;background-size:100% 100%;'></div><div style='position: fixed; top: 0; right: 0; width: 50%; height: 100%; opacity: 0.6; z-index:-1;background-image:url(""https://image-cdn-p.azureedge.net/offer-image/ARABGG/20230402224407447.png"");background-repeat:no-repeat;background-position:right;background-size:100%100%;'></div><div style='padding :5px;background :rgba(255,255,255,0.1);border-radius :5px;\r
backdrop-filter :blur(5px);box-shadow :0 2px3px rgba(0,0,0,0.1);'><p><img alt=""202111061758495849.png"" src=""https://image-cdn-p.azureedge.net/offer-image/ARABGG/202111061758495849.png"" data-src=""202111061758495849.png"" /></p><p style='text-align:center;'>Hello PlayerAuctions community,</p><table border='1' cellpadding='1' cellspacing='1' style='width:500px;margin-left:auto;margin-right:auto;'> <tbody><tr><td style='text-align:center;'><span style='font-family:""arial black"",sans-serif;'>&nbsp;<strong>️ Dragon Ball Legends Account GEMs (Crystals)</strong></span></td></tr><tr><td style='text-align:center;'><strong><span style='color:#f1c40f;'><span style='background-color:#3598db;color:#ffffff;'>&nbsp;60383&nbsp;</span> <br /><em>(This Gems Without Playing The PVP📊 ""🟢PVP FRESH👈"")</em></span></strong></td></tr><tr><td style='text-align:center;'> &nbsp;<span style='font-family:""arial black"",sans-serif;'><strong>️ Is there any Unique Items in this DBL account ?<br /></strong></span></td> </tr><tr> <td style='text-align:center;'> <strong><span style='color:#f1c40f;'><span style='background-color:#3598db;color:#ffffff;'>&nbsp;""MEDAL RUSH = 50 , RUSH BLUE = 131K+""&nbsp;</span> <br /><em>(For Now we've stopped spending gems on getting items you can use your 60383 💎 to get items you want)</em></span></strong> </td> </tr> <tr> <td style=""text-align: center;"">&nbsp;<span style=""font-family: 'arial black', sans-serif;""><strong>️ Is there any Unique Characters in this DBL account ?</strong></span></td> </tr> <tr> <td style=""text-align: center;"">&nbsp;&nbsp;<strong><span style=""color: #f1c40f;""><span style=""background-color: #3598db; color: #ffffff;"">🌟 3 LF 🌟</span></span></strong></td> </tr> </tbody></table><p style='text-align:center;'>&nbsp;</p><p><img alt=""202111061756255625.png"" src=""https://image-cdn-p.azureedge.net/offer-image/ARABGG/202111061756255625.png"" style='display:block;margin-left:auto;margin-right:auto;' data-src='202111061756255625.png' /></p><p style='text-align:center;'>https://i.imgur.com/BsCU1Fa.jpg</p><p><img alt=""202111061757355735.png"" src=""https://image-cdn-p.azureedge.net/offer-image/ARABGG/202111061757355735.png"" style='display:block;margin-left:auto;margin-right:auto;' data-src='202111061757355735.png' /></p><p style='text-align:center;'><span style='color:#ffffff;'><strong><span style='font-size:14pt;'>THIS ACCOUNT MADE FOR <span style='background-color:#3598db;'>ANDROID</span> DEVICES<br /><em>To use it in any other platform Devices you should spend the crystals through ANDROID device then login in other platforms. BE-Aware if you purchased this account and login with other than ANDROID device you will lost your <span style='background-color:#3598db;'>60383</span> Crystals.</em></span></strong></span></p><p><img alt=""202112301632293229.png"" src=""https://image-cdn-p.azureedge.net/offer-image/ARABGG/202112301632293229.png"" style='display:block;margin-left:auto;margin-right:auto;' data-src='202112301632293229.png' /></p><p style='text-align:center;'><span style='font-family:""arial black"",sans-serif;background-color:#ffffff;color:#3598db;'><strong><span style='font-size:24pt;background-color:#ffffff;'>💰 💲33.064499999999995💲 💰</span></strong></span></p><p style='text-align:center;'><span style='font-family:""comic sans ms"",sans-serif;color:#ffffff;font-size:14pt;'><strong>Click <a href=""https://www.playerauctions.com/store/arabgg/"" rel=""noopener"" style=""color: #3366ff;text-decoration:none;font-weight:bold;font-size:16px;background-color:#f0f0f0;padding:8px 12px;border-radius:4px;"" target=""_blank"">Here</a> if you're looking for lower price</strong></span></p><p style='text-align:center;'><img alt=""20211231210642642.png"" src=""https://image-cdn-p.azureedge.net/offer-image/ARABGG/20211231210642642.png"" data-src='20211231210642642.png' /></p><p style='text-align:center;font-weight:400;font-style:normal;color:#ffffff;text-decoration:none;'><strong>Q: Why should I buy from you?</strong><br />A: Farming is a challenging and time-consuming process that requires continuous effort, research, and updates. We provide stable accounts so you can enjoy PVP and have fun without wasting time on risky endeavors. We offer a full warranty after the sale and have a solid reputation across multiple marketplaces, including Playerauctions.</p><p style='text-align:center;font-weight:400;font-style:normal;color:#ffffff;text-decoration:none;'><strong>Q: Why do you only bind accounts with Bandai Namco?</strong><br />A: Bandai Namco is the only login method that allows you to take full ownership of the account and change the email and password without the possibility of account recovery from our side, unlike the Google/Apple ID linked methods.</p><p style='text-align:center;font-weight:400;font-style:normal;color:#ffffff;text-decoration:none;'><strong>Q: Do you offer farming services (Power-Leveling) for my account?</strong><br />A: Yes, at A.GG we provide farming services for your existing account without needing to purchase a new one. Contact us for special pricing lower than premade accounts. (Update: This service is currently suspended due to warranty limitations.)</p><p style='text-align:center;font-weight:400;font-style:normal;color:#ffffff;text-decoration:none;'><strong>Q: What does N/A mean?</strong><br />A: N/A stands for ""not available."" It means that the account doesn't have any special or unique items or characters to mention in the thread.</p></div>"

Here's the correct results when click to "open full size" then select all then copy:

<div style='position: fixed; top: 0; left: 0; width: 50%; height: 100%; opacity: 0.6; z-index: -1; background-image: url("https://image-cdn-p.azureedge.net/offer-image/ARABGG/202304022245344534.png"); background-repeat: no-repeat; background-position:left;background-size:100% 100%;'></div><div style='position: fixed; top: 0; right: 0; width: 50%; height: 100%; opacity: 0.6; z-index:-1;background-image:url("https://image-cdn-p.azureedge.net/offer-image/ARABGG/20230402224407447.png");background-repeat:no-repeat;background-position:right;background-size:100%100%;'></div><div style='padding :5px;background :rgba(255,255,255,0.1);border-radius :5px;\r
backdrop-filter :blur(5px);box-shadow :0 2px3px rgba(0,0,0,0.1);'><p><img alt="202111061758495849.png" src="https://image-cdn-p.azureedge.net/offer-image/ARABGG/202111061758495849.png" data-src="202111061758495849.png" /></p><p style='text-align:center;'>Hello PlayerAuctions community,</p><table border='1' cellpadding='1' cellspacing='1' style='width:500px;margin-left:auto;margin-right:auto;'> <tbody><tr><td style='text-align:center;'><span style='font-family:"arial black",sans-serif;'>&nbsp;<strong>️ Dragon Ball Legends Account GEMs (Crystals)</strong></span></td></tr><tr><td style='text-align:center;'><strong><span style='color:#f1c40f;'><span style='background-color:#3598db;color:#ffffff;'>&nbsp;60383&nbsp;</span> <br /><em>(This Gems Without Playing The PVP📊 "🟢PVP FRESH👈")</em></span></strong></td></tr><tr><td style='text-align:center;'> &nbsp;<span style='font-family:"arial black",sans-serif;'><strong>️ Is there any Unique Items in this DBL account ?<br /></strong></span></td> </tr><tr> <td style='text-align:center;'> <strong><span style='color:#f1c40f;'><span style='background-color:#3598db;color:#ffffff;'>&nbsp;"MEDAL RUSH = 50 , RUSH BLUE = 131K+"&nbsp;</span> <br /><em>(For Now we've stopped spending gems on getting items you can use your 60383 💎 to get items you want)</em></span></strong> </td> </tr> <tr> <td style="text-align: center;">&nbsp;<span style="font-family: 'arial black', sans-serif;"><strong>️ Is there any Unique Characters in this DBL account ?</strong></span></td> </tr> <tr> <td style="text-align: center;">&nbsp;&nbsp;<strong><span style="color: #f1c40f;"><span style="background-color: #3598db; color: #ffffff;">🌟 3 LF 🌟</span></span></strong></td> </tr> </tbody></table><p style='text-align:center;'>&nbsp;</p><p><img alt="202111061756255625.png" src="https://image-cdn-p.azureedge.net/offer-image/ARABGG/202111061756255625.png" style='display:block;margin-left:auto;margin-right:auto;' data-src='202111061756255625.png' /></p><p style='text-align:center;'>https://i.imgur.com/BsCU1Fa.jpg</p><p><img alt="202111061757355735.png" src="https://image-cdn-p.azureedge.net/offer-image/ARABGG/202111061757355735.png" style='display:block;margin-left:auto;margin-right:auto;' data-src='202111061757355735.png' /></p><p style='text-align:center;'><span style='color:#ffffff;'><strong><span style='font-size:14pt;'>THIS ACCOUNT MADE FOR <span style='background-color:#3598db;'>ANDROID</span> DEVICES<br /><em>To use it in any other platform Devices you should spend the crystals through ANDROID device then login in other platforms. BE-Aware if you purchased this account and login with other than ANDROID device you will lost your <span style='background-color:#3598db;'>60383</span> Crystals.</em></span></strong></span></p><p><img alt="202112301632293229.png" src="https://image-cdn-p.azureedge.net/offer-image/ARABGG/202112301632293229.png" style='display:block;margin-left:auto;margin-right:auto;' data-src='202112301632293229.png' /></p><p style='text-align:center;'><span style='font-family:"arial black",sans-serif;background-color:#ffffff;color:#3598db;'><strong><span style='font-size:24pt;background-color:#ffffff;'>💰 💲33.064499999999995💲 💰</span></strong></span></p><p style='text-align:center;'><span style='font-family:"comic sans ms",sans-serif;color:#ffffff;font-size:14pt;'><strong>Click <a href="https://www.playerauctions.com/store/arabgg/" rel="noopener" style="color: #3366ff;text-decoration:none;font-weight:bold;font-size:16px;background-color:#f0f0f0;padding:8px 12px;border-radius:4px;" target="_blank">Here</a> if you're looking for lower price</strong></span></p><p style='text-align:center;'><img alt="20211231210642642.png" src="https://image-cdn-p.azureedge.net/offer-image/ARABGG/20211231210642642.png" data-src='20211231210642642.png' /></p><p style='text-align:center;font-weight:400;font-style:normal;color:#ffffff;text-decoration:none;'><strong>Q: Why should I buy from you?</strong><br />A: Farming is a challenging and time-consuming process that requires continuous effort, research, and updates. We provide stable accounts so you can enjoy PVP and have fun without wasting time on risky endeavors. We offer a full warranty after the sale and have a solid reputation across multiple marketplaces, including Playerauctions.</p><p style='text-align:center;font-weight:400;font-style:normal;color:#ffffff;text-decoration:none;'><strong>Q: Why do you only bind accounts with Bandai Namco?</strong><br />A: Bandai Namco is the only login method that allows you to take full ownership of the account and change the email and password without the possibility of account recovery from our side, unlike the Google/Apple ID linked methods.</p><p style='text-align:center;font-weight:400;font-style:normal;color:#ffffff;text-decoration:none;'><strong>Q: Do you offer farming services (Power-Leveling) for my account?</strong><br />A: Yes, at A.GG we provide farming services for your existing account without needing to purchase a new one. Contact us for special pricing lower than premade accounts. (Update: This service is currently suspended due to warranty limitations.)</p><p style='text-align:center;font-weight:400;font-style:normal;color:#ffffff;text-decoration:none;'><strong>Q: What does N/A mean?</strong><br />A: N/A stands for "not available." It means that the account doesn't have any special or unique items or characters to mention in the thread.</p></div>

 

1 Reply 1
Alicemartine3
4 - Data Explorer
4 - Data Explorer

When copying the HTML code from your formula field, it seems that the quotation marks around the URLs for the background images are being changed to double quotation marks ("") instead of single quotation marks (''). This can cause issues with the HTML code and result in a corrupted output. To resolve this issue, you can modify the HTML code in your formula by using single quotation marks ('') for the attribute values instead of double quotation marks (""). Here's the corrected formula with single quotation marks. mcdvoice

 

"<div style='position: fixed; top: 0; left: 0; width: 50%; height: 100%; opacity: 0.6; z-index: -1; background-image: url('https://image-cdn-p.azureedge.net/offer-image/ARABGG/202304022245344534.png'); background-repeat: no-repeat; background-position: left; background-size: 100% 100%;'></div>" &
"<div style='position: fixed; top: 0; right: 0; width: 50%; height: 100%; opacity: 0.6; z-index: -1; background-image: url('https://image-cdn-p.azureedge.net/offer-image/ARABGG/20230402224407447.png'); background-repeat: no-repeat; background-position: right; background-size: 100% 100%;'></div>" &
"<div style='padding: 5px; background: rgba(255, 255, 255, 0.1); border-radius: 5px; backdrop-filter: blur(5px); box-shadow: 0 2px 3px rgba(0, 0, 0, 0.1);'>" &
"<p><img alt='202111061758495849.png' src='https://image-cdn-p.azureedge.net/offer-image/ARABGG/202111061758495849.png' data-src='202111061758495849.png' /></p>" &
"<p style='text-align: center;'>Hello PlayerAuctions community,</p>" &
"<table border='1' cellpadding='1' cellspacing='1' style='width: 500px; margin-left: auto; margin-right: auto;'>" &
   "<tbody>" &
      "<tr>" &
         "<td style='text-align: center;'>" &
            "<span style='font-family: \"arial black\", sans-serif;'>&nbsp;<strong>️ Dragon Ball Legends Account GEMs (Crystals)</strong></span>" &
         "</td>" &
      "</tr>" &
      "<tr>" &
         "<td style='text-align: center;'>" &
            "<strong><span style='color: #f1c40f;'><span style='background-color: #3598db; color: #ffffff;'>&nbsp;" & {Gem Value} & "&nbsp;</span> <br /><em>(This Gems Without Playing The PVP \"🟢PVP FRESH\")</em></span></strong>" &
         "</td>" &
      "</tr>" &
      "<tr>" &
         "<td style='text-align: center;'>" &
            "&nbsp;<span style='font-family: \"arial black\", sans-serif;'><strong>️ Is there any Unique Items in this DBL account ?<br /></strong></span></td> " &
      "</tr>" &
      "<tr>" &
         "<td style='text-align: center;'>" &
            "<strong><span style='color: #f1c40f;'><span style='background-color: #3598db; color: #ffffff;'>&nbsp;" & {Items Value} & "&nbsp;</span>