Forum Replies Created
-
AuthorPosts
-
MikeS
ParticipantI 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
ParticipantYes, 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, 3 months ago by
MikeS.
MikeS
ParticipantAlexander,
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
MikeSAttachments:
MikeS
ParticipantThank you! This works perfectly.
MikeSMikeS
ParticipantAlexander,
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
MikeSMikeS
ParticipantAlexander,
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, 5 months ago by
MikeS.
February 18, 2021 at 23:53 in reply to: Concatenate and Write Cascading Dropdown Selections to Text Field #32802MikeS
ParticipantWorks great.
Thanks
MikeSFebruary 12, 2021 at 23:34 in reply to: Concatenate and Write Cascading Dropdown Selections to Text Field #32784MikeS
ParticipantAlexander,
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
MikeSMikeS
ParticipantI 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
MikeSMikeS
ParticipantAlexander,
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
MikeSMikeS
ParticipantSetup a new web part page and now all working.
Thanks
MikeSMikeS
ParticipantThat nailed it! Works perfectly. The “if (getFieldValue(…” statement in the vLookupIsLoadedCallback function was instrumental.
Much appreciated,
MikeSMikeS
ParticipantParent 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
ParticipantLast two attachments
MikeS
MikeS
ParticipantThere 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 -
This reply was modified 3 years, 3 months ago by
-
AuthorPosts