We use a table to keep track of devices. One field is the serial number of the device (Unique). Another field is the date the device was last seen on the network. This date is exported from another app, and saved in a .CSV file. How can I update the Last Seen" field with the new date?
Thank you for the quick responses. They are good ideas, and the other app is a non-QuickBase app (so, no direct relationship...). I have no problems Importing from a file or the clipboard when I want to create new recordsin a table. The problem is that QuickBase wants to create a new record instead of overwriting the existing "Last Seen" field - even when I have set the, unique, Serial Number as a key field. I have even tried importing where those are the only two fields being imported, and it still wants to create new records. Of course, it can't since the Serial Number is set as Unique. It gives me errors stating that the serial number already exists. Is there a way to keep it from trying to create new records every time? A setting that I'm missing?