On Add Row in Subform, Lookup field pre-fills automatically with data from previous row (unwanted behavior)
Today we are noticing that when we add a row to a subform, the first lookup field pre-fills automatically with the value entered in the first row of the same subform. Other fields in that row are scripted to auto-populate depending on the value chosen in the lookup field.
ex. given Row 1 Lookup field = X, several fields in row auto-populate according to a script using X as an input
Add row
Row 2 Lookup field pre-fills with X, incorrectly, auto-populates other fields incorrectly
That lookup field is typically unique from row to row of the subform, so X is 99% sure to be wrong, along with all the other incorrect, pre-filled values. This places the burden on us to be sure we fix the bad data every time.
If this is supposed to be an improvement, it is not. Please disable this feature. If I desired this behavior, I could have written a script to achieve it. I like Zoho because it gives me the tools needed to customize my users' experience, but more and more lately I am using those tools to create workarounds to combat the "improvements" being implemented by Zoho without my knowledge.