Forum Discussion
Hello Aaron, I was able to do this with the help of a couple of pages of code and a table to control the status of the pipeline execution. But it is not a functionality that exists in quickbase.
Marcelo Benavides Torres
marbentor@gmail.com
------------------------------
Marcelo Benavides
------------------------------
- AaronB2 years agoQrew Trainee
Thanks for affirming this Marcelo.
------------------------------
Aaron B
ab1692@att.com
------------------------------- ChayceDuncan2 years agoQrew Captain
What specifically do you have the Pipeline doing? If you're able to go the code page route per Marcelo's comment - you can instead just have the code page handle the record creation and redirect to the new record upon completion. The Quickbase API will return the new record ID and a simple window.location.replace will take you there.
If the Pipeline is more complex and doing more than just creating the record you may need something more elegant, but if it's just an add record and redirect you can consider getting rid of the pipeline in favor of a simple code page.
------------------------------
Chayce Duncan
------------------------------- AaronB2 years agoQrew Trainee
Hi Chayce.
The pipeline gets triggered when a "Clone Data" formula URL button on a form gets pressed. The pipeline:
- Duplicates that record (i.e. Create Record, copying all data fields)
- Finds all child records (in another table) of the original record and also recreates them, associating them with the newly created parent record.
I already call a code page that simply pops up to tell the user a new record has been created but my API call skills are 'kindergarten level' at best so I have stuck with having the pipeline do the dirty work for now.
If you have a sample API call for:- Creating a new record
- Filling new/blank fields with data from the calling record
- Opening that new record in a form
......that would be a good start down this road. I'd deal with creating the child cloned records separately (probably in their own pipeline)
Thanks...Aaron
------------------------------
Aaron B
ab1692@att.com
------------------------------
- MarceloBenavide2 years agoQrew Cadet
Little video, The button executes a pipeline with many steps (complex) and even when the pipeline is finished I do the redirection.
------------------------------
Marcelo Benavides
------------------------------- AaronB2 years agoQrew Trainee
Wow! That's impressive. Thanks for sharing.
------------------------------
Aaron B
ab1692@att.com
------------------------------