Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.
How do I update a field (column) across numerous records in my database from a CSV file? In other words how do I do an update query in QuickBase?
If your CSV file has a column in it that maps to the key field of the table then all you have to do is import the CSV file into QuickBase. To learn more, please see our Import Data from Outside QuickBase help topic.
If your CSV file doesn't have a column that maps to the key field in QuickBase, but it does have a column that maps to a unique field in your QuickBase table then you can temporarily or permanently switch the QuickBase key field to the unique field to do your update via import. For more information, please see our Set the Key Field of a Table help topic.