[Alexander Bautz]

Oh – I see, I have failed to implement the reversing action “on load” on all the different triggers. I will fix this and release a new version within a day or two.

You can work around this for now by changing the rule to “less than” like in my example above.

Sorry for the inconvenience.

Alexander

[Alexander Bautz]

I will fix this issue in the next release by removing the ContentTypeId from the URL if it is empty.

Alexander

[Alexander Bautz]

Sorry for not answering – I have had a problem with notification from the forum.

I’m not sure I understand what you mean, but in general, DFFS cannot be used with custom forms – only default, unmodified forms.

Alexander

[Alexander Bautz]

Hi,
I’m not familiar with the SPServices Add New feature, but from the URL it looks like the problem is that there is two question marks in the URL. If this only happens when you use the SPServices feature I think you must look at this to fix this issue.

Alexander

[Alexander Bautz]

Sorry for not answering – I did not receive a notification about this question. Did you figure it out?

Alexander

[Alexander Bautz]

Hi,
Sorry for not answering – It seems I have an issue with the email-alert feature related to new posts.

Did you figure it out?

Alexander

[Alexander Bautz]

Sorry for the delay – I didn’t get an email about your follow-up.

I have tested this, and using the attached setup it shows and hides the heading.

Can you test?

Alexander

Attachments:

1. 

   HideHeadings.png
   

[Alexander Bautz]

Hi,
Sorry for the delay. I tried to attach a script generated select to a list view, but it didn’t work as the page refreshed when I tried to filter the view – resulting in the select falling back to the default value returned from the query.

If you want to try it out yourself, here is the code I tried to use in the HTML form web part:

<select id="myCustomListFilterDropdown" name="T1"></select><input type="button" value="Go" onclick="javascript:_SFSUBMIT_"/>

<script type="text/javascript" src="/SPJS/DFFS/plugins/jquery.js"></script>
<script type="text/javascript" src="/SPJS/DFFS/plugins/SPJS-utility.js"></script>
<script type="text/javascript">

var oRes = spjs_QueryItems({"listName":"Dummy","listBaseUrl":"/DFFS","query":"<Where><IsNotNull><FieldRef Name='Title' /></IsNotNull></Where>","viewFields":["ID","Title"]});
if(oRes.count < 0){
	alert("Query failed, please check your parameters");
}else{
	var b = [];
	$.each(oRes.items,function(i,item){
		b.push("<option value='"+item.ID+"'>"+item.Title+"</option>");
	});
	$("#myCustomListFilterDropdown").append(b.join(""));
}
</script>

Alexander

[Alexander Bautz]

Strange, it did work in my test in an Office 365 site. Can you locate this line in spjs-utility.js:

if(result.errorCode === '0x80070024'){

and change it like this:

console.log(result.errorCode);
if(result.errorCode === '0x80070024'){

You must bring up the developer console (F12 > Console) to see the output – what does it read?

When you are in the developer console, you can go to the “Network” tab and activate the logging (hit “play” in the top left corner). Look at the output and compare it with “Network_log.PNG” (attached).

The first “/DFFS/_vti_bin/lists.asmx” with result 500 is the first query that hits the error handler in the first code snippet in this comment, and the next is the query to find the highest ID in the list. The next two is the original query separated into chunks of max 5000 items each.

How does your output look like?

Alexander

Attachments:

1. 

   Network_log.png
   

[Alexander Bautz]

I have now updated spjs-utility.js to support large lists: https://spjsblog.com/2015/07/26/spjs-utility-updated-with-support-for-querying-large-lists/

Can you test the autocomplete solution after you have updated spjs-utility.js to v1.209?

Alexander

[Alexander Bautz]

Hi,
What kind of field is Field1 and Field2? – if they are boolean (Yes/No) you must use true for checked and false for unchecked.

Hover over the help icon for details for each selected trigger.

Alexander

[Alexander Bautz]

Hi,
Sorry for the late reply. I’m not 100% sure I understand what you mean, but you can add code like this to get the option in a variable:

You must use the developer tools (hit F12 > DOM Explorer) to inspect the dropdown to find its ID – mine has the ID “f3cf96da-cfb5-43b8-b6c4-1024b8231639_CustomFilterSelect_FieldInternalName”:

var selectedVal = $("#f3cf96da-cfb5-43b8-b6c4-1024b8231639_CustomFilterSelect_FieldInternalName").find("option:selected").val();
alert(selectedVal);

You can also set it up “live” like this:

$("#f3cf96da-cfb5-43b8-b6c4-1024b8231639_CustomFilterSelect_FieldInternalName").bind("change",function(){
alert("selected value: "+$(this).find("option:selected").val());
});

Hope this helps,
Alexander

[Alexander Bautz]

Hi,
Sorry for the delay. Here is a pure CSS example – found in this page: https://css-tricks.com/numbering-in-style/

Add this to the Custom CSS in the backend:

.ms-formtable{
	counter-reset: spjs-css-counter;
}
.ms-formtable h3:before {
	content: counter(spjs-css-counter);
	counter-increment: spjs-css-counter;
	font: bold 25px/1 Sans-Serif;
}

This will number the columns from the top, so if you have some hidden columns you could use something like this in the Custom JS section to add the number to only the visible columns in JavaScript:

function customFieldNumber(){
	spjs.$(".customFieldNumber").remove();
	setTimeout(function(){
		spjs.$("td.ms-formlabel:visible").each(function(i,td){
			spjs.$(td).find("h3").prepend("<span class='customFieldNumber'>"+(i+1)+"</span>");
		});
	},1);
}

// On tab change
spjs.$("li.tabBase").click(function(){
	customFieldNumber();
});

// On page load
customFieldNumber();

Style the new number in the Custom CSS like this:

.customFieldNumber{
	font-size:25px;
	color:green;
}

Alexander

[Alexander Bautz]

Hi,
Unfortunately the documentation is not as good as it should be, but I have mentioned a “selectionHandler” here: https://spjsblog.com/2013/03/11/spjs-charts-for-sharepoint-export-to-excel-and-sp2013-support/#comment-48514

Here is the code example:

function spjs_chartSelectionHandler(chartID,selection,data){
	var message, item, value;
	message = "";
	value = "";
	item = selection[0];
	if(item.row !== null && item.column !== null){
		message = "{row:" + item.row + ",column:" + item.column + "}";
		value = data.getValue(item.row, item.column);
		if(message === "") {
			message = "nothing";
		}
		alert("You selected " + message +", the value is: "+value);	
	}
}

This code must be added to the MASTER CEWP – above the “spjs-charts-v4.js” script – for example below the license code.

Let me know how this works out.

Alexander

[Alexander Bautz]

Hi,
I’m glad you figured it out – I have a hard time following up all emails and forum posts so there will unfortunately be some time delay on my answers.

Alexander

[Author]

Posts