I have a data entry form with some controls, and then an editable list
the editable list has 2 fields for data entry
if i add rows, and add data correctly,and press submit,my data is entered correctly into SQL
if i enter data correctly,and then if i add a row by mistake, and not add any data to the fields. i press submit, and my data saves, but my correctly entered line of data doesn't get updated into SQL correctly
i have 2 attachments to show the entry form
with 1 entry set, and then a blank line
the 2nd attachment shows SQL not saving the data correctly
How is the rule on your submit button configured?
Perhaps SmartObject logging can be enabled to see what is happening:
Maybe it is not passing in the input at all. Or writing the data from the first row, and then wiping it out from the second row. This is likely a behavior of how the rules are configured or how the SmartObject/Create/Save method was implemented, as I do not see a similar behavior when generating an Editable List view from a simple SmartBox SmartObject. If so, likely we will need to revise how the rules are configured or methods are implemented.
i configure it to enter all data needed into the SMO
In a generated editable list view (as an example), there is also a rule that indicates:
When the view executed 'List item added'
then apply the changes made to the row on the editable list
Please try adding a similar rule on the View or on the Form, so see if it will handle the empty row case more correctly.
hi, i do have that rule on my view
It looks like the "then apply the changes made to the row on the editable list" action will only be executed if it meets the advanced condition.
As a possible test, please also add this same rule to the 'else' block to see if the behavior changes or not; this would tell us if it is related to this rule.