Announcement

Collapse

Information Needed

See more
See less

cell in Registrant and Attendee Report has lots of formatting code in it

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • cell in Registrant and Attendee Report has lots of formatting code in it

    Hi! My attendee and registrant reports have a lot of code in the first cell under the "Registered Date" column. This has happened for numerous reports, for several events. (I tried to attach a sample of the report but this won't let me upload an XLS or CSV file.) The event is called "NPSA Around the World Discussion," our org ID is 00Do0000000I2hr and I've granted access.

    Here's the first bit of the code as a sample:
    if(!window.sfdcPage) { window.sfdcPage = new ApexDetailPage(); }UserContext.initialize({"ampm":["AM","PM"],"isAccessibleMode":false,"salesforceURL":
    Is there anything I can do on my end to address this? Thanks!

  • #2
    Hi! Just adding to this post since you guys might be swamped and didn't see it. Thanks.

    Comment


    • #3
      Are you opening the report with a text editor? The report is designed to be opened in Excel, and the code formats the date to appropriately fill in the value.

      (thank you for posting again, we have been swamped and did miss your post the first time)

      Regards,
      Click & Pledge Support Department

      On Salesforce? Help us by rating our app: <a href="https://appexchange.salesforce.com/listingDetail?listingId=a0N30000003JGBvEAO" title="Click &amp; Pledge Donor Management on AppExchange" target="_Outside">Click &amp; Pledge Donor Management on AppExchange</a>

      Join us @ the educational webinars: <a href="https://clickandpledge.com/webinars/" title="Click &amp; Pledge Webinars" target="_Outside">https://clickandpledge.com/webinars/</a>
      Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: <a href="https://clickandpledge.com/webinars/" title="Click &amp; Pledge Webinars" target="_Outside">https://clickandpledge.com/webinars/</a>
      Are you on Salesforce? Join us at the Power of Us Hub: <a href="https://powerofus.force.com/0F980000000CjpC" title="Power of Us Hub" target="_Outside">https://powerofus.force.com/0F980000000CjpC</a>

      Comment


      • #4
        No worries about the delay! I well understand being swamped :-)

        Yes, Excel is opening the file.

        This is definitely not an urgent issue, so it's fine to put this one on the back burner.

        Comment


        • #5
          I certainly see the code when I open in a text editor, but the correct date column in Excel.

          Click image for larger version

Name:	2020-08-20_9-41-13.jpg
Views:	32
Size:	154.6 KB
ID:	55183



          What version of Excel are you using?

          My version is

          Click image for larger version

Name:	2020-08-20_9-47-06.jpg
Views:	23
Size:	13.3 KB
ID:	55184

          But we may be able to test in the version you use.
          Regards,
          Click & Pledge Support Department

          On Salesforce? Help us by rating our app: <a href="https://appexchange.salesforce.com/listingDetail?listingId=a0N30000003JGBvEAO" title="Click &amp; Pledge Donor Management on AppExchange" target="_Outside">Click &amp; Pledge Donor Management on AppExchange</a>

          Join us @ the educational webinars: <a href="https://clickandpledge.com/webinars/" title="Click &amp; Pledge Webinars" target="_Outside">https://clickandpledge.com/webinars/</a>
          Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: <a href="https://clickandpledge.com/webinars/" title="Click &amp; Pledge Webinars" target="_Outside">https://clickandpledge.com/webinars/</a>
          Are you on Salesforce? Join us at the Power of Us Hub: <a href="https://powerofus.force.com/0F980000000CjpC" title="Power of Us Hub" target="_Outside">https://powerofus.force.com/0F980000000CjpC</a>

          Comment

          Working...
          X