Upload Multiple File Attachments to QuickBase
You can create a button that allows you to add and link multiple file attachments at once to QuickBase. By getting a copy of the "Magic Buttons" app from the QuickBase Exchange you can copy the bu...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHere is a working example of the formula URL button which works with the script which is stored in page ID = 4. Did you put this field on our form?
var text URL = URLRoot() & "db/"&Dbid() & "?a=dbpage&pageID=4&refFid=7&rid=" & [Record ID#]
& "&fileattachment=36"
& "&attachmenttableurl=" & URLRoot() & "db/" & [_DBID_EXPENSE_FORM_LINES];
If(IsNull([Date Submitted and Locked]), $URL)
// NOTE: We have updated the button so you only need to update this button's code.
// If you are looking at the video it may suggest you edit the UploadMultipleDocuments.html page but we have updated the button so all changes and updates can be made here and passed down into the page.
// First copy the UploadMultipleDocuments.html file located in this app's "Pages" and add it to your new application's "Pages". Make note of your page's new pageID.
// Then edit the above code to reflect the following updates:
// The pageID number of your UploadMultipleDocuments.html page.
// The refFid number to reflect the related reference field's fid.
// Your application's app token.
// The fid of your destination file attachment field.
// The table alias of the destination table where you are placing the file attachments.
//
// All these values will be passed to the UploadMultipleDocuments.html page when you press the button.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var text URL = URLRoot() & "db/"&Dbid() & "?a=dbpage&pageID=4&refFid=7&rid=" & [Record ID#]
& "&fileattachment=36"
& "&attachmenttableurl=" & URLRoot() & "db/" & [_DBID_EXPENSE_FORM_LINES];
If(IsNull([Date Submitted and Locked]), $URL)
// NOTE: We have updated the button so you only need to update this button's code.
// If you are looking at the video it may suggest you edit the UploadMultipleDocuments.html page but we have updated the button so all changes and updates can be made here and passed down into the page.
// First copy the UploadMultipleDocuments.html file located in this app's "Pages" and add it to your new application's "Pages". Make note of your page's new pageID.
// Then edit the above code to reflect the following updates:
// The pageID number of your UploadMultipleDocuments.html page.
// The refFid number to reflect the related reference field's fid.
// Your application's app token.
// The fid of your destination file attachment field.
// The table alias of the destination table where you are placing the file attachments.
//
// All these values will be passed to the UploadMultipleDocuments.html page when you press the button.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Hi Mark,
Thank you for replying!
Original Message:
Sent: 05-22-2022 08:29
From: Mark Shnier (YQC)
Subject: Upload Multiple File Attachments to QuickBase
Here is a working example of the formula URL button which works with the script which is stored in page ID = 4. Did you put this field on our form?
var text URL = URLRoot() & "db/"&Dbid() & "?a=dbpage&pageID=4&refFid=7&rid=" & [Record ID#]
& "&fileattachment=36"
& "&attachmenttableurl=" & URLRoot() & "db/" & [_DBID_EXPENSE_FORM_LINES];
If(IsNull([Date Submitted and Locked]), $URL)
// NOTE: We have updated the button so you only need to update this button's code.
// If you are looking at the video it may suggest you edit the UploadMultipleDocuments.html page but we have updated the button so all changes and updates can be made here and passed down into the page.
// First copy the UploadMultipleDocuments.html file located in this app's "Pages" and add it to your new application's "Pages". Make note of your page's new pageID.
// Then edit the above code to reflect the following updates:
// The pageID number of your UploadMultipleDocuments.html page.
// The refFid number to reflect the related reference field's fid.
// Your application's app token.
// The fid of your destination file attachment field.
// The table alias of the destination table where you are placing the file attachments.
//
// All these values will be passed to the UploadMultipleDocuments.html page when you press the button.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
Thank you for replying!
Original Message:
Sent: 05-22-2022 08:29
From: Mark Shnier (YQC)
Subject: Upload Multiple File Attachments to QuickBase
Here is a working example of the formula URL button which works with the script which is stored in page ID = 4. Did you put this field on our form?
var text URL = URLRoot() & "db/"&Dbid() & "?a=dbpage&pageID=4&refFid=7&rid=" & [Record ID#]
& "&fileattachment=36"
& "&attachmenttableurl=" & URLRoot() & "db/" & [_DBID_EXPENSE_FORM_LINES];
If(IsNull([Date Submitted and Locked]), $URL)
// NOTE: We have updated the button so you only need to update this button's code.
// If you are looking at the video it may suggest you edit the UploadMultipleDocuments.html page but we have updated the button so all changes and updates can be made here and passed down into the page.
// First copy the UploadMultipleDocuments.html file located in this app's "Pages" and add it to your new application's "Pages". Make note of your page's new pageID.
// Then edit the above code to reflect the following updates:
// The pageID number of your UploadMultipleDocuments.html page.
// The refFid number to reflect the related reference field's fid.
// Your application's app token.
// The fid of your destination file attachment field.
// The table alias of the destination table where you are placing the file attachments.
//
// All these values will be passed to the UploadMultipleDocuments.html page when you press the button.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com