ContributionsMost RecentMost LikesSolutionsRe: can a quickbase show on the dashboard a comparison bar chart from 2 tables in the same app?I was thinking that I might have to do that. I do not currently have both tables linked to a 3rd table.The Devicetables *is* linked to another one, but that's for a different purpose. The Allocation table is not linked to anything at this time. The one table that shows the devices allocated just has the Department Name, Contact Person, Device Name Example (this shows anyone creating a new device how to name it), and the Number of Devices they should have. The other table is a list of every device, Serial Numbers (2 different kinds), Asset Tag number, Device Name, Hardware Address, Location, Last Seen, and 22 more fields that don't really mean anything for this purpose. I'm thinking that I would have to create the 3rd table (AllocatedVsActual)that is linked to the Allocation table's Department Nameand Device Name Example, and create a formula that links to the Device List table to count the number of devices with a similar name. Then, Iguess I wouldcreate a report that will show both sets of numbers on the from the AllocatedVsActual table on the dashboard?can a quickbase show on the dashboard a comparison bar chart from 2 tables in the same app?I have 2 tables in one app. One tables shows how many devices are allocated to each department (i.e. How many they should have). The other table shows how many devicesthey actually havein each department (some may be missing due to repairs, lost, etc.). I want to create a bar chart on the dashboard that shows the comparison of the 2 numbers. It can be a side-by-side bar chart, or a bar line chart. Is that possible?Re: How to mass update one field in an existing tableOK.... I'm a little embarrassed. Turns out that I had *not* set the Serial Number as the Key Field. I thought I was doing it, but it wasn't correct. I finally got it set, and it's working as advertised. I also checked my .CSV file for leading/trailing spaces, and it's clear (good idea, Avi). Thank you all for your help.Re: How to mass update one field in an existing tableThanks, Avi. Please check my 2nd post. I have set "Serial Number" as the key field. I have also tried using the record number as the key field.QuickBase gave me the same response - it tried to create new records, but couldn't since they are unique. I'm thinking there is some setting that I'm missing that allows imports to overwrite existing data instead of creating new records. I just can't find that setting. I can export the records from QuickBase and the other app to .CSV files, make the changes to the 1000+ records, and import the records back to QuickBase after deleting all of the records in the table, but that seems inefficient to me. I'm looking for a more direct approach so the data is updated in the field in QuickBase without having to delete and "restore" all of the records.Re: How to mass update one field in an existing table 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 QuickBasewants 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? Thank You. How to mass update one field in an existing table 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 theLast Seen" field withthe new date?