Forum Discussion
MarkShnier__You
Qrew Champion
One 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
------------------------------
BradLemke
5 years agoQrew Assistant Captain
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
------------------------------
It feels like I'm wading through super-uncharted territory on this one.
------------------------------
Brad Lemke
------------------------------
- AustinK5 years agoQrew CommanderPipelines 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?- BradLemke5 years agoQrew Assistant CaptainUpdate: 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
------------------------------- MarkShnier__You5 years agoQrew ChampionThank you posting,
BTW, that Pipeline setup you did is exportable as YAML. The recipients (or yourself using this technique in a different app), would edit the references to the Quick Base table IDs and the field numbers.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- BradLemke5 years agoQrew Assistant CaptainIt appears to be an issue with parsing the response. Here's the steps of the pipeline so far:
Trigger - Quickbase Channel - record created
Action - Dropbox Channel - Upload a File
Action - Webhook Channel - Make request: Create Shared Link for Uploaded file.
The link is located in the response, but I'm unable to pull anything from the response into later steps.
------------------------------
Brad Lemke
------------------------------