Forum Discussion
MarkShnier__You
Qrew Legend
3 years agoHere 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
------------------------------
VictoriaClark
3 years agoQrew Member
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
- Curtis_M2 years agoQrew Cadet
Hi all,
Has an updated version of this code been created so that it works on the new forms?
Thank you
------------------------------
Curtis Middleton
------------------------------- MarkShnier__You2 years ago
Qrew Legend
QuickBase released their own official multi file upload add on but I don't know if it works on new forms.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- TroyMacPherson2 years agoQrew Cadet
Can confirm - it does work with new forms!
------------------------------
Troy MacPherson
------------------------------