I currently have a Quick Base Action set up that does the following:
- Creates a new record in a different table when a certain box is checked
- Copies several fields from the original record to the new record
How can I get this to also copy a file attachment to the new record, whether using Quick Base Actions, Webhooks, Formula fields, or anything else? I cannot seem to find a solution to this exact scenario.
Question
Using Quick Base Action to copy file attachment
This topic has been closed for replies.
That cannot be done by mere mortals. You would actually need to engage with a Quick Base Solution provider to do that.
But how about just putting a link on the new record.
The formula for such a link would be
URLRoot() & "up/" & [_DBID_my table name where the file] & "/a/r" & [Record ID# of the record with the file] & "/e30/v0"
Change the e30 to exx where xx is the field ID holding the file.
But how about just putting a link on the new record.
The formula for such a link would be
URLRoot() & "up/" & [_DBID_my table name where the file] & "/a/r" & [Record ID# of the record with the file] & "/e30/v0"
Change the e30 to exx where xx is the field ID holding the file.
I thought I was going to get away with not doing this, but I have rolled out my Quickbase app at my company and not so much.
For some reason I cannot wrap my head around this formula. Am I putting this in as Formula - URL or some other type?
For some reason I cannot wrap my head around this formula. Am I putting this in as Formula - URL or some other type?
Ok so I am confused about the [Record ID# of the record with the file] part of the formula. It would need to copy a different record each time, so this doesn't seem like it would work?
Each record in the destination table would need to have a link to a corresponding record in the original table, but they will be different attachments for every record.
Is this possible? Or is the only way to do this manually in every record?
Each record in the destination table would need to have a link to a corresponding record in the original table, but they will be different attachments for every record.
Is this possible? Or is the only way to do this manually in every record?
How To Copy File Attachments Between Tables Without Download?
https://community.quickbase.com/quickbase/topics/how-to-copy-file-attachments-between-tables-without...
https://community.quickbase.com/quickbase/topics/how-to-copy-file-attachments-between-tables-without...
I am trying to access the related record's attachment with Zapier. A URL to the related record's attachment does not let Zapier pull the attachment properly. Any thoughts on how to do this? If I could copy the attachment when creating the new record it would not be a problem.
+7Hi Chelsea/Jeff,
we have a file attachment sweep add-on that will do exactly what you are looking for. It can sweep the file from a record in one table and either update a record in another table or add a new record into the table. It will also either move into the other table or just copy it if you want it in 2 places.
You can demo it here: https://juicedtech.quickbase.com/db/bmzi5qjk7
When a new record is added, the sweep process can:
Keith
we have a file attachment sweep add-on that will do exactly what you are looking for. It can sweep the file from a record in one table and either update a record in another table or add a new record into the table. It will also either move into the other table or just copy it if you want it in 2 places.
You can demo it here: https://juicedtech.quickbase.com/db/bmzi5qjk7
When a new record is added, the sweep process can:
- Sweep the file and DELETE it from the record
- Sweep the file and KEEP the original file on the record
Keith
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.