[William Ellis]

I have noticed that the ‘Delete’ word does not appear in my ListViews, only on the forms where I am showing the child records. Is there something else I have to do to have the delete functionality in a listview?

[William Ellis]

Thank you! Got it working. Also had to set the initial field comparison to == rather than =. Slowly getting the hang of this, thank you for all of your assistance!

[William Ellis]

I am attempting a similar solution, except that I am not using Boolean, I am checking Choice fields, so I made some changes. Each Initiative has several Assignments as children. If any children have Status != ‘Completed’, then I want the alert to show and not allow them to save the Initiative Status on the parent record as ‘Completed’. I have placed this in my parent Edit form CustomJS tab, but nothing happens when I save and have the Initiative Status set to ‘Completed’. I’m sure thee is something wrong with my script but I cannot see what that might be.

function dffs_PreSaveAction(){
// Check if parent form is closing
var initStatus = getFieldValue(“InitiativeStatus”); // Get Initiative Status value
if(initStatus=”Completed”){
var res = spjs.utility.queryItems({
“listName”:”Assignments”,
“query”:”<Where><Eq><FieldRef Name=’_vLookupParentID’ /><Value Type=’Text’>[currentItem:_vLookupID]</Value></Eq></Where>”, // Lookup parent ID
“viewFields”: [“ID”,”Status”] // return ID and Status of assignment records
});

if(res.count > 0){
var allStatus = true;
jQuery.each(res.items, function(i, item){
if(item.Status != “Completed”){
allStatus = false;
}
});
if(!allStatus){
spjs.dffs.alert({
“title”: “Not able to close”,
“msg”: “You cannot set the Initiative Status to Completed until all Assignments are Complete.”
});
}else{
// OK to save
return true;
}
}else{
// Does not have any child items – return true to save item
return true;
}
}else{
// OK to save
return true;
}

[William Ellis]

Is it possible to get the Parent Disp form to open in Dialog mode? Perhaps adding the ?=IsDlg=1 to the end of the ItemRelURL?

Also, the jQuery is not working to edit the text of the link. I put this in the Customjs tab of the child New form but nothing happens.

jQuery(“#dffs_InitiativeURL input:first”).val(“Link”);

Is there something I need to put somewhere to trigger this?

Dynamic Forms for SharePoint v4.4.5.20
vLookup plugin backend v2.2.161

[William Ellis]

It is vLookup_Children

[William Ellis]

I’ll get a screenshot to you shortly. As for the vLookup fieldnames, is that the internal field names can’t be the same? The user manual seems to say that I must use _vLookupID and _vLookupParentID if I want to allow it to work with the >5000 list view items. So if that is the case, there is no way I can use two web parts from different lists on the same web part home page?

It does work better on the list view page, but it still has issues when paging through records two group-levels down.

[William Ellis]

Yes, that works great.

[William Ellis]

I added the code(the second block you mentioned), but nothing changed.

The first block was not in the code to begin with, shown below)
$(window).on(‘hashchange’, function(){
spjs.vLookup.init();
});
So I removed what I added in. There are times when the ‘Loading’ text flashes for a brief second and then disappears with no child records showing. Other times when I open a group, the child records appear. There are two different Web Parts with vLookups, to different lists, not sure if that is causing it, seems to be the same when it was just one web part.

I did an F12 and saw no errors either.

[William Ellis]

Alexander, the link you shared seems to be specific to SP 2010. I do not see the specific lines of code in the html page.

[William Ellis]

No, the child column data just disappears. If I open another group and drill down to the records, then the child column data appears for the whole web part. It is like it is not refreshing and running whatever code runs to populate the child data in the list view, when I page through the records(currently showing 20 per page).

I’ll give that link a try and see what happens.

[William Ellis]

Also, the columns for the child records seem out of alignment in the list view. Can this be fixed?

Attachments:

1. 

   DFFS_vLookup_Column-Alignment.png
   

[William Ellis]

That did it! Figured it was something simple I was missing! Thank you!!!!

[William Ellis]

I have tried this alert code, but the alert message flashes for a split second and disappears, saving the changes. Anyone else had this issue?

[William Ellis]

OK, I have two different cascading dropdown groups on my Edit form. I have removed the delimiter line from the code in both. Created a new record (autoselectSingleOption set to true on the New form). Values populate correctly in the text fields with the ; as the delimiter.

If I set the autoselectSingleOption to false on the Edit form, it recognizes the entries and no red boxes.

However, if I set autoselectSingleOption to true, and if there is only one option available and it has been selected, the red box appears around the empty selector box and it displays both the value with the ; and the one without it in the selected box, similar to how it has failed previously.

I alos tried it with the “multichoiceDelimiter”: “;” + String.fromCharCode(13, 10), line added into all four places (New and Edit forms) but with the same results.

[William Ellis]

I created new records to test this. It still can’t recognize the values compared to the source list due to the ;d on the end. Here is the debug from the Edit form.

[SPJS Cascading dropdowns v3.7.43] :: DEBUG

Function called with these arguments:

manualMode:true

dataSource:

lookupList:regulatorcascades

lookupListBaseUrl:/sites/coo-rr-009/emea-apac-ca-latam

lookupListFields:Region,Country,Regulator,RegulatorShortName,LegalEntity,Id

thisListFields:Region,Country,Regulator,RegulatorShortName,LegalEntity

setFields:

dropDownDefaultvalue:

filter:

hideEmptyDropdowns:false

autoselectSingleOption:false

clearInvalidSelection:false

addOwnValue:false

addOwnValueMouseover:

cancelOwnValueMouseover:

sideBySide:true

multichoiceDelimiter:;

debug:true

dataSourceId:regulatorcascades_061551076830822504

numberOfDropdowns:5

Populating this field

Region

Number of items returned

3

Populating this field

Country

Number of items returned

0

*** Please note that this debug panel cannot determin if the fieldname: “Country” in the lookup list is correct.

*** If you are not getting the options you expected, verify the FieldInternalName: “Country” in the lookup list: “regulatorcascades”

Populating this field

Regulator

Number of items returned

0

*** Please note that this debug panel cannot determin if the fieldname: “Regulator” in the lookup list is correct.

*** If you are not getting the options you expected, verify the FieldInternalName: “Regulator” in the lookup list: “regulatorcascades”

Populating this field

RegulatorShortName

Number of items returned

0

*** Please note that this debug panel cannot determin if the fieldname: “RegulatorShortName” in the lookup list is correct.

*** If you are not getting the options you expected, verify the FieldInternalName: “RegulatorShortName” in the lookup list: “regulatorcascades”

Populating this field

LegalEntity

Number of items returned

0

*** Please note that this debug panel cannot determin if the fieldname: “LegalEntity” in the lookup list is correct.

*** If you are not getting the options you expected, verify the FieldInternalName: “LegalEntity” in the lookup list: “regulatorcascades”

[Author]

Posts