I wish to be able to tell Datatable Lookup Mode to SKIP updating cells that already have values in them, especially if the datatable lookup value is blank.
In a "Lookup Mode" Datatable connection, when mapping Datatable fields, it would be very helpful if there were an additional column with a checkbox labeled "Update Empty Cells Only" or "Do not overwrite existing data", or even "SKIP BLANKS".
Why this would be helpful: I setup a lookup mode in my sheet. I find a cell that needs a correction made, so I change the value to the correct one. A few minutes later Datatable overwrites what I changed it to because it looks up the value once again. Even when the value is blank, it overwrites the existing value with a blank value, thus clearing the cell. I want to be able to tell Datatable not to overwrite existing values, for that specific column, or at least skip the value if the value it found was blank.
