[Brett]

I also just tried a Custom JS function:

function copyApprover(){
setFieldValue("ReqApprover","Approver");
}

But the Rule fails to trigger the Custom JS for this either and no errors in the console.
Can you please check if a people-picker’s value can be copied on “Field change”?
Thanks.

[Brett]

Hi Tricia,

Thanks for providing another method for displaying a vLookup within a vLookup.
Difficult to follow your explaination.
You said you needed a Rule as well?
Can you provide a screen-grab of how the vLookup is displayed within a List View?
Thanks.

[Brett]

Thanks Alexander,
I started with the code form the AdamP’s post above.
At first it worked using setInterval, noerrors.

setInterval(function(){ 
$('.vLookupTable').DataTable(); 
	}, 3000);

But for some reason when I added more parameters to the Datatables function (eg: responsive etc), Datatables displays an error loading vLookup_innerTable_vLookup_4__Name.
So I used SetTimeout instead and it works, no errors.
This is the code placed in a cewp under vLookup_ListView.html.

setTimeout(function(){
 $('.vLookupTable').DataTable({
	paging: false, 
	ordering: true, 
	responsive: true, 
	autoWidth: true 
		});
		},4000);

Very happy with the end result.

[Brett]

Hi Alexander,

I was able to do this somewhat using the Grandparents Title field as a “Prefill values to Child” on the Parent List, then use that Parent’s field value again to Prefill in the grandchilds list.
So 3x vLookups configured in each Grandchild, Parent and Child list.
Then configuring another vLookup field in the GrandParent DFFS that matches the Grandparent Title to the grandchilds prefilled value and it displays.
It dooesn’t have full functionality, it can only be used to Display & Edit exisiting Grandchild items but otherwise works okay.
Screen-shot attached.

Attachments:

1. 

   thumbnail_image001.png
   

[Brett]

Thanks Alexander,

Uploaded 3x updated files and all seems working fine for me on SP2010.
Many thanks for the quick update.

[Brett]

HI Alexander,

Thanks, this worked with rendering the text field as a drop-down with the list of options.
But the end result is to be like a cascading drop-down which only returns a single value.
I tried the filterObj setting to return a single value but I can’t figure out how to return a value based on the lookup ID column.

Does it make a difference if the column values returned is another Lookup column?

I tihnk it’s easier to replace all lookup columns with Single-line text fields and configure cascading drop-downs in DFFS?
Thanks for your help anyway 🙂

[Brett]

Further to my post above, I copied over DFFS_backend_min.js and DFF_frontend_min.js files to a previous version, dated 15/04/2018 and DFFS loads fine.
Brett

[Brett]

Thank you Alexander,
That worked perfectly, much appreciate your time and effort on this.

[Brett]

Hi Alexander,
I’m staring at your replies above and have no clue what to do in DFFS config. 🙁
I’ve got the standard Lookup added to the Child list.
Person opens up New item and can select from drop-down of Parent items but that’s as far as I have got.

With your images above, is that connection to be configured in the Parent as a new vLookup connection or in the Child vLookup config?
Are there some instructions I can follow to configure the Child List connection to the Parent?
Thanks for your time.

[Brett]

Hi Alexander,

Not sure what you mean “normal Lookup column” do you mean the default SharePoint Lookup, the SPJS-Lookup or vLookup?
From the Child item, if I select the Parent, then go back to that Parent item, will it show up as a vLookup Child item?

Thanks

[Brett]

Wow, that worked.
Many thanks Alexander.

[Brett]

HI Alexander,
Your script works perfectly.
Many thanks for your time and effort.

[Brett]

Perfect, that is exactly what I was looking for.
Thanks Alexander.

[Brett]

Thank you Alexander, the updated file worked perfectly.
Now I just copy the multi values to a Managed Metadata column using DFFS Rules and Javascript to strip the line breaks using this code:

$('#dffs_Title').val().replace(/\n/g,'');

Last thing, with Rules Tab, will you be adding Multi-line text fields to run when field changes to a future release?

Thanks.

[Brett]

Hi Alexander,
Thanks for the prompt reply.
The first option works but when selecting more options, they don’t get moved across.
Image attached.

Also, is it possible to use a Managed Metadata column as the second multi column?
I was going to use a Rule to set the metadata field value anyway but thought I would ask if it’s possible?
Thanks for your efforts with this.

Attachments:

1. 

   cascadingDropdownError2.png
   

[Author]

Posts