Hi there, 

We use Ninox database to manage temporary items. Each day we received parcels (like undelivered UPS or FedEx parcels), and head company ask us to keep them 5 opening days for customers pickup. I need to easily know since how many days we have them here. Sometimes we keep some parcels longer, if customers ask for it. 

=> Calculate from how many days we have those parcels here <=

Right now, each day I manually update a Selection field with those choices: Reception, 1st, 2nd, 3 4 5, and Return to sender". But it starts to take a lot of time to update everyday this field when know this is something that could be easily be automatized. But how!? Right now, I use "Modification en Bloc" (Batch Update/Modification in english?) to take all parcel tagged the same day and change them for the next day. At least, I don't have to do them one by one. 

So right now I have two choices: 

1- Create an automation that will update my existing selection field when I do my daily update

2- Create a function who will calculate "today - reception date", but will also care to remove W-E days, and holidays

=> Imported CSV duplicatas <=

I'm also wondering why, when I try to import the daily CSV file from company website with my updated parcels, Ninox always create new entries for ALL of them. I'm supposed to be able to update existing entries (ex: we moved a parcel from shelf C 1 to A 4), but I always have duplicate entries no matter if i asked Ninox to only update existing lines, or any other "option" available. For now, I use a function I found on this forum to separate all duplicate files, take look at them one by one to find with parcels we moved (it could be long, sometimes!!). After that, I deleted all duplicatas, and entry left in system are new parcels we received...

With those 2 "problems"... So many steps when it could be easily be A LOT faster! 

Please note i'm a native French (Quebec) speaker, so my Ninox is in french. Sometimes functions are not literally translated. I also have a "micro" bit of html/css/php knowledge, so I created by myself a lot of if/elseif functions in my database. But clearly this is not enough or appropriate for what I needed to do right now. 

Thanks a lot! :)