Pipelines | Dropbox & Webhooks assist.
Goal: Utilize a third-party file storage service due to the economics of storing photos on Quickbase, but still maintain the ability to display the photos in a notification email. Method: Using pi...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOne solution is to implement the add on for the Juiced storage on Amazon S3. The Amazon cost is very trivial https://aws.amazon.com/s3/pricing/ . There is a nominal monthly cost for the Juiced add on. They also have a different add on which allows for multi file upload. It can let you browse to your file source, grab a bunch by dragging or highlight them and then click to create multiple child records each with a file attachment or liked into Amazon S3.
http://qbtools.helpdocsonline.com/amazon-s3-overview
http://qbtools.helpdocsonline.com/amazon-s3-multifile-overview
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
http://qbtools.helpdocsonline.com/amazon-s3-overview
http://qbtools.helpdocsonline.com/amazon-s3-multifile-overview
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Here's my biggest wrinkle to third-party uploaders: It's gotta work on the mobile app. I actually got the dropbox chooser/saver buttons and scripts to work in the forms from desktop, but they break mobile hard.
------------------------------
Brad Lemke
------------------------------ - After bashing my face against the brick wall for another several hours, I finally got the command to not only go through - but also succeed at making the change I needed in Dropbox while providing the information I need (the share link) in its' response. Now I'm at an unexpected roadblock: how do I use the information provided in the response?
It feels like I'm wading through super-uncharted territory on this one.
------------------------------
Brad Lemke
------------------------------- Pipelines is pretty much brand new so you basically are the first one I've seen do this.
I don't have the dropbox plugin enabled but do you have the ability in the Pipeline to update a record after receiving the response? You should be able to add that in as another step at the end. Or is the issue with parsing the response?- Update: I got everything operating incredibly smooth and efficient now. Here's the Pipelines steps:
A - Trigger - Quickbase Channel - Record Created - Inspection photos table (one photo=one record)
B - Action - Dropbox Channel - Upload a file - using the photo's url from the record
C - Action - JSON Handler Channel - Fetch JSON - Execute Dropbox API command previously set up in Webhook channel
D - Query - JSON Handler Channel - Iterate over JSON records - Enter sample JSON Response into 'Schema Sample' - This lets you pull and use data from the response to the previous step!
E - Action - Quickbase Channel - Update record with the URL in step D, and the file ID from step B (into their own unique fields).
Next, I created a standalone webhook that will delete the file from Quickbase once the Dropbox URL field is filled in.
Lastly, I created a Rich-Text Formula field that modifies the Dropbox URL into an embeddable format (removing dl=0 from the end and adding raw=1).
And voila - my app now has virtually unlimited attachment space with no attachment management upkeep, all while using the mobile user-interface without intruding on existing workflows. All this allows my app to use the 'email notification' feature to send the attachments (in addition to the rest of the report) to our customer the instant the inspection is completed on-site and not a day or two later after being processed in the office.
------------------------------
Brad Lemke
------------------------------
