ContributionsMost RecentMost LikesSolutionsRe: Bulk Record Sets in PipelinesHi Mark. Would this process be any different in reverse? As in, the trigger is on a child record, and then I'd like to trigger a search of parent records, and then create records for each parent record *not* returned in the search. My existing pipeline (not using bulk upsert) was flagged and shut down for excessive use today when bulk importing historical data. Seems like I need to find a less intensive method. ------------------------------ Ken Hillyer I support people who cure cancer Alliance for Clinical Trials in Oncology Foundation Boston, MA ------------------------------ Create a field that incrementally counts based on unique values in another fieldI have a situation where I'd like to automatically create sequential [invoice] numbers in a parent table based a [new,] unique value in a child table. If I was interested in approaching this using QB System Variable(s) and/or Javascript/Formula-RTF (I am a novice in both), how would I go about this? Thanks in advance ------------------------------ Ken Hillyer I support people who cure cancer Alliance for Clinical Trials in Oncology Foundation Boston, MA ------------------------------ Box CSV connected table - unexpected issueSo I was trying out the CSV connected table functionality with Box. As I was getting a feel for how things flowed through my app and testing different fields for the 4 Refresh Key criteria, I went through a few cycles of deleting the records in the connected table, and moving the previously imported CSV files from "Done" back to the main folder for further import testing. [For additional context, this app has a secondary table which uses a Quick Base Action to automatically copy new records from the connected table to the second table based on a another set of filter criteria.] After ~2-3 rounds of the above debugging/testing the process, QB started processing the CSV files as expected - the relevant/expected records were copied from the connected table to the secondary table perfectly, and QB moved the CSV file to the Done folder when complete, BUT the connected table did not display ANY records. I did see as the page was refreshing that QB would briefly flash to the expected record count in the linked table and then ultimately show 0 once the page was fully loaded. What could be causing this? Only thing I can think of is the version control feature in Box still having a deleted version of the import CSV files in one of the QB folders, but that doesn't quite explain it. Please advise ------------------------------ Ken Hillyer ------------------------------ Box CSV connected table - unexpected issueSo I was trying out the CSV connected table functionality with Box. As I was getting a feel for how things flowed through my app and testing different fields for the 4 Refresh Key criteria, I went through a few cycles of deleting the records in the connected table, and moving the previously imported CSV files from "Done" back to the main folder for further import testing. [For additional context, this app has a secondary table which uses a Quick Base Action to automatically copy new records from the connected table to the second table based on a another set of filter criteria.] After ~2-3 rounds of the above debugging/testing the process, QB started processing the CSV files as expected - the relevant/expected records were copied from the connected table to the secondary table perfectly, and QB moved the CSV file to the Done folder when complete, BUT the connected table did not display ANY records. I did see as the page was refreshing that QB would briefly flash to the expected record count in the linked table and then ultimately show 0 once the page was fully loaded. What could be causing this? Only thing I can think of is the version control feature in Box still having a deleted version of the import CSV files in one of the QB folders, but that doesn't quite explain it. Please advise ------------------------------ Ken Hillyer ------------------------------