Forum Discussion
AaronB
2 years agoQrew Trainee
Thanks for putting so much thought into it. Much to digest here so I'll make some notes and give it a try.
Much appreciated.
------------------------------
Aaron B
ab1692@att.com
------------------------------
AaronB
2 years agoQrew Trainee
Mark,
After thinking about this a bit more, I am would like to try a simpler apprach. I have the logic figured out, I just don't know if Quickbase can make it happen.
Logic steps:
- Find all distinct values within the 'bucket' field from Table 1.
Accomplished via a Summary Report: Complete - Automatically populate Table 2 with the Summary Report data from step 1
Table 2 would now hold 1 record for each distinct 'bucket' value in Table 1 - Run a pipeline:
For each record in Table 2, find all the records in Table 1 with that same 'Bucket' value and kick out a .csv file for that specific bucket name.
I just don't know how to accomplish step 2. Any suggestions?
Thanks.
------------------------------
Aaron B
ab1692@att.com
------------------------------
- MarkShnier__You2 years ago
Qrew Legend
Right, finding the distinct values is the obstacle. Hence my suggested method. A Pipeline cannot see a Summary report.
Mark
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- AaronB2 years agoQrew Trainee
"A Pipeline cannot see a Summary report."
Thanks for confirming this is not an option.
------------------------------
Aaron B
ab1692@att.com
------------------------------