Get Subform Index of field when it changes

追蹤

Casey Kolowinski

• 2020年04月01日 20:51

I have a Subform with a few fields in it. I'm trying to set something up where if field X changes, do a bunch of stuff in Custom JS.

The problem that I'm running into is that my custom JS doesn't seem to be able to handle running against the current row of the subform that I'm in.

So I need a way to tell what row of the subform field X is in when it changes, so that I can use that value in my subsequent code.

Anyone have any thoughts?

Thanks,

Casey

0

• 

  Casey Kolowinski

  • 2020年04月01日 21:12

  I solved my initial problem by just updating ALL rows with [*] but it doesn't actually solve my issue, it's just a good enough workaround that it doesn't break my form. So if anyone has any suggestions, I'm all ears.

  0

  評論操作 永久連結
• 

  sysberry GmbH

  • 2020年04月02日 09:13

  Hi Casey,

  you can try to trigger a rule from the subform where as a parameter you set "this". After that in JS code you can find in which row is this "this" is comming from and then work with that row.

  Regards

  Alexey

  1

  評論操作 永久連結
• 

  Casey Kolowinski

  • 2020年04月02日 13:35

  Hi sysberry GmbH,

  Thank you for taking the time to respond. I'm unsure how you are able to isolate just "this" as a parameter, or directly within the JS code. Do you perhaps have a screenshot or example that you could show?

  Thanks,

  Casey

  0

  評論操作 永久連結
• 

  Casey Kolowinski

  • 2020年04月02日 15:04

  I was able to throw together the below to get the index of the currently affected row:

  var thisField = $ctrl;
  var index;
  var curParent;
  var child;
  
  for (var i = 0; i < thisField.parents('.subFormContentRowChildWrapper').parents('.subFormContent').children('.subFormContentRow').length; i++)
  {
     curParent = thisField.parents('.subFormContentRowChildWrapper').parents('.subFormContent').children('.subFormContentRow')[i];
     child = $(curParent).find("#" + thisField[0].id);
     if (child.length !== 0)
        {
           index = i;
           break;
        }
  }
  
  

  • However, it didn't give me the correct behavior. It was "Successful" but didn't trigger the formula as expected when I tried to run the below:

   

  • NOTE: my workaround is to throw * inside the brackets on line 2 below and it works fine. Not sure why the indexed value doesn't work.

  var options = {};
  options.fieldId = 'sf_LineItems/rtfx_LineItemTotalXchange:[' + index + ']';
  eFormHelper.triggerFormula(options, function (result)
    {
    if (result.isSuccess) 
      {
      console.log(result.data); //logs the data holds the empty object
      }
    else 
      {
      console.log(result.error); // logs the hold exception object 
      }      
    });

  0

  評論操作 永久連結
• 

  Casey Kolowinski

  • 2020年04月02日 15:40

  UPDATE and solved!

  I didn't realize I could create an "options.rowIndex = index;" property. Doing this allowed me to take the brackets out of the FieldID option and it works as expected now.

  0

  評論操作 永久連結

請登入寫評論。