SPJS Table Chart and Note field

[Phil Grant]

Hi,
I have some charts on SP2010 SPJS v.6 and I’m trying to rectreate them on SP2019 SPJS v.7 in a table chart, I’m not able to select some fields, I think the problem is that the missing fields are all “Note” fields?

Is there a reason why I could select “note” fields in SPJS v.6 on SP2010 but not in v.7 on SP2019?

Thanks,

Phil

[Alexander Bautz]

Hi,
v7 is completely redesigned from v6 and I skipped note fields because I didn’t think it was relevant to use in a chart (didn’t think the table chart…).

I have fixed is and have attached the script file below. Just unzip and drop it in your SPJS/CHARTS_V7 folder.

I’ll include it in the next release.

Alexander

Attachments:

1. spjs-charts_v7.0.1.16.zip

[Phil Grant]

Alexander,
Thanks for the fix, I thought it was a bit strange.

Phil

[Phil Grant]

Thanks, that fixed it, one other strange thing I’ve noticed is that the label for the index field converts any spaces to the “+” sign when saving the configuration, is this the script or something to do with SharePoint?

Cheers

[Alexander Bautz]

Hi,
Not sure which field are you referring to – add a screenshot if possible.

Alexander

[Phil Grant]

I will add a screenshot tomorrow but it is all fields in the table chart, when you add a field any labels that have spaces get the spaces replaced with the + sign when the configuration is saved.

[Alexander Bautz]

I tested adding labels and cannot reproduce this issue – I’m using Chrome, which browser are you using?

Alexander

Attachments:

1. 

   image_2021-09-28_194011.png
   

[Phil Grant]

Currently using Edge but will try it on chrome as well and let you know.

Phil

[Phil Grant]

I wonder if it’s an issue with SP2019 then.
I will ask our It support.

[Phil Grant]

Here are a couple of screenshots showing the table header and the config page, when I remove the + from the label and use spaces the spaces are replaced by + as it’s saved.

This happens in both Edge and Chrome, I suspect that if it doesn’t do it for you then it’s probably something to do with our SP2019 instllation.

• This reply was modified 2 years, 10 months ago by Phil Grant.

Attachments:

1. 

   Plus-instead-of-space.png
   

2. 

   Plus-instead-of-space-config.png
   

[Phil Grant]

Alexander,
I’ve had some feedback from my IT support and they said
“We think that it matters which JavaScript encode function is used before the configuration is sent to SharePoint list.
SPJS creates a “escaped” JSON which is sent to a list.
We also found a workaround, instead of using ” ” (space) – use  ”

I used their suggestion and it looks fine now.

[Alexander Bautz]

I’m not able to recreate this issue on my SharePoint Online tenant so maybe it is related to an on-prem 2019.

In any case I’m glad you found a workaround.

Alexander

[Author]

Posts