[Todd Ingersoll]

This worked like a charm exactly as you described. I just hadn’t thought about getFieldValue().

[Todd Ingersoll]

Thanks for this Alexeander, I got the edit form working with your code (code below). My vLookup field is Batches, The field I am totaling is Dried_x0020_LBs.

You were correct in that the less modern vLookup code referenced in the other article above does not work with more recent ones, I have v2.2.84.

Would you happen to know how I can use this on the new form when the “.thisItemID” isn’t known yet?

//Wait until vLookup loads
function vLookupIsLoadedCallback(fin){
if(fin === "vLookupBatches"){
	//Get Total Pounds from vLookup
	var vLookupTotal = spjs.vLookup.dataObj["vLookupBatches"][spjs.dffs.data.thisItemID].tot["Dried_x0020_LBs"];
	setFieldValue('P1pounds',vLookupTotal);
}
}

[Todd Ingersoll]

I’ve seen this post: https://spjsblog.com/forums/topic/sum-multiple-vlookup-total-columns/, but just can’t seem to translate it into my simpler case. I just need some direction to help get going. I have the vLookup working just need to capture the total and save to list, should be simple I think. I will document this for other’s use as I think this is a strong use case.

• This reply was modified 6 years, 10 months ago by Todd Ingersoll.
• This reply was modified 6 years, 10 months ago by Todd Ingersoll.

[Todd Ingersoll]

I was able to get this to work using the classicoptions in the google reference above:

I have 3 options setup in the options tab:

series

{
    "0": {
        "targetAxisIndex": "0"
    },
    "1": {
        "type": "line"
    },
    "2": {
        "targetAxisIndex": "2"
    }
}

vAxes

{
    "0": {
        "title": "Pounds"
    },
    "2": {
        "title": "Downtime Hours"
    }
}

seriesType

bars

• This reply was modified 6 years, 11 months ago by Todd Ingersoll.

Attachments:

1. 

   dual-y.png
   

[Todd Ingersoll]

This is now working. Here’s what I have for Custom JS and I call when the Cascading Dropdown is chosen:

}
function convertStringToNumber(){
    var val = getFieldValue("TargetP1"), fVal = "";
    fVal = spjs.vLookup.formatNumber(val,{"decimals":0,"decimalSeparator":".","thousandsSeparator":","});
    setFieldValue("TargetNumP1",fVal);
}

[Todd Ingersoll]

Hey Alexander, would the above be possible with a vLookup? So, in your example, say the person was creating the products in the products list with a vLookup in the same form prior to adding them to the orders list (even though this is an unlikely scenario).

[Todd Ingersoll]

I got the error to go away as I noticed you referred to that function as setFieldValue (with a “ue”) in another post here. I cannot get it to display or set that field, however.

• This reply was modified 6 years, 12 months ago by Todd Ingersoll.

[Todd Ingersoll]

Thanks Alexander.
Is setFieldVal coming from somewhere else? I’m getting this error:

• This reply was modified 6 years, 12 months ago by Todd Ingersoll.

Attachments:

1. 

   error.png
   

[Todd Ingersoll]

1. I am successfully pulling in TargetP1 from a source list using the Cascading dropdown functionality. In the source list I am using a calculated column to convert a number I need to into text (because you don’t allow numbers to be used in the Cascading dropdown functionality). 2. Then I am attempting to convert the text to a number using a rule. This is where I can’t seem to find a way to display it with a thousands separator and no decimals in the New or Edit form. It displays properly in the view form (see the screenshot in my first post).

• This reply was modified 7 years ago by Todd Ingersoll.

Attachments:

1. 

   cascadingtexttonumber.png
   

[Todd Ingersoll]

So it appears to display a number correctly when an entry exists for the column on form load. But when entering data in the edit or new form, and using a cascading dropdown for instance, it does not display correctly until the data is saved to the list.

[Todd Ingersoll]

I’m using: Dynamic Forms for SharePoint DFFS Backend v4.4.2.9|CSS version: 4.21 / |spjs-utility version: 1.279

[Author]

Posts