Hi all,

I have a stored procedure that works when I execute it in SQL, but isn't working in LF Forms. I am thinking it's because I need to trigger a change event to have it run, but I'm really not sure. The inputs for the stored procedure are #q25 (css class "relabel") and then a repeatable row with the column id of #q2 (css class "LN"). How would I go about getting this stored procedure to run?

Images below:

Thanks!

edit: I figured out the issue: I was hiding the autofill but which stopped the stored procedure from running. To fix this I added this to CSS:

.autofill {display: none;}

and this to the JavaScript section:

$(document).ready(function () {
  
   function autofill() {
    $('.autofill').trigger('click');
  } 
  
  $('.lookupCondition').change(autofill);
  
});

The .lookupcondition is the css class for the inputs for the stored procedure