[MikeS]

Unfortunately that enhanced CAML query results in only the parent being rendered in the vLookup table. I need the parent and children to be rendered for only the parent item.

I can set up a rule that will trigger on a parent specific field. That should then render the vLookup table properly. However, when I place the “function vLookupIsLoadedCallback” JS in the “Run these functions” after a {inline} field nothing displays in the multiline field. Does that script need a tweak to run in that location?

MikeS

[MikeS]

Here is an example of the Title field:
Part1,All [parent]
Part1,A [child]
Part1,B [child]
Part1,C [child]
Part2,All [parent]
Part2,A [child]
Part2,B [child]
Part2,C [child]

The vLookup CAML query is working well by filtering on the ‘Part1’ or ‘Part2’ common to the family of items in this single list. However, each child as well as the parent renders all of the items, when only the parent should display the children AND the parent in the vLookup table. The children should not render the vLookup table.

MikeS

[MikeS]

The script in No. 2 above is working well in the Edit form.

Can a CAML-like query be placed in this script so that it only runs based on characters (CONTAINS) in a CurrentItem:FIN field?

Thanks
MikeS

[MikeS]

Thank you Alex, this is working well. A few more tweaks are needed.

Is this caution from the vLookup manual a consideration if our internal list threshold for an on-site SP 2013 is 15,000 items?: “Please note that you cannot use the default lookup column connection if your parent list ever exceeds 5,000 items.”

1. Can vLookup be customized in such a way that it will only absorb the child data based on a string found in the Title field? This will allow only the parent to display the children found in the same list. Now the children and the parent all display the same information which would confuse the user. I could hide the Rollup Tab for the children and just display it for the parent, but that seems less than optimal. Your thoughts?

2. Set value from vLookup table to a field in the current form would allow a single line displayed in a vLookup table to be inserted into a field in the current item. Is there a way to take multiple multi-line values (from the children) shown in the vLookup table and automatically aggregate them in a single multi-line text field in the current (parent) item with a pipe delimiter between each child’s value?

Thanks
MikeS

[MikeS]

A regular vLookup would work as it would dynamically update in the parent when a child is updated. I would then use JS to write the updated child fields to a single multi-line parent field.

I’m just having a bit of a problem with the vLookup setup. Some details:

1. This is a vLookup into the same list (no child list). Does that require the [currentItem:FIN] format as shown in the tooltip?
2. However, the lookup field (Title field) is a single line text field in which only the first 12 characters provide the match needed for the vLookup. Seems like this would require use of the CAML-query section of the vLookup. Would the same format,

var query = "<Where><Contains><FieldRef Name='Your_MultiLineTextField' /><Value Type='Text'>"+lookupValue+"</Value></Contains></Where>";

then be inserted? Tried this and a number of configurations and keep getting ‘no items found.’

Thanks,
MikeS

[MikeS]

I can easily copy the lookup column to a plain text field. How would a CONTAINS query work then?

MikeS

[MikeS]

I have a parent item with multiple children that are related to the parent by a lookup column. (These children originate independently of the parent and thus vLookup will not work as I am not generating the children from the parent.)

Each child has a multi-line text field that must be pulled forward to the parent thru DFFS multi-select. ** When the multi-line text field is changed in the child it would be optimal if that change was immediately reflected in the parent (like SharePoint OOTB changes).**

Lacking that ability with current spjs.casc.init code, the user edits the parent and re-selects the children in the multi-select box and then the changes in the multi-line text field are pulled into the parent.

Thanks,
MikeS

[MikeS]

How can I compare just the first 12 characters of LookupColumn2 to LookupColumn1? (LookupColumn2 is an aggregation of metadata that includes LookupColumn1 as a prefix.)

Thanks
MikeS

[MikeS]

Alex,

I’m using the manual CASC implementation (spjs.casc.init) in custom JS and trying to implement the following. Note that this CASC implementation is looking up to the same list with multi-select.

1. Set filter to another field (a SharePoint OOTB single lookup field – but could convert this to a single-line plain text if needed) in the record so only those options that contain the filter appear in the selection box, basically a dynamic filter. Not sure if CAML can do that. I looked at Multiple filters from same datasource (CAML) — perhaps that could be adapted? I’ve also looked at SPJS-Lookup but that may be more than I need in combination with spjs.casc.init

2. Once an option is selected automatically auto select all secondary options – not just if only a single option is found (as the menu-driven CASC allows).

Thanks,
MikeS

[MikeS]

Works great Alex.

Thanks for your help,
MikeS

[MikeS]

Alex,

I have a lookup column in List A that links to an item in List B. I wish to include the link to the List B item in a DFFS email generated from the Display form in List A. The {viewitemlink} does not work as it goes to List A. I tried a variation of the script above in my List A Display form Custom JS but that did not work either.

Thanks for your help,
MikeS

[MikeS]

Thanks for reminding me of that solution. Works great once again.

MikeS

[MikeS]

Alexander,

I would like to write the Associated Fields, e.g., ProjectNumber, into another single-line plain text field for DFFS email purposes. The ProjectNumber FIN is of the format “YOUR_LOOKUP_FIELD_INTERNAL_NAME_x003a_ProjectNumber”.

The Lookup Field is a multi-value lookup so more than one associated field is returned. All of them should appear in the Edit form in the single-line text field when the form loads (and Lookup Fields have been chosen). This will allow the user to edit this field and choose the desired ProjectNumber for the subsequent email.

How could I do that?

Thanks,
MikeS

[MikeS]

I understand. The print function is very handy and alleviates a shortcoming in SPD relative to the handling of Rich Text fields.

Thanks for your help,
MikeS

[MikeS]

Works great! I had the wrong FIN entries.

Can you think of any way to get a header and footer on each page, vs. a single header at the beginning and a single footer on the final page?

Thanks,
MikeS

[Author]

Posts