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

  • CnP.LiveSupport.AB
    replied
    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:	16
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:	9
Size:	13.3 KB
ID:	55184

    But we may be able to test in the version you use.

    Leave a comment:


  • mzellner@npsafoundation.org
    replied
    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.

    Leave a comment:


  • CnP.LiveSupport.AB
    replied
    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)

    Leave a comment:


  • mzellner@npsafoundation.org
    replied
    Hi! Just adding to this post since you guys might be swamped and didn't see it. Thanks.

    Leave a comment:


  • 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!
Working...
X