I’m wondering if anyone else finds the current Data Import tool frustrating when trying to update child table rows. I’m going to say now, I might even be using it wrong but from what I’ve experienced, if you select update then import the data it will clear all existing data in that child table and replace it with whatever is in that import file.
So let’s say I’m adding 1-2 more barcodes for approx. 300 items. I would first have to export the existing data to CSV, write a program to insert the new lines into the exported file. Then re-upload all the data.
Would it not make more sense to append the child table row when updating child table?
I’m looking forward to hearing your thoughts, or lecture that I’m doing this totally wrong