[Gerard Graham]

Hi there

Is the problem the current item field I’m using? DisplayName is a calculated field.

Gerry

Attachments:

1. 

   vLookupQuery.png
   

[Gerard Graham]

Hi Alexander

First is the output from the Edit form followed by the output from the Display form for the same item.

Thanks

Gerry

Edit
Field: vLookupDivisions

blob:
{“noteToSelf”:””,”listName”:”ContDB-Divisions”,”listBaseUrl”:”/celcis”,”query”:{“fin1″:”Org”,”type1″:”Text”,”value1″:”,”,”fin2″:””,”type2″:”Text”,”value2″:””,”fullCAML”:””,”AndOr”:””,”operator1″:”Eq”,”operator2″:”Eq”,”orderBy”:”ID”,”rowLimit”:””},”childTableHeight”:””,”viewFields”:[{“fin”:”Title”,”settings”:””,”disp”:{“default”:””},”colWidth”:””,”colWidthOperator”:”px”},{“fin”:”City”,”settings”:””,”disp”:{“default”:”City”},”colWidth”:””,”colWidthOperator”:”px”},{“fin”:”Contacts”,”settings”:””,”disp”:{“default”:”Contacts”},”colWidth”:””,”colWidthOperator”:”px”}],”action”:”concat”,”action_groupBy”:””,”action_groupByHeaderStyle”:””,”action_groupByExpanded”:false,”action_groupByPrefix”:{“default”:””},”showTotals”:false,”openInDlg”:true,”disable”:false,”refreshAllOnCallback”:false,”viewItemLinkIn”:{“disp”:true,”edit”:true,”view”:true},”editItemLinkIn”:{“disp”:true,”edit”:true,”view”:true},”hideLabelInForm”:true,”label”:{},”moreItemsLabel”:{“default”:””},”noItemsLabel”:{“default”:””},”addNew”:true,”newItemInDlg”:true,”addNewDlgOpt”:{“width”:””,”height”:””,”x”:””,”y”:””,”allowMaximize”:false,”showMaximized”:false,”showClose”:false,”autoSize”:false},”addNewLabel”:{“default”:”New Division”},”addNewIn”:{“disp”:true,”edit”:true,”view”:true},”addNewFolder”:false,”addNewFolderLabel”:{“default”:””},”addNewFolderIn”:{“disp”:false,”edit”:false},”addNewDocLabel”:{},”inUrl”:[{“from”:”Title”,”to”:”Org”,”hide”:false}],”folderMetadata”:[],”uploadToFolder”:true,”uploadToFolderLabel”:””,”openFolder”:true,”openFolderLabel”:””}
Field: vLookupDivisions

query:
<View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Org’ /><Value Type=’Text’>,</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ /></OrderBy></Query></View>
Field: vLookupDivisions

Number of items matching the query: 0

Display
Field: vLookupDivisions

blob:
{“noteToSelf”:””,”listName”:”ContDB-Divisions”,”listBaseUrl”:”/celcis”,”query”:{“fin1″:”Org”,”type1″:”Text”,”value1″:”A Life Explored”,”fin2″:””,”type2″:”Text”,”value2″:””,”fullCAML”:””,”AndOr”:””,”operator1″:”Eq”,”operator2″:”Eq”,”orderBy”:”ID”,”rowLimit”:””},”childTableHeight”:””,”viewFields”:[{“fin”:”Title”,”settings”:””,”disp”:{“default”:””},”colWidth”:””,”colWidthOperator”:”px”},{“fin”:”City”,”settings”:””,”disp”:{“default”:”City”},”colWidth”:””,”colWidthOperator”:”px”},{“fin”:”Contacts”,”settings”:””,”disp”:{“default”:”Contacts”},”colWidth”:””,”colWidthOperator”:”px”}],”action”:”concat”,”action_groupBy”:””,”action_groupByHeaderStyle”:””,”action_groupByExpanded”:false,”action_groupByPrefix”:{“default”:””},”showTotals”:false,”openInDlg”:true,”disable”:false,”refreshAllOnCallback”:false,”viewItemLinkIn”:{“disp”:true,”edit”:true,”view”:true},”editItemLinkIn”:{“disp”:true,”edit”:true,”view”:true},”hideLabelInForm”:true,”label”:{},”moreItemsLabel”:{“default”:””},”noItemsLabel”:{“default”:””},”addNew”:true,”newItemInDlg”:true,”addNewDlgOpt”:{“width”:””,”height”:””,”x”:””,”y”:””,”allowMaximize”:false,”showMaximized”:false,”showClose”:false,”autoSize”:false},”addNewLabel”:{“default”:”New Division”},”addNewIn”:{“disp”:true,”edit”:true,”view”:true},”addNewFolder”:false,”addNewFolderLabel”:{“default”:””},”addNewFolderIn”:{“disp”:false,”edit”:false},”addNewDocLabel”:{},”inUrl”:[{“from”:”Title”,”to”:”Org”,”hide”:false}],”folderMetadata”:[],”uploadToFolder”:true,”uploadToFolderLabel”:””,”openFolder”:true,”openFolderLabel”:””}
Field: vLookupDivisions

query:
<View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’Org’ /><Value Type=’Text’>A Life Explored</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ /></OrderBy></Query></View>
Field: vLookupDivisions

Number of items matching the query: 1

[Gerard Graham]

Cheers

Works as you’d expect!

Gerry

[Gerard Graham]

Hi there

I’ve tried it on a test environment with the latest version and got the same result (although it seemed to work then stopped working).

I’ve then tried with the child library and parent list in the same site where previously they were in different sites. So far so good.

Regards

Gerry

[Gerard Graham]

Cheers

[Gerard Graham]

No need to be sorry. I’m just glad that there will be more soon. Beers on there way for this one!

[Gerard Graham]

Hi there

I was looking to do the same thing, pre populate a Multi look up field. The item is selected but not added.

Is this something that can be done?

Regards

Gerry

[Gerard Graham]

Hi there

Yes, there are multiple lines per employee in the list. I’d be filtering for a single project and summing employee hours for all outputs for that project.

As for Javascript knowledge – nil.

I can pull a spreadsheet for the list and use a pivot table to get the information I need so I do have a way, but in the vlookup would be better.

Thanks

Gerry

[Gerard Graham]

Also meant to ask will it ever be possible to allow a multi-level group by option e.g. by staff and by output in the example above.

[Gerard Graham]

Cheers. That worked a treat.

[Gerard Graham]

Hi there

No need to apologise. I will buy you a beer if you can fix this one. Promise!

I’ve attached the screen shot (have rather a lot of fields in this list)

The screen shot shows the Field Type as as Text in the configuration form. If I change to Lookup (Text value) I go no matching records, but also no error.

Thanks

Gerry

Attachments:

1. SubProjectError.docx

[Gerard Graham]

HI Alexander

I have a list of projects. Some projects are ‘parents’ of other sub projects in the same list. The link is a lookup field called Parent which returns from the project list a project name.

In the project display and edit forms I am using a vLookup field to look for sub projects to display. I have a range of other vLookups successfully working, pulling in child records from other lists. This is the only one that isn’t working. Is it do do with the fact that list it is looking up itself?

A similar example would be if I had alist of staff and the managers where in the same list. Could I use a vlookup to list for a manager their reportees?

Thanks

Gerry

[Gerard Graham]

Hi there

I’ve not solved the problem, but I have found out that it works in Chrome (Version 43.0.2357.130 m), but not in IE (v11.0.9600.17843). See screen shots

Any suggestions?

Thanks

Gerry

Attachments:

1. 

   IEvLookup.png
   

2. 

   ChromevLookup.png
   

[Gerard Graham]

I’m sure I have updated the DFFS files. The back end is showing as v4.303 (I was previously on 4.262) and there is a new tab in the set called Autocomplete which isn’t present in the set up that works.

G

[Gerard Graham]

Thanks

I may be missing something, but when I swap out the old files for the new files I, the vlookup fields appear with just their field name and no data. The back end configuration indicates that the plug in is not installed, but as far as I can see all the links to the files are working.

Regards

Gerry

[Author]

Posts