Create a record using a Pipeline, then automatically open a Form containing that new record

Question

I have a button that triggers a pipeline.
The pipeline creates a new record.
Is there a way to automatically open a form with that new record when the pipeline is finished?
I have searched this forum and the internet in general without finding anything that makes it look like this is possible.&nbsp;------------------------------Aaron Bab1692@att.com------------------------------

marcelobenavide · Answer

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------------------------------

aaronb · Answer

Thanks for affirming this Marcelo.&nbsp;------------------------------Aaron Bab1692@att.com------------------------------

chayceduncan · Answer

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.&nbsp;

------------------------------Chayce Duncan------------------------------

aaronb · Answer

Hi Chayce.
The pipeline gets triggered when a "Clone Data" formula URL button on a form gets pressed.&nbsp; 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.&nbsp;

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.&nbsp; 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.&nbsp; I'd deal with creating the child cloned records separately (probably in their own pipeline)

Thanks...Aaron------------------------------Aaron Bab1692@att.com------------------------------

marcelobenavide · Answer

Little video, The button executes a pipeline with many steps (complex) and even when the pipeline is finished I do the redirection.
------------------------------Marcelo Benavides------------------------------

Forum Discussion

Create a record using a Pipeline, then automatically open a Form containing that new record