[MikeS]

I changed skipIfEmpty to “false.” That allows me to see the complete list of Template Types in the Autocomplete list Template selection field (proper operation).

Unfortunately, all fields are still being overwritten in the Autocomplete list, whether blank or not.

MikeS

[MikeS]

Yes, version 1.5.52, April 15, 2021, is shown. It is not working properly as described in the diagram above that explains it in more detail.

Thanks for your help,
MikeS

• This reply was modified 3 years ago by MikeS.

[MikeS]

Alexander,

I’ve tried this on New and Edit forms and it is not working as needed. If there are blank fields in the source list record the Template Type is not showing up in my Autocomplete Template selection field. Kind of opposite from what I need. In order to better communicate what is needed I’ve attached a diagram that should help.

Thanks
MikeS

Attachments:

1. 

   DFFS_Autocomplete_diagram.png
   

[MikeS]

Thank you! This works perfectly.
MikeS

[MikeS]

Alexander,

Having a bit of problem integrating these statements

/* Hide header - the number 6 is the count of columns from left*/
#vLookupTablePlaceholder_vLookupTasks tr .childTableHeader:nth-child(6){
}

/* Hide body - change vLookupTasks for your vLookup field name and vLookupTasks_Status to match your vLookup field name and the child list field internal name separated with _  */
#vLookupTablePlaceholder_vLookupTasks .vLookupTasks_Status{
    display:none;
}

with the larger code:

function vLookupIsLoadedCallback(fin) {
    if (fin === "vLookupParentRollup") {
        if (getFieldValue("RackCode") === "AA") { // Only run this for the parent item
            var arr = [];
            jQuery("#dffs_vLookupParentRollup .vLookupTableRow").each(function (i, row) {
                arr.push(jQuery(row).find(".childTableCell:eq(2)").text());
            });
            setFieldValue("PartDescriptionCombo", arr.join("|"));
        }
    }
}

Where do they go?

Also, do I replace vLookupTasks with my vLookup field as so: vLookupMyField, or is it vMyField?

Thanks
MikeS

• This reply was modified 3 years, 2 months ago by MikeS.
• This reply was modified 3 years, 2 months ago by MikeS.

[MikeS]

Alexander,

I need to include a childTableCell column in the JS below for purposes of aggregating it in the PartDescriptionCombo field. However, I need to hide the same childTableCell column on the form (with CSS or JS I assume) as the user does not wish to view it. How could that be accomplished?

function vLookupIsLoadedCallback(fin) {
    if (fin === "vLookupParentRollup") {
        if (getFieldValue("RackCode") === "AA") { // Only run this for the parent item
            var arr = [];
            jQuery("#dffs_vLookupParentRollup .vLookupTableRow").each(function (i, row) {
                arr.push(jQuery(row).find(".childTableCell:eq(2)").text());
            });
            setFieldValue("PartDescriptionCombo", arr.join("|"));
        }
    }
}

Thanks for your help,
MikeS

• This reply was modified 3 years, 2 months ago by MikeS.

[MikeS]

Works great.

Thanks
MikeS

[MikeS]

Alexander,

I need to extend this excellent solution just a bit. How could I set up another SetFields and parseFunction that only concatenates the Title and the Serial No (excludes the mfrDate) to a separate multi-line text field called RackSNCombo?

Thanks
MikeS

[MikeS]

I did review that 2016 post during my research on your site. However, I was hoping there might be a way for DFFS to compare the last saved and current field values and then launch the SPD WF without user interaction when the form was saved – if the last saved and current values differ.

Alternatively, it appears that the combination of your 2016 article with the script:

var currValue = getFieldValue("TheFieldName");
var lastSavedValue = spjs.dffs.beforeProperties.TheFieldName;
if(currValue !== lastSavedValue){
   // Has changed
}

would trigger the WF upon pressing the button ONLY if the field has been changed. How would I combine this short script with the larger 2016 script – at the start?

Thanks
MikeS

• This reply was modified 3 years, 2 months ago by MikeS.
• This reply was modified 3 years, 2 months ago by MikeS.
• This reply was modified 3 years, 2 months ago by MikeS.

[MikeS]

Alexander,

I have a requirement to start a SPD WF based on changes in an OOTB multi-value lookup field. The WF would then manipulate other fields in that list (no email requirement). Is it possible for DFFS to compare a field pre-and post-edit (seems possible with some rules or Custom JS) and then trigger a SPD WF to run?

Thanks
MikeS

[MikeS]

Setup a new web part page and now all working.
Thanks
MikeS

[MikeS]

That nailed it! Works perfectly. The “if (getFieldValue(…” statement in the vLookupIsLoadedCallback function was instrumental.

Much appreciated,
MikeS

[MikeS]

Parent items are identified in two ways:

• Rack Code=AA
• Rack no includes the string “Parent”

Using your modified CAML query and adding the IsParent field (1=true) returns only the Parent record in vLookup for Parent or Children items. Both the Parent and the Children should be returned in vLookup for the Parent item.

MikeS

[MikeS]

Last two attachments

MikeS

Attachments:

1. 

   05-PARENT-EDIT-form.png
   

2. 

   06-CHILD-EDIT-form-PartDescriptionCombo-field-should-be-blank.png
   

[MikeS]

There are six screen shots attached that should help clarify the issue. The last screenshot of the CHILD should not run the vLookup and/or there should be no aggregation of content in the PartDescriptionCombo field. Only the PARENT should show CHILDREN and aggregate content in the PartDescriptionCombo field.

Thanks for your help,
MikeS

Attachments:

1. 

   01-List-view.png
   

2. 

   02-vLookup-config-1.png
   

3. 

   03-vLookup-config-2.png
   

4. 

   04-Custom-JS.png
   

[Author]

Posts