[MikeS]

Placing the above JS in the Display form Custom JS and updating the JS with my FINs does not prevent blank fields from being printed. Must be missing something.

MikeS

[MikeS]

Where is “dffs_noPrint” entered?

[MikeS]

That fixes everything!

Thanks for your help,
MikeS

[MikeS]

Screenshots with ID in two areas of vLookup configuration are attached. With this setup the Child is created but it never appears in the Parent form or Parent List view. This applies to new or older records. The Child _vLookupParentID is the same as the Parent ID with this setup.

Thanks,
MikeS

Attachments:

1. 

   vLookup-PrefillValues.png
   

2. 

   vLookup-Query.png
   

[MikeS]

I had forgotten to insert a reference to the file: vLookup_ListView.html in a Content Editor web part on various List views and that was why the Child records were not appearing in the List.

Using the ID did not work for me consistently. I will have users add Child records to the Parent while in the Parent Edit form. That works for older records every time.

Follow-on question: Can a rule reference a SharePoint list of names (rather than a SharePoint Permission Group) as a Trigger? Or is there a JS function that could provide this while also allowing a CAML filter for a subset of names in that list?

Thanks,
MikeS

[MikeS]

99 percent of the records are added to the Parent list via MS Access from an external data set (back end approach). This bypasses the Add form in the Parent list. I would like users to add Child records using the Parent Display form for security reasons. However, one is required to open and save a Parent record to add a unique _vLookupID and THEN add the Child record (using Display form) for it to appear in the Parent record Display form.

Using the DFFS Edit form outright eliminates the extra Edit step as the _vLookupID gets added in the Edit form and then the Child record appears in the Display form.

HOWEVER, I cannot see the Child record in the List view for those records added using the back end and then edited with the Edit form. The _vLookupID is present for the Parent record, the Child record is in the Parent Display form but nothing in the Parent list view. Why is that?

Two questions:
1. Any way to add a unique _vLookupID when records are added without using the New form?
2. Over 1700 existing Parent records need a _vLookupID.
2. Your comment: “How are you connecting the items? – if you are using _vLookupID <> _vLookupParentID it is most likely because your older records does not have the _vLookupID value filled in.” implies a different way to connect records? Is that a possibility and would it obviate the above issue?

Thanks for your help,
MikeS

[MikeS]

I was able to use the Autocomplete JS solution and it is working well. So no further action needed.

Mike

[MikeS]

Yep, my mistake. I’ve got the Custom JS configured and working great with the correct delimiter.

Thanks for your help,
Mike

[MikeS]

Yes, I determined that and have configured my Custom JS. However, I’m unable to deactivate the Cascading dropdowns panel by deleting all entries as I get the message, “Error in “Cascading dropdowns” tab! The FieldInternalName “” is incorrect”

Is there a way to remove that?

Mike

[MikeS]

I updated to the latest DFFS 4.4.5.5 and I still do not see the “Change multichoice delimiter” option.

Mike

[MikeS]

I am using DFFS 4.4.4.32. Since I do not see the “Change multichoice delimiter” in my Cascading dropdown options at the bottom of the screen was it added in a later version?

Mike

[MikeS]

If you can help I would prefer a custom JS. Unfortunately it looks like I’m going to have to create 80 fields in the parent if I wish to pull any number of records forward from the child list.

Could the code in these posts be expanded or combined:

https://spjsblog.com/forums/topic/send-vlookup-data-in-a-workflow-email/

https://spjsblog.com/forums/topic/set-value-from-vlookup-table-to-a-field-in-the-current-form/

It seems that others may benefit as well with a custom solution.

Thanks,
Mike

[MikeS]

Alex,

I have a similar situation as above. I have a parent list that needs to import records from a child list (the child list contains boilerplate multi-line text that will be further custommized once in the parent list). The child list contains 20 records, 4 fields per record = 80 fields.

The user should be able to select any or all of the 20 records from the parent list and import all related fields for each child record to the parent list. Once imported the user must be able to edit the records in the parent list and export to a spreadsheet after editing.

Based on the above discussion it looks like vLookup is the way to approach this and avoid setting up 72 fields in the parent that replicate the child fields. However, I’m not sure your JS above will allow editing.

Do you agree or is there a better solution?

Thanks
Mike

[MikeS]

Alexander,

I’m in need of a similar solution using autocomplete. This is a multi-select requirement where the user can select one or multiple names from a second list. This second list contains names and emails.

The names and the associated emails are then aggregated and concatenated in two separate fields as follows:

Names:
Doe, John; Doe, Jane

Emails:
john.doe@foo.com; jane.doe@foo.com

Numerous attempts so far always result in the message: “You cannot use the ‘setFields’ section in the configuration when you are using the ‘multiselect’ option” error message.

Thanks,
Mike

[MikeS]

Works great Alexander! Thank you.
Mike

[Author]

Posts