[Alexander Bautz]

Hi,
Now that I see this output it occurs to me that you have used the wrong brackets. You used curly brackets like this:

{currentItem:ID}

but what you must use is square brackets like this:

[currentItem:ID]

Alexander

[Alexander Bautz]

Hi,
Activate the debug output by appending this to the URL in your list view (or in DispForm):

.../AllItems.aspx?vLookupDebug=1

Add the output (at the bottom of the screen) in an attachment here.

Alexander

[Alexander Bautz]

Currently I cannot think of any method. I’ll add an option in vLookup to “translate” a value like you require.

It will take a few days, so check back here.

Alexander

[Alexander Bautz]

I see. If you want to hide an entire side-by-side row you must actually address the row by the ID like this in the “Hidden headings or elements” option of the rule:

sbs_OuterTR_1

The number “1” represents the “side-by-side index” from the tabs.

Please note that if you hide the “side-by-side row” like this, you do not have to individually hide the fields in the “side-by-side row”.

This is as far as I remember not documented – sorry about that.

Hope this helps,
Alexander

[Alexander Bautz]

I’m sorry, but as I have not experience dealing with external lists I cannot be of much help here. I hope you find the solution, and when you do, please post back the solution here.

Alexander

[Alexander Bautz]

I’ll have to see some screenshot to know what you mean. One before hiding, and one after.

Alexander

[Alexander Bautz]

Please verify that the script src is correct, and if it is, try moving the code to the CEWP (below the last script tag where) like this:

<script type="text/javascript">
function dffs_Ready(){
spjs.ac.textField({
        "applyTo":"test",
        "helpText":"Project name or number...",
        "listGuid":"Adresses",
        "listBaseUrl":"",
        "showField":"Ville",
        "rowLimit":5,
        "listOptionsOnFocus":false,
        "reValidateOnLoad":false,
        "setFields":[]
});
}
</script>

Then bring up the developer console (hit F12 > console) and look for errors.

Alexander

[Alexander Bautz]

Hi,
The code looks good, but I suspect you have not referred the script file with the autocomplete solution in your DFFS frontend CEWP.

Alexander

[Alexander Bautz]

The first line indicates a syntax error. If you right click the page and view source – what do you find in line 794?

Alexander

[Alexander Bautz]

How have you set the color to green?

Alexander

[Alexander Bautz]

I’m glad it worked out. You must have downloaded v2.455 exactly when I first published it as I did publish it, and retracted it again within a few minutes to fix this exact problem. I then republished it again with the same version number as I figured no one had downloaded it in this short “window”.

Sorry for the inconvenience,
Alexander

[Alexander Bautz]

Hi,
Are you 100% sure you use the latest DFFS frontend? – I thought this was fixed in v4.255 – as described in the change log.

Alexander

[Alexander Bautz]

I guess this happens when you use Side-by-side?

You can use the “Field CSS” tab or the CSS examples in the “Side-by-side” tab in the backend to set the width of individual fields, but if you like to change this “globally” in the CSS file, you find this in line 151 in DFFS_frontend.css:

.sbs_FieldTable td.ms-formbody{
	border-top:none;
	width:auto;
}

change it like this:

.sbs_FieldTable td.ms-formbody{
	border-top:none;
	/*width:auto;*/
}

Alexander

[Alexander Bautz]

Hi,
Yes, it is the missing ID column that causes it to malfunction. This is what I have tried to take care of in the modified function above.

Try inserting this right below where you load the spjs-utility.js script in the “DFFS_frontend_CEWP.js.aspx” CEWP:

<script type="text/javascript" src="/Your_Path_Here/spjs-utility.js"></script>
// Add the code snippet here

If this does not work, you can most likely make it work if you add a column “ID” (with an unique id number) to the external list.

Alexander

[Alexander Bautz]

Hi,
I have not used external lists myself so I need you to test this snippet for me. Ensure you use the latest version of spjs-utility.js (v1.205), and add this override code below where you refer the spjs-utility.js file:

<script type="text/javascript">
spjs.utility.queryItems = function(argObj){
	var content, result, requestHeader, fieldValObj, value;
	if(argObj.listBaseUrl===undefined){
		argObj.listBaseUrl=L_Menu_BaseUrl;
	}
	if(argObj.listName===undefined || (argObj.query===undefined && argObj.viewName===undefined)){
		alert("[spjs.utility.queryItems]\n\nMissing parameters!\n\nYou must provide a minimum of \"listName\", \"query\" or \"viewName\" and \"viewFields\".");
		return;
	}
	if(spjs.$.inArray('ID',argObj.viewFields)===-1){
		argObj.viewFields.push('ID');
	}
	if(spjs.$.inArray('BdcIdentity',argObj.viewFields)===-1){
		argObj.viewFields.push('BdcIdentity');
	}
	content = spjs.utility.wrapQuery({'listName':argObj.listName, 'query':argObj.query, 'folder':argObj.folder, 'viewName':argObj.viewName, 'viewFields':argObj.viewFields, 'rowLimit':argObj.rowLimit, 'pagingInfo':argObj.pagingInfo,'scope':argObj.scope});
	result = {'count':-1, 'nextPagingInfo':'', items:[]};	
	if(argObj.setRequestHeader===false){
		requestHeader  = '';
	}else{
		requestHeader  = 'http://schemas.microsoft.com/sharepoint/soap/GetListItems';
	}
	spjs.utility.wrapSoap(argObj.listBaseUrl + '/_vti_bin/lists.asmx',requestHeader, content, function(data){
		result.count = parseInt(spjs.$(data).filterNode("rs:data").attr('ItemCount'),10);
		result.nextPagingInfo = spjs.$(data).filterNode("rs:data").attr('ListItemCollectionPositionNext');
		fieldValObj = {};
		spjs.$(data).filterNode('z:row').each(function(idx, itemData){
			fieldValObj[idx] = {};
			spjs.$.each(argObj.viewFields,function(i,field){
				if(field === "ID" && spjs.$(itemData).attr("ows_ID") === undefined){
					if(spjs.$(itemData).attr("ows_BdcIdentity") !== undefined){
						value = spjs.$(itemData).attr("ows_BdcIdentity");
					}else{
						value = "";
					}
				}else{
					value = spjs.$(itemData).attr('ows_' + field);
				}				
				if(value === undefined){
					value = null;
				}
				fieldValObj[idx][field] = value;
			});
			result.items.push(fieldValObj[idx]);
		});
	});
	return result;
}
</script>

When this is done, try the autcomplete solution. Please let me know how this works out – and use the developer toolbar (F12 > Console) to look for error messages.

Alexander

[Author]

Posts