Hey Community! First time posting here
I have a module that reads three .XLS files, and I want to see the information on a Coda table:
Everything works fine, the file is formatted as a spreadsheet, I select the columns that I need and change their name to match Coda column’s name.
What I don’t know how to do is to only read NEW rows. Every column has an ID, the same for “Albaranes” and “Nº Clientes” and a different one for “Clientes”.
The first two .XLS files get updated all the time, the third one rarely gets updated but I also need to see if there are new rows there.
Is there any way of checking if the ID from a row is > than the last one that was added, and only add the new one?
Thanks in advance, and sorry if it’s very easy but I’m new