Todd Ingersoll

Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)
  • Author
    Posts
  • in reply to: Getting Total from vLookup #17187
    Todd Ingersoll
    Participant

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

      in reply to: Getting Total from vLookup #17143
      Todd Ingersoll
      Participant

        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);
        }
        }
        in reply to: Getting Total from vLookup #17037
        Todd Ingersoll
        Participant

          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.

          in reply to: Dual-Y Chart on a Column Chart #16753
          Todd Ingersoll
          Participant

            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
            Attachments:
            in reply to: Format #16676
            Todd Ingersoll
            Participant

              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
              Participant

                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).

                in reply to: Format #16599
                Todd Ingersoll
                Participant

                  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.

                  in reply to: Format #16595
                  Todd Ingersoll
                  Participant

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

                    error

                    Attachments:
                    in reply to: Format #16553
                    Todd Ingersoll
                    Participant

                      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).

                      in reply to: Format #16538
                      Todd Ingersoll
                      Participant

                        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.

                        in reply to: Format #16516
                        Todd Ingersoll
                        Participant

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

                        Viewing 11 posts - 1 through 11 (of 11 total)