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?
+22There 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.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
