Forum Discussion

EEV-GMF's avatar
EEV-GMF
Qrew Trainee
2 months ago

HTML email tags appearing when copying and pasting from new style grid report

Hi,

We have a new-style grid report where users are trying to copy the contents of a field that has email addresses.

While the email address appears normally on the report, when you copy it and paste it anywhere else (another field, into a Word doc, an Excel file, an email...anywhere) it pastes with the <a href="mailto: ..."> prefix tag and the closing </a> tag.

We've attempted to strip out the html by creating a few other fields using the RegexReplace function (probably incorrectly), the SearchAndReplace function, and even just ToText function, but we're still unable to get the html cut away.

We are able to copy and paste from a record just fine, but opening each record to copy and paste seems a bit backwards, when it's easier to export the report to csv and copy from there.

I'm thinking this may be an issue in the new-style grid report only, but I could be wrong.

Has anyone else run across this issue in the past and figured out a way around it?

New Grid Report

3 Replies

  • MarkShnier's avatar
    MarkShnier
    Qrew Cadet
    2 months ago

    You should definitely report this as a bug. I'm sure they will react to it as they are all in about the new V3 grid reports. In fact, my understanding is for a new clients, they are not even given the option for them to use the previous V2 new report and the previous previous legacy table reports at all.  

    Meanwhile, if you have a particular report that is giving you this grief, you can build a URL to the report by just suffixing the URL with &usev2=1

    That will force the report be be able to be the "old" New Style report with a regular grid edit icon.  Or maybe your report has that green slider to temporarily revert o the previous report style.

    • EEV-GMF's avatar
      EEV-GMF
      Qrew Trainee
      2 months ago

      Definitely going to raise this as a bug, thanks for the second set of eyes.

      I did try the suffix and the slider and those both take me to the classic style report, but you can't copy a column, when you try to select, it wants to grab the entire line.

      I am able to copy an individual email if I right-click on the input or highlight the address and ctrl+c while in old style though, so that may be a temporary solution for users depending on the volume of records they're looking for.

      Thank you so much!

      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        2 months ago

        Me again under my correct userid.  You should definitely be able to highlight a whole range or a whole column and then right click to copy and then paste into a new column. That ability has been there for decades.