Button to Add Record via Pipeline, and refresh Record

Hi All,

I am having troubles trying to via a button to add a new record then refresh the current record.

As a button can't trigger a Pipeline, I've created a checkbox field to act as a trigger field. Currently the button uses an API_EditRecord to edit the checkbox and refresh the record. The API_EditRecord triggers my pipeline however the refresh happens before the Pipeline has a chance to complete.

I saw this thread where we can create a HTML Code page to do a pause and refresh.

https://community.quickbase.com/discussions/quickbase-discussions/save-new-record-pause-refresh/19873/replies/19876

I thought I might be able to tag that to the end of my current URL code to run afterwards, however it seems with the record refresh, it never gets to this part.

My current code is as follows.

URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_371=1" & "&apptoken=xxxxxxx" & "&rdr=" & URLEncode( URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()) & URLRoot() & "db/" & Dbid() & "?a=dbpage&pageID="&715 &"&rid=" & [Record ID#]

My question is:

1. Is there a way to get the above code to run all parts or
2. A way via the delay/refresh html code page to edit the checkbox which should trigger the Pipeline then continue with the delay/refresh html script?

I used a Pipeline rather than an API_AddRecord as there are  30+ fields that need to be copied from one table record into another, plus update the record with the button with the related new record ID.

Thanks.