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------------------------------
Original Message:
Sent: 05-04-2023 01:35
From: James van der Walt
Subject: Create copy record then redirect
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
------------------------------