I've been researching and trying to create a table for my needs but having problems and doubting if this is possible with Airtable.
I'm importing a csv/google sheets everyday with ID, date and amount fields. What I'm trying to achieve is, import another csv, if there is a matching ID, it's date and value fields should be added to their relevant fields instead of overwriting any previous values.
ID1 should have both 09/12 date and 500 amount should be linked, in addition to 10/12 date and 1000 amount getting linked too.
And be able to see an IDs amount on a chosen date and also able to sort for last weeks IDs with the highest amounts.
I'd really appreciate if someone can briefly explain the method I should be using or if this is possible at all. Thanks!