Attachments category in the Quickbase channel allows you to upload a file to an existing record in a Quickbase app, as a separate step in the pipeline.
For example, using the Upload a File action will allow you to lookup a file at a third-party source like Dropbox and upload the file from there. The Quickbase app you want to upload to will be need to be identified in a previous step in your pipeline for it to be available in the Record field of the Upload a File step.
Limitations
The maximum size of a single file attachment that can be uploaded is 30MB and the total for multiple files is 95MB.
Multiple revisions of attachments
Quickbase uses the version of the attachment that is currently being shown in the Record.
Required information
The following items are required when using the Upload a File step:
Record
Select a target record from the Quickbase base app defined in a previous step.
URL
Enter either the File Transfer Handle or a URL that is publicly accessible. Some channels like Box and Dropbox have a file_transfer_handle exported that can be used here.
Field
Add the name of the field, in the selected table, to upload to.
Name
The desired name of the file to appear in Quickbase.
Downloading a file
The file attachment fields are part of Search, Look Up, Create and Update Records. Once you select them, you can reference them through file section.
These attributes are exported:
-
File Transfer Handle - This is used to transfer file content across channels in Pipelines. It has no meaning outside of Pipelines pipeline execution context. Use this if you want to transfer files from, for example: Dropbox → QuickBase or vice versa.
-
Browser URL - This is the URL of the attachments. In the Quickbase Channel File attachment, they point to the original URL of the attachment. They may require authentication based on permission defined in Quickbase.
-
File Name - The name of the attachment
Use case examples
In the example below, whenever a file is uploaded to Dropbox, a record is added to Quickbase:
Deleting file attachments
In this use case example, see about using pipelines to delete file attachments.