302 Found

Found

The document has moved here.

Knowledge Base

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. Please read the following help topic:

https://www.quickbase.com/help/importing_data.html

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.

To learn more about changing the key field please read the following:

https://www.quickbase.com/help/setting_the_key_field.html

Comments

I want to add new button on Intuit Quickbase Application

I want to add a new button on Intuit Quickbase Application which will take data from xls file..

 

 

please guide me

some suggestions

Hi --

Importing from an Excel file into QuickBase is a manual process; you can't just click a button to do that kind of import. However, you do have a couple of options, depending on your particular circumstances:

- You could put a link that points to "https://www.quickbase.com/db/<dbid>?a=importexport" on the dashboard of the app, replacing <dbid> with your app's dbid. Click the link to start the import process. 

- You could choose to import from CSV instead, and use the API_ImportfromCSV API to automatically import your data.

If neither of these options work for you, please contact Customer Support to get further help.

Regards,

--S.

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.
302 Found

Found

The document has moved here.