I’m using a power table on a data entry form where users input data in a couple of columns, then hit a submit button and it moves it to SQL. I’m having an issue with some of my users where they enter in a value into the last cell of the form, and they do not hit enter or click into any other component. So from the user’s perspective it appears the value is correct. But then when they click submit it submits a 0 or Null value because they power table value change never actually happened.
Is there a way to force this value “accept” on the submit button or on the mouseExited function or something? I tried changing Selected Column and Selected Row to -1 on mouseExited, but this did not solve the problem (cell still shows 123 but real value is Null). Or any tricky ways I can get around this without just giving the user an error for submitting a Null value?