- SeaTable Cloud
What I am trying to do is make the ‘Update data from xlsx or csv file’ process not only ‘add’ lines but also ‘remove’ lines. Meaning if my new file has lines missing from point of view of the old file, those files would have to be deleted from the old file.
For Context:
I have tabs/sheets containing information on inventory/contracts. They are feeding into another base via ‘common dataset’. Every other month I will receive a .csv file, which displays the current state of inventory/contracts. Some items/contracts will have ended/been removed, new ones added, most will stay the same.
My plan was to use ‘Update data from xlsx or csv file’ to update the tab/sheet, which is shared as a common dataset.
In terms of ‘adding’ the lines, ‘Update data from xlsx or csv file’ does exactly what I want.
But as far as I can tell seatable considers ‘updating’ to be adding lines only.
I would also need to have lines no longer existing in the new .csv file removed from the tab/sheet that needs updating.
It feels that I am so close, but I can’t find an option to make the process do that little bit extra and I could not find an entry in the forum covering a solution for what I want.
