[Phil Grant]

Brilliant, thanks for the help.

[Phil Grant]

Alexander,
That worked.

Sorry, I just realised I posted in the wrong forum, should have been in SPJS charts.

Is there any way to format the Totals row, I’ve looked a “inspect element” but cannot see how to sort it.

[Phil Grant]

OK, Makes sense I suppose, I’ll give it a try.

Thanks

[Phil Grant]

Ok, the first column is set as a number (Id) so I can change that but which rows are totalled, can it be specified?

[Phil Grant]

Flipping heck, I never even noticed that option !!! thanks for pointing it out.

[Phil Grant]

Thanks Alexander that worked fine

[Phil Grant]

Great, thanks I’ll give that a try on Monday.

[Phil Grant]

OK thanks, V7 will have to wait until the company updates from sharepoint 2010, hopefully towards the end of this year.

[Phil Grant]

Is it possible to add a row entry programatically into the chart using External JS as in this post Link

[Phil Grant]

I found some information here https://stackoverflow.com/questions/21872915/vertical-reference-line-in-google-timeline-visualization
But I’m not clued up enough to know if it would work through SPJS or how to do it if it did.

Phil

[Phil Grant]

Never mind, found there was a comma missing in your setFieldValue statement.

[Phil Grant]

Hi,
I’ve tried this in my DFFS but I keep getting a Javascript error, not sure why, I’ve tried using field names and internal field names but both cause the error, any ideas what I’m doing wrong? thanks

function logHistory(){
var a = getFieldValue("Additional CCB Comments"), b = getFieldValue("CCB Comments"), c, d = spjs.utility.userInfo(spjs.dffs.data.currUserID);
if(a !== ""){
c = new Date().toLocaleString(_spPageContextInfo.currentCultureName);
setFieldValue("CCB Comments" c+" - "+d.Title+"\n"+a+(b!==""?"\n"+b:""));
// Clear the Log field
setFieldValue("Additional CCB Comments","");
}
}

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

[Phil Grant]

Thanks,
I found the “searchFields” info on another post but it didn’t make any difference.
I’m sure that the “Column1” is the column title, but I tried again with a new list with different names but I still get the error.

Phil

[Phil Grant]

Unfortunately the raw sharepoint list view is no good because the notes field shows “View entries” instead of the text.

[Phil Grant]

Unfortunately the “connections” option is greyed out ??
Just realised, you meant raw lists not SPJS table charts, DOH! yes that seems to work but not as nice looking as the SPJS view.

• This reply was modified 6 years ago by Phil Grant.

[Author]

Posts