Create copy record then redirect

Question

I'd like to add the Formula URL field to the table so that each record has the "copy" button next to that row. When that button is clicked the Formula URL will first create a copy of that original record, then navigate to the form to edit the newly created record.

How would I do this?

------------------------------
James van der Walt
------------------------------

markshnier__you · Answer

There are different technical alternatives, but under the category of pretty stupid simple (my favourite) try this as a formula URL field.

URLRoot() & "db/" & dbid() & "?a=GenCopyRecord&rid=" & [Record ID#]

That will land you on an ADD Record form with the data entry fields carried forward. Also note that there is a setting on each field as to whether or not a particular field should be copied when using this technique.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

jamesvan_der_wa · Answer

Perfect! That's what I needed! You're a star, thank you &nbsp; Sent from  Mail for Windows &nbsp;

Forum Discussion

Create copy record then redirect

Related Content

create pipeline to create new records based on current record

New Form - Show Create Record button

Custom Record Titles

Add child record through parent form and redirect back to parent form in edit mode

API_GenAddRecord then redirect to a report