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 button and the html code page and make it your own for your QuickBase application. We cover topics, questions and answers like this in our daily M-F "Office Hours" webinars held at 1pm Eastern time. All are welcome. http://quickbase.com/webinars/ ------------------------------ Kirk Trachy , Senior Solutions Consultant QuickBase | 603-674-5454 M | ktrachy@quickbase.com ------------------------------
Use API to delete entire file attachment history
This question is a follow-up to: https://community.quickbase.com/quickbase/topics/delete-file-attachment-with-api-editrecord. It concerns the use of API_EditRecord to delete attached files from records. Inspired by the final answer to the aforementioned question, I have been sending out requests with these parameters: <rid>[rid]</rid> <field fid="18" filename="delete"></field> <field fid="24" filename="delete"></field> This works perfectly well, except for not actually deleting any files. What I get are empty fields whose revision histories now have "(deleted by user)" at the top, with all previous revisions still available and taking up space. Is there really no way of actually deleting file attachments through the API? While I would prefer a nuke-all option of removing the entire history at once, I'm also open to doing it revision by revision. I looked at the API reference and couldn't find anything, so I'm nervous that this is just not possible, but I thought I'd ask just to be safe.
Upload file in File Attachment field using add record fail
Hi Dandiebolt, I have to read any type of file (i.e. PDF, ms office files) from my file system (windows server) and add them to file attachment field into a quickbase table. I use javascript (node.js) to read a file with base64 encoding(as quickbase requires files to have base64 encoding) and use http post method (API_AddRecord) to upload the file. I have made the field as Mandatory (just to ensure the content is there). I always get error that "Sorry, you didnot supply a value for the required field.... Please provide a non blank value". I fail to understand that when my console.log is showing value (first line in uploadfiletoqb method), why API is complaining about the field being blank! I feel I am wrong somewhere which i am not able to comprehend! Can some one please please help !!! Here is my code : var http = require('https'); var request = require('request'); // npm install request var fs = require("fs"); var buf = new Buffer(1024); console.log("Going to open an existing file"); var readStream = fs.createReadStream('d:\\MyData\\MyNode.js\\Certificates\\b.pdf',{ encoding: 'base64' }); readStream.on('data', function (chunk) { buf += chunk; console.log("read data 11 "+buf.length); }) readStream.on('end', function () { console.log("read data "+buf.length); uploadfiletoqb(buf); }); function uploadfiletoqb(buf1) { console.log("encoded file"+buf1); var xml = '<qdbapi><udata>mydata</udata><field fid="6" filename="b.pdf">'+buf1+'</field></qdbqpi>'; console.log("-----"); //console.log(xml); console.log("-----"); request({ url : "https://sssss.quickbase.com/db/bm3uve9ig?act=API_AddRecord&username=xxxx@yyyyy.com&password=...;, method: "POST", //headers: { //"content-type": "text/xml" //}, body:xml }, function (err, remoteResponse, remotebody){ if (err) {console.log("error"+remoteResponse+" -- "+err); } console.log("ok "+remoteResponse +" "+remotebody); }); } would appreciate help!!!! thanks & regards dinesh
Is there a way to edit documents within Quick Base rather than downloading and re-uploading?
I am really needing a better (more user friendly) way to edit and update attachments in QuickBase. A way that doesn?t require downloading and uploading new versions. Ideally, I would like to be able to open a document (MS Word or Excel), simply click ?edit?, make the edits, then click ?save?. Are you aware of any add-ons or other ways we might be able to accomplish this? I looked through the add-ons marketed on the QB site and found several related to attachments, S3 and BOX, but not sure that any do what I am hoping to have. Thanks everyone for your help
Is there a way to force all photo file attachments to display vertically?
Title says it all. Currently I have users uploading photos off their phones but im running into an issue where some of the photos are displaying horizontally. Is there an easy way to either force all photos to display vertically or letting users set the orientation of the photo? My current Richtext formula field is as follows: "<div><img src=\""&URLRoot()&"up/"& Dbid() & "/a/r"& [Record ID] &"/exx/v0\" height=400;width=400;></div>" I did foolishly tried rotate=90; but...yea thats not a thing hahaCreate Upload Button
Is there a way to make a button that brings up a File Explorer window to upload an attachment to a specific attachment field? Currently, I have a button that is able to simply cause the form to go into edit mode, but that is it. I know it is pretty simple to just hit the "Edit" button and then scroll back down to wherever and hit the "Choose File" button that quickbase gives you, but it would be easier to just click the User made button that quickens that whole process. Any thoughts?
