Forum Replies Created
-
AuthorPosts
-
March 28, 2023 at 17:16 in reply to: use value from lookup list as value for cascading dropdown #36610Jeff LynchParticipant
I added this code to the end of my custom JS and not getting anything to populate, could it be that CasePack is a number in both lookup list and parent list?
jQuery(“#dffs_Product select”).on(“change”, function(){
setTimeout(function(){
var value = jQuery(“#Product_CasePack”).text();
setFieldValue(“CasePack”, value);
},1000);
});where Product is the lookup column in the parent list and CasePack is a number field in both lists that I want copied over. also the parent list is a choice field so maybe change to a simple number field?
March 24, 2023 at 16:20 in reply to: use value from lookup list as value for cascading dropdown #36583Jeff LynchParticipantOh sorry – this is classic DFFS
March 23, 2023 at 21:46 in reply to: use value from lookup list as value for cascading dropdown #36573Jeff LynchParticipantThis illustrates it, under product I’m using your script to get values from lookup, in there we see the casepack is 12, but how can I get the filed CasePack to populate in this item so it will force the cascaded of less than full case? If I enter a number in the item casepack, the cascade works but I can’t get the value from the product into the orderitem.
Case pack does not have to be in the orderitem, it’s just convenient to use then to filter the less than full case dropdown. That works off of another list that has 2 columns,
Case Pack LessthanCasePack
6, 12 3
12, 18 6
12,18 9based on case pack = 12 my values are 3,6,9 which is correct and it works. the issue is that the 12 comes from the Product which is a lookup.
Attachments:
Jeff LynchParticipantNever Mind, I added an item and now it shows up…
Jeff LynchParticipantI seem to be having some issues. I see “Setup DFFS” in the ribbon but never after installing on all forms do I see configure dffs. I get some errors I’m not familiar with in the console (see attachment) but even on a new site, I have to run the fix script to get it to even render.
I’ve installed the latest version 4.4.5.45. I’ve disabled CDN, On the new site I also had to set DenyAddAndCustomizePages 0 to get it to install on the test list.
Certainly I’ve missed some basic thing but can’t figure it out.
Attachments:
Jeff LynchParticipantthank you sir!!!
Jeff LynchParticipantThank you for this help!!!! side note, I did not get any of these in email follow up even though I have it checked, I looked in spam, other and focused but nothing came from the dffs. thought you might want to know that.
Jeff LynchParticipantLet me see if I can clarify, everything seems close but we have some complications.
Parent List – we are using FullName as the Lookup in the child list – a simple SP Lookup field. In the parent list we also have Salary vs Hourly field – choice field with Hourly and Salary as the choices.
In the child list they first select the employee from the lookup, then what I want is to auto populate a field in the child form for salary/hourly with the value.
My first attempt was a cascading lookup on the child salary/hourly field based on the parent, but then when I try and use that value with a rule it doesn’t work because when you debug it is actually returning the ID of the parent item, not the value of salary or hourly.
so if I can have a value that is set when you select an employee in the child list that I can use for rules to display hide various fields thats what I need. make sense?
Jeff LynchParticipantthis code worked!!! Thank you!
Jeff LynchParticipantit’s inserting the commas at the thousand spot, then interprets those as decimals. As a temporary fix I created a calculated field and added them all together.
As a test I removed the commas in the edit form and when I did that it calculates the sum correctly.
Jeff LynchParticipantthank you, that’s what I suspected.
Jeff LynchParticipantI would like to be able to add a folder or subfolder and then automatically upload to that folder, or choose a subfolder.
When i leave the upload to this folder field blank i do not get a choice of folders as the help icon indicates. how can this be achieved?Jeff LynchParticipantonly change is on the first two message strings add \n to the end for a new line.
Jeff LynchParticipantFinal solution – save New Form and continue on to Edit form with dffs special feature, then use this code to build the error message:
function dffs_PreSaveAction(){
var hasChildren = false;
var hasChildren1 = false;
var hasChildren2 = false;
var message=””;if(spjs.vLookup.dataObj[“vLookupItems”] !== undefined && spjs.vLookup.dataObj[“vLookupItems”][spjs.dffs.data.thisItemID] !== undefined && spjs.vLookup.dataObj[“vLookupItems”][spjs.dffs.data.thisItemID].count > 0){
hasChildren = true;
}
if(spjs.vLookup.dataObj[“vLookupW9”] !== undefined && spjs.vLookup.dataObj[“vLookupW9”][spjs.dffs.data.thisItemID] !== undefined && spjs.vLookup.dataObj[“vLookupW9”][spjs.dffs.data.thisItemID].count > 0){
hasChildren1 = true;
}
if(spjs.vLookup.dataObj[“vLookupContract”] !== undefined && spjs.vLookup.dataObj[“vLookupContract”][spjs.dffs.data.thisItemID] !== undefined && spjs.vLookup.dataObj[“vLookupContract”][spjs.dffs.data.thisItemID].count > 0){
hasChildren2 = true;
}
if(!hasChildren){
message += “You must add an Item to this request”;if(!hasChildren1){
message += “You must add the W9 to this request”;}
if(!hasChildren2){
message += “You must add the Contract to this request”;}
if (message != “”){
alert(message);
return false;}
return true;}
Jeff LynchParticipantOn testing the validation does not work on a New Form because it always returns spjs.vLookup.dataObj as undefined in a new form. It works in the edit for so I will have to have the user click create and continue editing on New Form it appears.
Is there a way to make it work on the new form? I would think it would be difficult.
-
AuthorPosts